• Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

Card Range To Study

through

image

Play button

image

Play button

image

Progress

1/33

Click to flip

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;

33 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
On multi-page worksheets, what page layout option should you choose in order to have information repeated along the top of each page and make the data easily readable?
Rows to repeat at the top
The command on the Page Layout ribbon that refers to data printed on the top of each
worksheet page is the:
Header
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
What is the proper procedure for deleting an unwanted worksheet from a workbook?
Right-click the unwanted sheet tab and choose Delete from the shortcut menu
Which command in the Print tab backstage view must be selected to print all sheets in a
workbook?
Print entire workbook
Where are user created styles able to be used?
In all of Microsoft Excel 2010
When a formula contains references that adjust to the new location, it is referred to as what type of reference?
Relative cell reference
Which window displays information about an active cell and allows formulas to be
edited?
status bar
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
On multi-page worksheets, what page layout option should you choose in order to have information repeated along the top of each page and make the data easily readable?
Rows to repeat at the top
The command on the Page Layout ribbon that refers to data printed on the top of each
worksheet page is the:
Header
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
What is the proper procedure for deleting an unwanted worksheet from a workbook?
Right-click the unwanted sheet tab and choose Delete from the shortcut menu
Which command in the Print tab backstage view must be selected to print all sheets in a
workbook?
Print entire workbook
Where are user created styles able to be used?
In all of Microsoft Excel 2010
Which window displays information about an active cell and allows formulas to be
edited?
status bar
Which Microsoft Excel 2010 feature automatically inserts data into a cell that begins
with the same characters as a previous entry?
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?
Relative cell reference
What key will allow the user to select non-adjacent cells?
CTRL key
What adds a range of cells together and divides them by the number of entries?
average
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
What allows the user to control the amount of space between the data and the edge of the paper?
Margin
What controls the landscape or portrait print function?
Orientation
What do you insert into a worksheet to cause the data to start on a new page when
printing?
Page Break
What determines what part of a worksheet prints?
Print area
The command on the Page Layout ribbon that refers to data printed on the top of each
worksheet page is the:
header
Which is an advantage of using Styles to apply formatting to a workbook?
Styles ensure consistent formatting from one workbook to the next