Question 1

You can ensure correctness in your formulas by carefully checking them using ____.

Accepted Answer

A) Range Finder 
B) the ribbon 
C) the requirements document 
D) the Standard toolbar 
A) Range Finder 
B) the ribbon 
C) the requirements document 
D) the Standard toolbar

Question 2

George runs a mid-size accounting practice and recently upgraded to Excel 2011.He expects sales to grow in the next few months during tax season.After that, he would like to begin upgrading some of the equipment and furniture for the employees in his office.He will start with the Reception area, which has the most visibility.In George's Sales Data worksheet, the result for a formula in cell H14 is ######.What should George do?

Accepted Answer

A) increase the width of column H 
B) provide a correct argument or operand 
C) run the calculation again to find the available value 
D) replace the incorrect formula in cell H14 with one that does not divide by zero 
A) increase the width of column H 
B) provide a correct argument or operand 
C) run the calculation again to find the available value 
D) replace the incorrect formula in cell H14 with one that does not divide by zero

Question 3

The fill handle allows creation of a series of all of the following EXCEPT ____.

Accepted Answer

A) month names 
B) dates 
C) numbers 
D) historical sales figures 
A) month names 
B) dates 
C) numbers 
D) historical sales figures

Question 4

A(n)____________________ is a good way to compare visually a small set of numbers.

Accepted Answer

The answer of A(n)____________________ is a good way to compare...

Question 5

A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area.

Accepted Answer

A) True 
 B)False

Question 6

The range of entries that determines the size of the slices in a Pie chart is called the category names.

Accepted Answer

A) True 
 B)False

Question 7

The Copy button copies the contents and format of the source area to the ____, a reserved place in the computer's memory.

Accepted Answer

A) ribbon 
B) clipboard 
C) folder 
D) file 
A) ribbon 
B) clipboard 
C) folder 
D) file

Question 8

Bea is the best pie baker around.She has decided to go into business and takes a survey in her town to find out what types of pies are favorites.She decides to record her data in a worksheet she can present to the bank when she seeks a loan for her business startup costs.Bea wants to add a 3-D Pie chart to her workbook in which each slice represents the popularity of different types of pies she plans to sell.Bea wants to emphasize that apple pie is the most favorite type of pie.Which of the following is the best design approach to emphasize the apple pie slice?

Accepted Answer

A) Do nothing because Excel emphasizes the most important slice automatically 
B) Explode the apple pie slice 
C) Move the chart to the upper-left corner of the chart sheet 
D) Change the color of the apple pie slice 
A) Do nothing because Excel emphasizes the most important slice automatically 
B) Explode the apple pie slice 
C) Move the chart to the upper-left corner of the chart sheet 
D) Change the color of the apple pie slice

Question 9

The error message #NULL! specifies an invalid intersection of two areas.

Accepted Answer

A) True 
 B)False

Question 10

Which of the following is not a valid format symbol?

Accepted Answer

A) semi-colon (;) 
B) percent sign (%) 
C) dollar sign ($) 
D) comma (,) 
A) semi-colon (;) 
B) percent sign (%) 
C) dollar sign ($) 
D) comma (,)

Question 11

Press ____ to select cell A1.

Accepted Answer

A) CONTROL-FN-LEFT ARROW 
B) OPTION-F1 
C) CONTROL-F2 
D) COMMAND-FN 
A) CONTROL-FN-LEFT ARROW 
B) OPTION-F1 
C) CONTROL-F2 
D) COMMAND-FN

Question 12

Match between columns
                        Premises: Scrutinizes the impact of changing values in cells that are referenced by a formula in another cell.

Accepted Answer

The Answer of Fill Series and Fill Formatting Only and is...

Question 13

Match between columns
                        Premises: Pastes the contents and format of the source area.

Accepted Answer

The Answer of Fill Series and Keep Source Formatting and is...

Question 14

The Format Painter button appears in the ____.

Accepted Answer

A) Home tab 
B) Standard toolbar 
C) Options tab 
D) Format tab 
A) Home tab 
B) Standard toolbar 
C) Options tab 
D) Format tab

Question 15

The error message #NULL! indicates the use of a name that Excel does not recognize.

Accepted Answer

A) True 
 B)False

Question 16

AND, OR, and NOT are called ____________________ operators.

Accepted Answer

The answer of AND, OR, and NOT are called ____________________...

Question 17

A ____ is a separate sheet in a workbook that contains only a chart.

Accepted Answer

A) worksheet 
B) dialog box 
C) chart sheet 
D) range 
A) worksheet 
B) dialog box 
C) chart sheet 
D) range

Question 18

A(n)____ chart provides a simple way to show trends and variations in a range of data within a single cell.

Accepted Answer

A) Sparkie 
B) Sparkline 
C) Special 
D) Sparkle 
A) Sparkie 
B) Sparkline 
C) Special 
D) Sparkle

Question 19

Which of the following deletes selected cells, but does not shift any other cells to compensate?

Accepted Answer

A) the DELETE command 
B) the Delete Cells command 
C) the DELETE button on the Home tab 
D) Either A or C 
A) the DELETE command 
B) the Delete Cells command 
C) the DELETE button on the Home tab 
D) Either A or C

Question 20

A sensitivity analysis is another name for a(n)____________________.

Accepted Answer

The answer of A sensitivity analysis is another name for...

You can ensure correctness in your formulas by carefully checking them using ____.

The fill handle allows creation of a series of all of the following EXCEPT ____.

A(n)____________________ is a good way to compare visually a small set of numbers.

A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area.

The range of entries that determines the size of the slices in a Pie chart is called the category names.

The Copy button copies the contents and format of the source area to the ____, a reserved place in the computer's memory.

The error message #NULL! specifies an invalid intersection of two areas.

Which of the following is not a valid format symbol?

Press ____ to select cell A1.

The Format Painter button appears in the ____.

The error message #NULL! indicates the use of a name that Excel does not recognize.

AND, OR, and NOT are called ____________________ operators.

A ____ is a separate sheet in a workbook that contains only a chart.

A(n)____ chart provides a simple way to show trends and variations in a range of data within a single cell.

Which of the following deletes selected cells, but does not shift any other cells to compensate?

A sensitivity analysis is another name for a(n)____________________.

Introduction to Computers

Microsoft Office 2011 and Mac Os X Lion

Excel: Creating a Worksheet and an Embedded Chart

Excel: Formulas, Functions, and Formatting

Outlook: Managing E-Mail Messages With Outlook

Outlook: Managing Calendars

Powerpoint: Creating and Editing a Presentation With Clip Art

Powerpoint: Enhancing a Presentation With Pictures, Shapes, and Wordart

Powerpoint: Reusing a Presentation and Adding Media

Word: Creating, Formatting, and Editing a Word Document With Pictures

Word: Creating a Research Paper With Citations and References

Filters

Exam 5: Excel: What-If Analysis, Charting, and Working With Large Worksheets

You can ensure correctness in your formulas by carefully checking them using ____.

The fill handle allows creation of a series of all of the following EXCEPT ____.

A(n)____________________ is a good way to compare visually a small set of numbers.

A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area.

The range of entries that determines the size of the slices in a Pie chart is called the category names.

The Copy button copies the contents and format of the source area to the ____, a reserved place in the computer's memory.

The error message #NULL! specifies an invalid intersection of two areas.

Which of the following is not a valid format symbol?

Press ____ to select cell A1.

The Format Painter button appears in the ____.

The error message #NULL! indicates the use of a name that Excel does not recognize.

AND, OR, and NOT are called ____________________ operators.

A ____ is a separate sheet in a workbook that contains only a chart.

A(n)____ chart provides a simple way to show trends and variations in a range of data within a single cell.

Which of the following deletes selected cells, but does not shift any other cells to compensate?

A sensitivity analysis is another name for a(n)____________________.

Introduction to Computers

Microsoft Office 2011 and Mac Os X Lion

Excel: Creating a Worksheet and an Embedded Chart

Excel: Formulas, Functions, and Formatting

Outlook: Managing E-Mail Messages With Outlook

Outlook: Managing Calendars

Powerpoint: Creating and Editing a Presentation With Clip Art

Powerpoint: Enhancing a Presentation With Pictures, Shapes, and Wordart

Powerpoint: Reusing a Presentation and Adding Media

Word: Creating, Formatting, and Editing a Word Document With Pictures

Word: Creating a Research Paper With Citations and References

Filters