Excel Chapter 2 Review Question Preview (ID: 27622)
Review For Chapter 2.
TEACHERS: click here for quick copy question ID numbers.
A _______ is a prewritten formula that is built into Excel.
a) function
b) feature
c) task
d) calculation
All of the following are valid Excel arithmetic operators except
a) @
b) +
c) -
d) /
Which of the following calculations multiplies .01 by 20?
a) =20%
b) =20
c) =20 + .01
d) =21-.01
The adjusted cell references in a copied and pasted formula are called _____ references
a) relative
b) related
c) pasted
d) alternative
Click this to undo an automatic correction
a) AutoCorrect Options
b) Auto Fill Options
c) Paste Options
d) Trace Error
What Option button gives options for filling cells FOLLOWING a fill operation?
a) Auto Fill Options
b) AutoCorrect Options
c) Insert Options
d) Paste Options
This Options button lists error-checking options following the assignment of an invalid formula to a cell.
a) Trace error
b) Fix error
c) Find error
d) Explain Error
This Option button lists formatting options following an INSERTION of cells, rows, or columns.
a) Insert
b) AutoCorrect
c) AutoFill
d) Paste
The ________ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign.
a) Formula
b) Function
c) Equal
d) Calculate
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) Left parenthesis
c) right bracket
d) left bracket
What is the default width of a cell?
a) 8.43
b) 7.52
c) 11.65
d) 9.43
When the row height is ______, the row is hidden.
a) O
b) 1
c) 2
d) 3
The most popular background color is ____.
a) Blue
b) Grey
c) Red
d) Rose
Use this to check which cells are referenced in the formula assigned to the active cell.
a) Range finder
b) Formula finder
c) Claculation Finder
d) Function Finder
Left justified, fixed dollar sign.
a) Accounting style
b) Currency style
c) Comma style
d) Percent style
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
Which of these guidelines should you use when creating an new workbook?
a) All of the above
b) Determine the neccesary formulas and functions
c) Identify how to format various elements of the worksheet
d) Specify how the hard copy of the worksheet should appear
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
Dollar sign appears immediately to the left of the # (also called floating $)
a) Currency style
b) Accounting style
c) Comma style
d) Percent style
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
Play Games with the Questions above at ReviewGameZone.com
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 27622 in the upper right hand corner or click here.
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 27622 in the upper right hand corner or click here.
TEACHERS / EDUCATORS
Log In | Sign Up / Register
Log In | Sign Up / Register