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;
43 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?
|
D. 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
|
|
Which number format button does NOT appear in the Format group on the Home ribbon?
|
A. 102 (scientific)
|
|
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:
|
A. Header.
|
|
What command on the Home ribbon allows the user to search for AND replace specific text in a worksheet are?
|
C. 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
|
|
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 feature is a temporary storage location for items that have been copied or cut from a worksheet?
|
D. Clipboard
|
|
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?
|
B. Print entire workbook
|
|
Which command is used on the Home ribbon to apply a style to selected cells in a workbook?
|
. Cell styles
|
|
Where are user created styles able to be used?
|
In all of Microsoft Excel 2010
|
|
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
|
|
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.
|
|
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?
|
. AutoComplete
|
|
Which feature automatically corrects common typographical errors?
|
. AutoSpell
|
|
Which symbol must be keyed in first to signify that a formula is being typed into an active cell?
|
. = (equal sign)
|
|
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.
|
|
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
|
|
Which command on the Home ribbon is used to center the text across combined cells?
|
. Merge & Center
|
|
What adds a range of cells together and divides them by the number of entries?
|
average.
|
|
What function finds the best, greatest or largest value in a range?
|
max.
|
|
Which function will find the fewest, least or lowest value in a selected area?
|
. Min
|
|
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.
|
|
What is the data printed on the bottom of each worksheet page?
|
B. footer.
|
|
The feature allows the user to organize data numerically is:
|
. sort & filter.
|
|
When opening a new workbook, how many worksheets are loaded automatically?
|
Three
|
|
What is the moving dashed line that appears around the cells when selected called?
|
Marquee
|
|
Which method is used to select non-adjacent worksheet tabs?
|
. Click a tab, hold down CTRL key and click next tab(s
|
|
Which term refers to a group of selected cells?
|
. Range
|
|
What are a predefined set of attributes such as font, font size, and shading?
|
. Style
|
|
Which is an advantage of using Styles to apply formatting to a workbook?
|
. Styles ensure consistent formatting from one workbook to the next
|