Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
14 Cards in this Set
- Front
- Back
|
When a formula contains references that adjust to the new location, it is referred to as
what type of reference? |
D. Relative cell reference
|
|
|
What method is used in conjunction with the mouse to change the height of a column in
Microsoft Excel 2010? |
D. Click and drag the boundary
|
|
|
Which number format button does NOT appear in the Format group on the Home
ribbon? |
A. 102 (scientific)
|
|
|
Which command appears in the lower right corner of pasted cells and enables the user
to specify how to paste the information? |
B. Paste options
|
|
|
Which feature is a temporary storage location for items that have been copied or cut
from a worksheet? |
D. Clipboard
|
|
|
Which window displays information about an active cell and allows formulas to be
edited? |
A. status bar.
|
|
|
What is the process for selecting all information in a worksheet?
|
C. Right-click a sheet tab, choose Select All from the shortcut menu
|
|
|
What is the black square that appears in the bottom right corner of the cell border to
create a series in multiple cells? |
D. fill handle.
|
|
|
When a formula is copied from one cell to another, what allows the cell address to
adjust the column letter and row number to the new copy location? |
D. Relative cell reference
|
|
|
What adds a range of cells together and divides them by the number of entries?
|
C. average.
|
|
|
How do you copy formatting to different locations in the worksheet?
|
B. Format copier
|
|
|
Which method is used to select non-adjacent worksheet tabs?
|
D. Click a tab, hold down CTRL key and click next tab(s)
|
|
|
What are a predefined set of attributes such as font, font size, and shading?
|
B. Style
|
|
|
Which command in the Print tab backstage view must be selected to print all sheets in a
workbook? |
B. Print entire workbook
|
