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.

TEACHERS / EDUCATORS
Log In | Sign Up / Register

Help / Support / FAQ




Gaming Links