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;
24 Cards in this Set
- Front
- Back
2 What method is used in conjunction with the mouse to change the height of a column in
Microsoft Excel 2010? |
D. Click and drag the boundary
|
|
6 What command on the Home ribbon allows the user to search for AND replace specific
text in a worksheet are? |
C. Find
|
|
11 Which command in the Print tab backstage view must be selected to print all sheets in a
workbook? |
B. Print entire workbook
|
|
14 Where is the command to create a new folder in the user's storage device for Microsoft
Excel 2010 files located? |
D. File tab, open button
|
|
15 Which window displays information about an active cell and allows formulas to be
edited? |
A. status bar.
|
|
18 Which Microsoft Excel 2010 feature automatically inserts data into a cell that begins
with the same characters as a previous entry? |
A. AutoComplete
|
|
22 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? |
D. Relative cell reference
|
|
28 How do you add a border to worksheet cells?
|
B. Select cells and choose the Border command from the Home ribbon
|
|
29 How do you copy formatting to different locations in the worksheet?
|
B. Format copier
|
|
35 The command on the Page Layout ribbon that refers to data printed on the top of each
worksheet page is the: |
A. header.
|
|
36 What is the data printed on the bottom of each worksheet page?
|
B. footer.
|
|
37 The feature allows the user to organize data numerically is:
|
B. sort & filter.
|
|
39 What is the moving dashed line that appears around the cells when selected called?
|
D. Marquee
|
|
58. The only way to copy a worksheet in a workbook is to use the copy command on the
shortcut menu. |
False
|
|
65. Labels are right aligned.
|
False
|
|
67. A point is 1/75 of an inch
|
True
|
|
84. The quickest method to hide a column or row in a worksheet it to select the column or
row and choose hide from _____. |
c. Shortcut menu
|
|
86. The _____ command allows information to repeat on each printed page.
|
d. print titles
|
|
87. Page breaks may be manually inserted using the breaks command on the _____ ribbon.
|
c. Home
|
|
88. An entire worksheet may be hidden by choosing hide on the _____.
|
a. Sheet tab shortcut menu
|
|
89. Which of the following is NOT an appropriate worksheet tab name?
|
a. Employees
|
|
90. When the insert worksheet command is selected, where is the new sheet inserted?
|
a. To the left of all sheets
|
|
91. Which of the following is NOT a freeze panes option?
|
b. Freeze current area
|
|
93. _____ temporarily hides records that do not meet a specific criterion.
|
d. Filtering data
|