Excel Exam Flashcards
Which of the following error values indicates that the formula uses unrecognized text such as a misspelled function, sheet, or range name?
- #NUM!
-#NAME?
- #NULL!
- #DIV/0
NAME?
When you first create an Excel table, how is it named?
- TableA, where A is a letter
- TableC, where C is a character
- TableN, where N is a number
- TableS, where S is a symbol
TableN, where N is a number
In an Excel Table, which of the following represents a row of data?
-header row
-field
-record
-cell
record
How does excel treat dates when sorting?
- as text
- as values
- as filters
- as criterion
as values
Which command links workbooks?
- Scenario Manager
- Data Table
- Share Workbook
- Consolidate
Consolidate
In an advanced filter, how does excel criteria entered in different rows?
- AND condition
- OR condition
- FILTER condition
- BOTH condition
OR condition
Which of the following terms is a restriction or limitation when creating a solver problem?
-Objective cell
-Target cell
-Decision cell
-Constraint
Constraint
What is another name for rows that alternate fills or borders?
-striped rows
-banded rows
-lined rows
-ruled rows
banded rows
Which data consolidation method is used when data in multiple worksheets is arranged differently but has the same row and column labels?
- Consolidation by position
- Consolidation by category
- Consolidation by summary
- Consolidation by worksheet
Consolidate by category
A map chart is a one-dimensional chart that displays low-level geographic details?
True or False
False
Which of the following cell addresses does not change when copied?
- F2
- $F$2
- $F2
- F$2
$F$2
Which of the following groups of sheets in workbook?
- Press Ctrl+A
- Press Shift+A
- Right click any sheet tab and choose Select All Sheets
- Click the Merge command on the Home tab
Right click any sheet tab and choose Select All Sheets
