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;
17 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?
|
Click and drag the boundary
|
|
|
How do you add a border to worksheet cells?
|
Select cells and choose the Border command from the Home ribbon
|
|
|
How do you copy formatting to different locations in the worksheet?
|
Format copier
|
|
|
If a worksheet contains data that you do not want to be viewed, what method is used to remove the data from worksheet view without permanently deleting the data?
|
Hide
|
|
|
Which feature in Microsoft Excel 2010 allows a user to place a restriction on and
temporarily isolate specific data in a worksheet? |
Sort & Filter
|
|
|
Which command appears in the lower right corner of pasted cells and enables the user to specify how to paste the information?
|
Paste options
|
|
|
Which command in the Print tab backstage view must be selected to print all sheets in a
workbook? |
Print entire workbook
|
|
|
The feature allows the user to organize data numerically is
|
sort & filter.
|
|
|
Which window displays information about an active cell and allows formulas to be
edited? |
status bar.
|
|
|
The area of the Microsoft Excel that contains the view and zoom buttons is known as
the |
status bar.
|
|
|
Which method is used to select non-adjacent worksheet tabs?
|
Click a tab, hold down CTRL key and click next tab(s)
|
|
|
What is the process for selecting all information in a worksheet?
|
Right-click a sheet tab, choose Select All from the shortcut menu
|
|
|
What are a predefined set of attributes such as font, font size, and shading?
|
Style
|
|
|
Which feature automatically corrects common typographical errors?
|
AutoSpell
|
|
|
What is the black square that appears in the bottom right corner of the cell border to
create a series in multiple cells? |
fill handle
|
|
|
What key will allow the user to select non-adjacent cells?
|
CTRL key
|
