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;
35 Cards in this Set
- Front
- Back
In Microsoft Excel 2010, which is a
graphical representation of data that is created from information in a workbook |
Chart
|
|
Which command in the Print tab backstage
view must be selected to print all sheets in a workbook? |
Print entire workbook
|
|
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
|
|
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 |
|
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 built-in Microsoft Excel 2010
feature ensures that data entered into a cell range of cells is within limits |
Validation
|
|
When entering data into a cell, which
keyboard key is used to remove characters to the right of the insertion point |
Delete key
|
|
What is the proper method for adding
(inserting) columns into a worksheet |
Click the Insert button on the Home
ribbon and choose the Insert Column option |
|
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
|
|
When entering data into a cell, which
keyboard key is used to remove characters to the right of the insertion point |
Delete key
|
|
When saving a file in Microsoft Excel 2010,
which symbol is NOT to be used in the file name |
/ (forward slash)
|
|
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 |
|
Where are user created styles able to be
used? |
In the workbook for which they are
created |
|
Which command in the Print tab backstage
view must be selected to print all sheets in a workbook |
Print entire workbook
|
|
What command on the Home ribbon allows
the user to search for AND replace specific text in a worksheet are |
Find
|
|
Which Microsoft Excel 2010 feature
automatically inserts words, numbers, or formulas that are a part of a series |
AutoFil
|
|
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 Microsoft Excel 2010 feature
automatically inserts data into a cell that begins with the same characters as a previous entry |
AutoComplete
|
|
Which Microsoft Excel 2010 feature
automatically inserts words, numbers, or formulas that are a part of a series |
AutoFill
|
|
In Microsoft Excel 2010, a single character,
word, or phrase is referred to as the |
String
|
|
What command on the Home ribbon allows
the user to search for AND replace specific text in a worksheet are |
Find
|
|
Which feature in Microsoft Excel 2010
allows a user to place a restriction on and temporarily isolate specific data in a worksheet |
Sort & Filter
|
|
In Microsoft Excel 2010, a single character,
word, or phrase is referred to as the |
String
|
|
When saving a file in Microsoft Excel 2010,
which symbol is NOT to be used in the file name |
/ (forward slash)
|
|
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
|
|
Where are user created styles able to be
used? |
In the workbook for which they are
created |
|
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. |
|
When saving a file in Microsoft Excel 2010,
which symbol is NOT to be used in the file name |
/ (forward slash)
|
|
Which command in the Print tab backstage
view must be selected to print all sheets in a workbook |
Print entire workbook
|
|
When entering data into a cell, which
keyboard key is used to remove characters to the right of the insertion point |
Delete key
|
|
What command on the Home ribbon allows
the user to search for AND replace specific text in a worksheet are? |
Find
|
|
In Microsoft Excel 2010, a single character,
word, or phrase is referred to as the: |
String
|
|
Where are user created styles able to be
used? |
In the workbook for which they are
created |