Cell reference with only one dollar sign before either the column or the row
A.
mixed cell reference
B.
absolute cell reference
C.
relative cell reference
D.
assumptions
2.
Instructs Excel to adjust the cell reference as it copies it to the destination area
A.
mixed cell reference
B.
absolute cell reference
C.
relative cell reference
D.
fill series
3.
Instructs Excel to keep a cell reference constant in the formula as it copies it to the destination area
A.
mixed cell reference
B.
absolute cell reference
C.
relative cell reference
D.
fill formatting only
4.
Command used to remove cells and data from the worksheet
A.
drag and drop
B.
IF function
C.
copy button
D.
delete
5.
Copies the contents and format of a selected range and places the copy on the clipboard
A.
copy button
B.
copy cells
C.
fill handle
D.
paste button
6.
Copies the item from the clipboard to the destination area
A.
fill series
B.
paste button
C.
fill handle
D.
cut command
7.
Excel copies the cells to the Office clipboard, but does not remove the cells from the source area until you paste the cells in the destination area
A.
clipboard
B.
fill formatting only
C.
cut command
D.
drag and drop
8.
Fill destination area using format of source area. No content is copied unless fill is series.
A.
fill series
B.
copy cells
C.
paste options button
D.
fill formatting only
9.
Fill destination area with contents using format of source area, do not create a series
A.
copy cells
B.
fill formatting only
C.
fill series
D.
assumptions
10.
Fill destination area with series using format of source area
A.
fill formatting only
B.
fill series
C.
copy cells
D.
IF function
11.
Immediately displays when you click the Paste button
A.
range finder
B.
format symbol
C.
paste options button
D.
clipboard
12.
Reserved place in the computer’s memory that allows you to collect text and graphics from an Office document and then paste them into almost any other type of document
A.
freeze the titles
B.
assumptions
C.
paste button
D.
clipboard
13.
Shows the date a workbook was created or the period it represents
A.
date stamp
B.
range finder
C.
format symbol
D.
IF function
14.
Used to copy a cell, range of cells, and create a series
A.
paste button
B.
fill handle
C.
drag and drop
D.
copy cells
15.
Used to ensure correctness in your formulas by checking them
A.
date stamp
B.
absolute cell reference
C.
range finder
D.
delete
16.
Useful when you want to assign a value to a cell based on a logical test
A.
assumptions
B.
fill series
C.
fill handle
D.
IF function
17.
Using the mouse to move or copy cells
A.
drag and drop
B.
freeze the titles
C.
clipboard
D.
cut command
18.
Values in cells that can be changed to determine new values for formulas
A.
IF function
B.
assumptions
C.
fill series
D.
mixed cell reference
19.
When a number is entered with this, Excel immediately displays it with the assigned format
A.
assumptions
B.
paste options button
C.
format symbol
D.
fill formatting only
20.
When used, Excel displays the titles on the screen, no matter how far down or to the right you scroll
