Click on the correct response for each question below.
 |
1 |  |  To access the Formula Auditing toolbar, choose
|
|  | A) | View/Toolbars/Formula Auditing.
|
|  | B) | Tools/Auditing/Formula Auditing.
|
|  | C) | Data/Formula Auditing.
|
|  | D) | View/Auditing/Formula Auditing
|
 |
 |
2 |  |  If a cell contains an error, you can access the Trace Error functions by
|
|  | A) | right-clicking the cell and choosing Trace Error.
|
|  | B) | clicking the cell and choosing Tools/Trace Error.
|
|  | C) | clicking the cell and choosing Help/Error Help.
|
|  | D) | clicking the cell and then clicking the Trace Error smart tag.
|
 |
 |
3 |  |  The warning style that displays Retry and Cancel buttons is
|
|  | A) | Warning.
|
|  | B) | Error.
|
|  | C) | Stop.
|
|  | D) | Information.
|
 |
 |
4 |  |  You can check for faulty data that was entered before Data Validation rules were in place by
|
|  | A) | reapplying the Data Validation rule.
|
|  | B) | choosing Data/Validation.
|
|  | C) | clicking the Circle Invalid Data button on the Formula Auditing toolbar.
|
|  | D) | choosing Format/Conditional Formatting.
|
 |
 |
5 |  |  When a formula is inconsistent with formulas above and below it, the cell will display what error?
|
|  | A) | #IF!
|
|  | B) | #I/F!
|
|  | C) | #FORM!
|
|  | D) | No error message will display, but the cell will be flagged
|
 |
 |
6 |  |  The keyboard shortcut for opening the Paste Name dialog box is
|
|  | A) | F1.
|
|  | B) | F2.
|
|  | C) | F3.
|
|  | D) | F4.
|
 |
 |
7 |  |  To remove all of the groupings created by AutoOutline, choose
|
|  | A) | Data/Ungroup.
|
|  | B) | Data/Group and Outline/Clear Outline.
|
|  | C) | Data/Group and Outline/Ungroup.
|
|  | D) | Data/Group and Outline/AutoOutline.
|
 |
 |
8 |  |  Which of the following is not an available function when using automatic subtotals?
|
|  | A) | SUM
|
|  | B) | RND
|
|  | C) | MIN
|
|  | D) | COUNT NUMS
|
 |
 |
9 |  |  Which of the following list of column headings would produce faulty data in a PivotTable?
|
|  | A) | Egg sales quarterly, Egg sales yearly, Egg cost quarterly, Egg cost yearly
|
|  | B) | Egg sales, Quarterly, Yearly, Egg cost, Quarterly, Yearly
|
|  | C) | January, February, March, April
|
|  | D) | Quarterly sales, Quarterly cost
|
 |
 |
10 |  |  Which of the following chart types cannot be used for a PivotChart?
|
|  | A) | bar
|
|  | B) | line
|
|  | C) | bubble
|
|  | D) | column
|
 |
 |
11 |  |  In a PivotChart, to show only certain items from a field, you must first
|
|  | A) | alter the underlying PivotChart.
|
|  | B) | sort the PivotChart.
|
|  | C) | start the Chart Wizard.
|
|  | D) | uncheck the (Show All) option.
|
 |