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
calculation
D
task
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
C
=21-.01
D
=20 + .01
4) The adjusted cell references in a copied and pasted formula are called _____ references
A
pasted
B
related
C
alternative
D
relative
5) Click this to undo an automatic correction
A
Auto Fill Options
B
Trace Error
C
AutoCorrect Options
D
Paste Options
6) What Option button gives options for filling cells FOLLOWING a fill operation?
A
Insert Options
B
Paste Options
C
Auto Fill Options
D
AutoCorrect 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
Find error
D
Explain Error
8) This Option button lists formatting options following an INSERTION of cells, rows, or columns.
A
AutoFill
B
AutoCorrect
C
Paste
D
Insert
9) The ________ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign.
A
Equal
B
Calculate
C
Formula
D
Function
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 parenthesis
D
right bracket
11) What is the default width of a cell?
A
11.65
B
9.43
C
7.52
D
8.43
12) When the row height is ______, the row is hidden.
A
3
B
1
C
O
D
2
13) The most popular background color is ____.
A
Red
B
Rose
C
Grey
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
Comma style
B
Percent style
C
Accounting 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
Page layout
B
Full screen
C
Normal
D
Page break preview
17) Which of these guidelines should you use when creating an new workbook?
A
Determine the neccesary formulas and functions
B
All of the above
C
Identify how to format various elements of the worksheet
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
Pastes just formatting
B
Pastes just formulas
C
Pastes an exact copy of what you copied including contents and formatting
D
All of the above
19) Dollar sign appears immediately to the left of the # (also called floating $)
A
Percent style
B
Currency style
C
Accounting style
D
Comma style
20) You can apply this to one or more cells based on the value of the cell.
A
Formulas version
B
Spell checker
C
Conditonal formatting
D
Point mode
*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?