Have an account?
Skip to Content
Build your own quiz
Suggestions for you
Instructional Technology
9th -
12thgrade
ICEV Excel Check for Understanding
10 questions
Show Answers
See Preview
- 1. Multiple Choice
Which of the following shows the location of the cell which has been selected? A. B. C. D.
Cell name box
Dialog box
Formula bar
Worksheet tab
- 2. Multiple Choice
Which of the following are composed of a grid system of rows and columns which cross to make cells?
Formulas
Graphs
Table guides
Worksheets
- 3. Multiple Choice
Which of the following allows data to fit the column width?
Gridlines
Page Break Preview
Page Layout
Text Wrapping
- 4. Multiple Choice
Which of the following is the correct formula to add cells A1 and B2? A. B. C. D.
A1+B2
=A1+B2
SUM(A1:B2)
=$A1,$B2
- 5. Multiple Choice
The data types appear in which group on the Home tab?
Illustrations
Insert
Numbers
Text
- 6. Multiple Choice
Which of the following cell references is read as “cell A1 through D6?"
A1,D6
A1!D6
A1$D6
A1:D6
- 7. Multiple Choice
Which of the following automatically applies formatting to one or more cells based on a specific condition?
Conditional Formatting
Criterion
Filtering
Sorting
- 8. Multiple Choice
Which of the following CANNOT be used as a math operator in a formula? A. B. C. D.
* asterisk
: colon
+ plus sign
/ slash
- 9. Multiple Choice
An IF Function is an example of which type of function?
Date & Time
Financial
Logical
Text
- 10. Multiple Choice
After inserting a table, a _____________ tab will appear in the ribbon with a Table Tools label.
Design
Format
Insert
Layout
- Answer choicesTagsAnswer choicesTags