20 questions
A ____ is a prewritten formula that is built into Excel.
function
feature
task
calculation
A(n) ____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.
contiguous
indexed
direct
indirect
All of the following are valid Excel arithmetic operators EXCEPT ____.
^
*
%
>
Which of the following calculations multiplies 23 by 0.01?
=23%
=23
=23+.01
=24-.01
When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra
placement
operations
positioning
selections
When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.
40
26
48
13
Which of the following happens when you enter the formula =G15 into a cell?
Excel recalculates all formulas in the worksheet
Excel assigns the sum of the values in the previous 15 cells to the active cell
Excel assigns the value in cell G15 to the active cell
Nothing; =G15 is an invalid formula
The adjusted cell references in a copied and pasted formula are called ____ cell references.
related
relative
pasted
alternative
You can click the ____ button to undo an automatic correction
Auto Fill Options
AutoCorrect Options
Paste Options
Trace Error
Which of the following Option buttons gives options for filling cells following a fill operation?
Auto Fill Options
AutoCorrect Options
Insert Options
Paste Options
Cell references in a formula are called ____.
assumptions
comments
numbers
content
When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values.
logical
constant
consistent
calculated
The ____ Auto Fill Option that fills the destination area using the format of the source area; no content is filled.
Copy Cells
Fill Formatting Only
Fill Without Formatting
none of the above
Which of the following Auto Fill Options menu options is the same as the Fill Series option?
Fill Months
Fill Without Formatting
Fill Formatting Only
Copy Cells
Which of the following cell contents is extended to Qtr3, Qtr4, and Qtr1 by dragging the fill handle?
Quarter 1
Qtr1
Qtr2
Quarter4
Which of the following is an extension of the fill pattern Sunday, Tuesday?
Wednesday, Thursday, Saturday
Thursday, Saturday, Monday
Saturday, Sunday, Monday
Monday, Wednesday, Friday
The Increase Indent button indents the contents of a cell to the right by ____ spaces each time you click it.
two
three
four
five
The Copy button copies the contents and format of the source area to the Office ____, a temporary storage area in the computer’s memory.
Ribbon
Clipboard
Folder
File
In the context of copying a range of cells to a nonadjacent location, an alternative to clicking the Paste button is to press the ____ key.
ENTER
ALT
CTRL
SHIFT
Using the mouse to move or copy cells is called ____.
drop and drag
drag and drop
drag and copy
drag and paste