Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

You should use a ____ chart to compare values side by side,broken down by category.

Accepted Answer

A)  Column 
B)  Bar 
C)  Line 
D)  Clustered Column

Question 3

The ____________________ at the bottom of the Fill Color and Font Color buttons changes to the most recently selected color.

Accepted Answer

The answer of The ____________________ at the bottom of the...

Question 4

You can nest IF functions as deep as you want,but after you get beyond a nest of three IF functions,the logic becomes difficult to follow.

Accepted Answer

A) True 
 B)False

Question 5

The ____ function is useful when you want to assign a value to a cell based on a logical test.

Accepted Answer

A)  IF 
B)  NOW 
C)  AND 
D)  OR

Question 6

Which of the following formulas contains an absolute cell reference?

Accepted Answer

A)  =$B4 
B)  =B$4 
C)  =$B$4 
D)  =B4

Question 7

After shrinking entries to fit in cells,consider using the ____ slider on the status bar to make the entries more readable.

Accepted Answer

A)  View 
B)  Preview 
C)  Display 
D)  Zoom

Question 8

A date stamp shows the date a workbook,report,or other document was created or the time period it represents.

Accepted Answer

A) True 
 B)False

Question 9

The ____________________ function is useful when you want to assign a value to a cell based on a logical test.

Accepted Answer

The answer of The ____________________ function is useful when you...

Question 10

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.
-If sales reach a certain amount by the end of April,George will purchase a desk,chair,computer,and software upgrade for the receptionist.Otherwise,George will just purchase the desk and chair.How can George determine the best action to take using a Sales Data worksheet?

Accepted Answer

A)  Copy and paste all his Sales data formulas with relative references 
B)  Add an IF function formula to his Sales data worksheet 
C)  Add the NOW function formula to his Sales data worksheet 
D)  Copy and paste all his Sales data formulas with absolute references

Question 11

The Linked Pictures option in the Paste Options gallery copies an image of the source area as a picture so that a change to the cells in the source area updates the picture in the destination area.

Accepted Answer

A) True 
 B)False

Question 12

You can create your own ____________________ fill sequences for use with the fill handle.

Accepted Answer

The answer of You can create your own ____________________ fill...

Question 13

You can press the ____ keys to open the Format Cells dialog box.

Accepted Answer

A)  CTRL+1 
B)  CTRL+2 
C)  CTRL+3 
D)  CTRL+4

Question 14

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Pastes the contents,format,and styles of the source area.

Accepted Answer

A) NOW function 
B) Fill Formatting Only 
C) goal seeking 
D) what-if analysis 
E) NUM!
F)#NAME?
G)Keep Source Formatting
H)Fill Series
I)IF function
J)absolute cell referencing

Question 15

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Assigns a value to a cell based on a logical test.

Accepted Answer

A) NOW function 
B) Fill Formatting Only 
C) goal seeking 
D) what-if analysis 
E) NUM!
F)#NAME?
G)Keep Source Formatting
H)Fill Series
I)IF function
J)absolute cell referencing

Question 16

You can replace a formula with its function so it remains constant._________________________

Accepted Answer

A) True 
 B)False

Question 17

When the Paste Options button is visible,you can use ____________________ to access the paste commands available in the Paste Options gallery.

Accepted Answer

The answer of When the Paste Options button is visible,you...

Question 18

____________________ are values in cells that can be changed to determine new values for formulas.

Accepted Answer

The answer of ____________________ are values in cells that can...

Question 19

In the context of copying a range of cells to a nonadjacent location,an alternative to clicking the Paste button is to press the ____ key.

Accepted Answer

A)  ENTER 
B)  ALT 
C)  CTRL 
D)  SHIFT

Question 20

When assigned to a cell,the ____ function returns a number that corresponds to the system date and time beginning with December 31,1899.

Accepted Answer

A)  SYSDATE 
B)  NOW 
C)  DATETIME 
D)  CURRENT

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

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

You should use a ____ chart to compare values side by side,broken down by category.

The ____________________ at the bottom of the Fill Color and Font Color buttons changes to the most recently selected color.

You can nest IF functions as deep as you want,but after you get beyond a nest of three IF functions,the logic becomes difficult to follow.

The ____ function is useful when you want to assign a value to a cell based on a logical test.

Which of the following formulas contains an absolute cell reference?

After shrinking entries to fit in cells,consider using the ____ slider on the status bar to make the entries more readable.

A date stamp shows the date a workbook,report,or other document was created or the time period it represents.

The ____________________ function is useful when you want to assign a value to a cell based on a logical test.

The Linked Pictures option in the Paste Options gallery copies an image of the source area as a picture so that a change to the cells in the source area updates the picture in the destination area.

You can create your own ____________________ fill sequences for use with the fill handle.

You can press the ____ keys to open the Format Cells dialog box.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Pastes the contents,format,and styles of the source area.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Assigns a value to a cell based on a logical test.

You can replace a formula with its function so it remains constant._________________________

When the Paste Options button is visible,you can use ____________________ to access the paste commands available in the Paste Options gallery.

____________________ are values in cells that can be changed to determine new values for formulas.

In the context of copying a range of cells to a nonadjacent location,an alternative to clicking the Paste button is to press the ____ key.

When assigned to a cell,the ____ function returns a number that corresponds to the system date and time beginning with December 31,1899.