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
function
B
feature
C
task
D
calculation
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
B
=20 + .01
C
=20%
D
=21-.01
4) The adjusted cell references in a copied and pasted formula are called _____ references
A
alternative
B
relative
C
related
D
pasted
5) Click this to undo an automatic correction
A
Trace Error
B
Paste Options
C
AutoCorrect Options
D
Auto Fill Options
6) What Option button gives options for filling cells FOLLOWING a fill operation?
A
Paste Options
B
Insert Options
C
AutoCorrect Options
D
Auto Fill Options
7) This Options button lists error-checking options following the assignment of an invalid formula to a cell.
A
Fix error
B
Trace error
C
Explain Error
D
Find 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
Formula
B
Equal
C
Function
D
Calculate
10) Excel automatically appends (adds) the ________ to complete the AVERAGE function when you click the Enter box or press the ENTER key.
A
Right parenthesis
B
right bracket
C
Left parenthesis
D
left bracket
11) What is the default width of a cell?
A
9.43
B
8.43
C
7.52
D
11.65
12) When the row height is ______, the row is hidden.
A
O
B
3
C
2
D
1
13) The most popular background color is ____.
A
Blue
B
Rose
C
Red
D
Grey
14) Use this to check which cells are referenced in the formula assigned to the active cell.
A
Function Finder
B
Range finder
C
Formula finder
D
Claculation Finder
15) Left justified, fixed dollar sign.
A
Comma style
B
Accounting style
C
Percent style
D
Currency style
16) This view allows you to create or modify a worksheet while viewing how it will look in printed format.
A
Normal
B
Page break preview
C
Page layout
D
Full screen
17) Which of these guidelines should you use when creating an new workbook?
A
All of the above
B
Identify how to format various elements of the worksheet
C
Determine the neccesary formulas and functions
D
Specify how the hard copy of the worksheet should appear
18) Which of the following actions are provided by the Paste Options button?
A
All of the above
B
Pastes an exact copy of what you copied including contents and formatting
C
Pastes just formulas
D
Pastes just formatting
19) Dollar sign appears immediately to the left of the # (also called floating $)
A
Accounting style
B
Comma style
C
Percent style
D
Currency style
20) You can apply this to one or more cells based on the value of the cell.
A
Spell checker
B
Formulas version
C
Point mode
D
Conditonal formatting
*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?