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
|
The command on the Page Layout ribbon
that refers to data printed on the top of each worksheet page is the |
Header
|
|
|
Which command is used on the Home
ribbon to apply a style to selected cells in a workbook |
Cell styles
|
|
|
Microsoft Excel 2010, which is a
graphical representation of data that is created from information in a workbook |
Chart
|
|
|
button appears when cells are filled
with data in a series |
AutoFill options
|
|
|
Where is the command to create a new
folder in the user's storage device for Microsoft Excel 2010 files located? |
File tab, open button
|
|
|
What method is used in conjunction with
the mouse to change the height of a row in Microsoft Excel 2010? |
Click and drag the boundary line between
rows |
|
|
Which built-in Microsoft Excel 2010
feature ensures that data entered into a cell range of cells is within limits? |
Validation
|
|
|
When a formula contains references that
allow both the address to adjust and the reference to remain constant, what is this type of reference considered? |
Mixed cell reference
|
|
|
Which command is used on the Home
ribbon to apply a style to selected cells in a workbook? |
Cell styles
|
|
|
Which command in the Print tab backstage
view must be selected to print all sheets in a workbook? |
Print entire workbook
|
|
|
Other than using Microsoft Excel 2010 as a
spreadsheet tool, what other function can it serve? |
Database tool
|
|
|
Since cells in a chart are linked to the data
in the worksheet, how would you update data on a chart? |
Change the data on the corresponding
worksheet, and the chart will automatically be updated. |
|
|
What command on the Home ribbon allows
the user to search for AND replace specific text in a worksheet are? |
Find
|
|
|
Which built-in Microsoft Excel 2010
feature ensures that data entered into a cell range of cells is within limits? |
Validation
|
|
|
When saving a file in Microsoft Excel 2010,
which symbol is NOT to be used in the file name? |
/ (forward slash)
|
|
|
When entering data into a cell, which
keyboard key is used to remove characters to the right of the insertion point? |
Delete key
|
|
|
Which Microsoft Excel 2010 feature
automatically inserts data into a cell that begins with the same characters as a previous entry? |
AutoComplete
|
