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;
10 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? |
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
|
|
|
What command on the Home ribbon allows the user to search for AND replace specific
text in a worksheet are? |
Find
|
|
|
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?
|
Right-click a sheet tab, choose Select All from the shortcut menu
|
|
|
Which Microsoft Excel 2010 feature automatically inserts data into a cell that begins
with the same characters as a previous entry? |
A. AutoComplete
|
|
|
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
|
|
|
How do you copy formatting to different locations in the worksheet?
|
B. Format copier
|
|
|
37 The feature allows the user to organize data numerically is:
|
B. Four
|
|
|
Which is an advantage of using Styles to apply formatting to a workbook?
|
A. Styles ensure consistent formatting from one workbook to the next
|
