Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Excel Chapter 2 Review
Test Description: Review for chapter 2
Instructions: Answer all questions to get your test result.
1) A _______ is a prewritten formula that is built into Excel.
A
calculation
B
feature
C
task
D
function
2) All of the following are valid Excel arithmetic operators except
A
+
B
/
C
@
D
-
3) Which of the following calculations multiplies .01 by 20?
A
=20 + .01
B
=20
C
=21-.01
D
=20%
4) The adjusted cell references in a copied and pasted formula are called _____ references
A
related
B
pasted
C
alternative
D
relative
5) Click this to undo an automatic correction
A
Trace Error
B
Auto Fill Options
C
Paste Options
D
AutoCorrect Options
6) What Option button gives options for filling cells FOLLOWING a fill operation?
A
Auto Fill Options
B
AutoCorrect Options
C
Paste Options
D
Insert Options
7) This Options button lists error-checking options following the assignment of an invalid formula to a cell.
A
Find error
B
Explain Error
C
Trace error
D
Fix error
8) This Option button lists formatting options following an INSERTION of cells, rows, or columns.
A
AutoCorrect
B
Insert
C
Paste
D
AutoFill
9) The ________ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign.
A
Calculate
B
Formula
C
Function
D
Equal
10) Excel automatically appends (adds) the ________ to complete the AVERAGE function when you click the Enter box or press the ENTER key.
A
Left parenthesis
B
left bracket
C
right bracket
D
Right parenthesis
11) What is the default width of a cell?
A
8.43
B
9.43
C
11.65
D
7.52
12) When the row height is ______, the row is hidden.
A
3
B
2
C
O
D
1
13) The most popular background color is ____.
A
Red
B
Grey
C
Rose
D
Blue
14) Use this to check which cells are referenced in the formula assigned to the active cell.
A
Formula finder
B
Range finder
C
Function Finder
D
Claculation Finder
15) Left justified, fixed dollar sign.
A
Percent style
B
Currency style
C
Accounting style
D
Comma style
16) This view allows you to create or modify a worksheet while viewing how it will look in printed format.
A
Full screen
B
Page layout
C
Normal
D
Page break preview
17) Which of these guidelines should you use when creating an new workbook?
A
Identify how to format various elements of the worksheet
B
All of the above
C
Specify how the hard copy of the worksheet should appear
D
Determine the neccesary formulas and functions
18) Which of the following actions are provided by the Paste Options button?
A
Pastes just formulas
B
Pastes just formatting
C
All of the above
D
Pastes an exact copy of what you copied including contents and formatting
19) Dollar sign appears immediately to the left of the # (also called floating $)
A
Percent style
B
Currency style
C
Comma style
D
Accounting style
20) You can apply this to one or more cells based on the value of the cell.
A
Conditonal formatting
B
Spell checker
C
Point mode
D
Formulas version
*select an answer for all questions
Check Results & Get Answers
Play Games with the Questions Above
Teachers: Create FREE classroom games with your questions
Click for more info!
©2007-2024
ReviewGameZone.com
|
About
|
Privacy
|
Contact
|
Terms
|
Site Map
WAIT! Find what you needed?
×
Still Looking for the Answers?
Have Another Question?
Play a Review Game with These Questions?
Want to Make Your Own Test Like This One?