Question 1

If formulas located in other cells reference cells in a deleted row or column,Excel does not adjust these cell references but instead displays the ____ error message.

Accepted Answer

A)  #NULL! 
B)  #DIV/0! 
C)  #N/A 
D)  #REF!

Question 2

The ____ Auto Fill Option that fills the destination area using the format of the source area;no content is filled.

Accepted Answer

A)  Copy Cells 
B)  Fill Formatting Only 
C)  Fill Without Formatting 
D)  none of the above

Question 3

Which of the following is the path to the Goal Seek button?

Accepted Answer

A)  (INSERT tab | Goal Seek group) 
B)  (HOME tab | Data Tools group) 
C)  (DATA tab | Data Tools group) 
D)  (ANALYSES tab | Goal Seeking group)

Question 4

____ text often provides a strong visual appeal.

Accepted Answer

A)  Launched 
B)  Tiny 
C)  Logical 
D)  Rotated

Question 5

Which of the following is the path to the Increase or Decrease Indent button?

Accepted Answer

A)  (HOME tab | Clipboard group) 
B)  (HOME tab | Editing group) 
C)  (HOME tab | Alignment group) 
D)  (HOME tab | Number group)

Question 6

If you enter 90 in the Degrees box in the ____ area of the Format Cells dialog box,the text will appear vertically and read from bottom to top in the cell.

Accepted Answer

A)  Position 
B)  Orientation 
C)  Slope 
D)  Incline

Question 7

When Excel cannot calculate a formula,it displays an error message in a cell.

Accepted Answer

A) True 
 B)False

Question 8

The Increase Indent button indents the contents of a cell to the right by three spaces each time you click it.

Accepted Answer

A) True 
 B)False

Question 9

Case 3-2
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 is new to using Excel,however,and she would like to become conversant in the keyboard shortcuts for the options available in the Paste Options gallery to expedite her work.
-Bea finished adding the results of her survey to a worksheet in her new workbook,including the number of people who voted for each type of pie.If in manipulating the worksheet she wants to copy the contents and formatting of a source area but not the formula,which keyboard shortcut will she use?

Accepted Answer

A)  CTRL+R 
B)  CTRL+A 
C)  CTRL+E 
D)  CTRL+W

Question 10

Excel allows you to ____________________ the titles so that the titles remain on the screen no matter how far down or to the right you scroll.

Accepted Answer

The answer of Excel allows you to ____________________ the titles...

Question 11

You know Excel is in Copy mode when a small plus sign appears next to the block arrow mouse pointer during a(n)____________________ operation.

Accepted Answer

The answer of You know Excel is in Copy mode...

Question 12

____ refers to cells not wide enough to display the entire entry.

Accepted Answer

A)  ##### 
B)  &&&&& 
C)  $$$$$ 
D)  +++++

Question 13

The ____________________ option on the Auto Fill Options menu fills the destination area with a series that uses the format of the source area.

Accepted Answer

The answer of The ____________________ option on the Auto Fill...

Question 14

A cell reference with only one dollar sign before either the column or the row is called an absolute reference.

Accepted Answer

A) True 
 B)False

Question 15

Case 3-1
George runs a mid-size accounting practice and recently upgraded to Excel 2013.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

Question 16

Error messages begin with the ____ symbol.

Accepted Answer

A)  (?) 
B)  = 
C)  ! 
D)  #

Question 17

Exploding worksheet columns and rows is a useful technique for viewing large worksheets that extend beyond the window._________________________

Accepted Answer

A) True 
 B)False

Question 18

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 19

You can press the CTRL+ACCENT MARK(`)keys to display the formulas in a worksheet._________________________

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A)  section 
B)  sparkline 
C)  special 
D)  sparkle

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

If formulas located in other cells reference cells in a deleted row or column,Excel does not adjust these cell references but instead displays the ____ error message.

The ____ Auto Fill Option that fills the destination area using the format of the source area;no content is filled.

Which of the following is the path to the Goal Seek button?

____ text often provides a strong visual appeal.

Which of the following is the path to the Increase or Decrease Indent button?

If you enter 90 in the Degrees box in the ____ area of the Format Cells dialog box,the text will appear vertically and read from bottom to top in the cell.

When Excel cannot calculate a formula,it displays an error message in a cell.

The Increase Indent button indents the contents of a cell to the right by three spaces each time you click it.

Excel allows you to ____________________ the titles so that the titles remain on the screen no matter how far down or to the right you scroll.

You know Excel is in Copy mode when a small plus sign appears next to the block arrow mouse pointer during a(n)____________________ operation.

____ refers to cells not wide enough to display the entire entry.

The ____________________ option on the Auto Fill Options menu fills the destination area with a series that uses the format of the source area.

A cell reference with only one dollar sign before either the column or the row is called an absolute reference.

Error messages begin with the ____ symbol.

Exploding worksheet columns and rows is a useful technique for viewing large worksheets that extend beyond the window._________________________

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

You can press the CTRL+ACCENT MARK(`)keys to display the formulas in a worksheet._________________________

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