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.
|
|