Microsoft Excel Vocats Test Modules 1-4
12. A table name can have up to ______ characters. Fill in the blank space.
255
71. When you cut data from a cell, Excel adds it to the ______________________________ Fill in the blank space.
Clipboard
64. Ctrl+C is the keyboard shortcut to ______________________ data? Fill in the blank space.
Copy
86. When a cell or a range has a defined name, what is that known as? Select all that apply. a. Range b. Named range c. Named cell d. Defined cell
B and C
58. You can find Freeze panes on the _______________ tab. Fill in the blank space.
View
10. Which of the following options cannot be part of a range name? Select the correct option. a. Space b. Number c. Period d. Underscore
A
60. Which of the following statements are true? Select the correct option. a. The Quick Access Toolbar can be moved to beneath the ribbon b. The Quick Access Toolbar cannot be reset to default settings c. The Quick Access Toolbar cannot be moved beneath the ribbon d. The Quick Access Toolbar cannot be hidden from view
A
72. Which of these methods can you use to insert a new row in a worksheet? Select all that apply. a. Right-click or access the context menu for a row number, select Insert b. Right-click or access the context menu for a column header, select Insert c. Right-click or access the context menu for a cell, select Insert Entire Row d. Home, Cells group, Insert > Insert Sheet Rows
A and D
78. Which of these methods can you use to set the width of a row in a worksheet? Select all that apply. a. Select Format in the Cells group and select AutoFit Row Height b. Right-click on a row header and select Column Height c. Double-click between a column divider to make it AutoFit d. Right-click on a row header and select Row Height
A and D
36. Which of the following styles are built-in cell styles in Excel? Select all that apply. a. Calculation b. Chart c. Warning Text d. Comma
A, C, D
59. Which of the following commands does not belong to the Windows group on the View tab? Select the correct option. a. Hide b. Split c. Zoom d. Arrange All
C
65. What is the keyboard shortcut to cut data from a cell? Select the correct option. a. Ctrl+C b. Ctrl+D c. Ctrl+X d. Ctrl+Z
C
66. To paste copied data from horizontal to vertical, which option would you use from Paste Special? Select the correct option. a. Values b. Formulas c. Transpose d. Formatting only
C
26. A ____________ provides the capability to select the arrow in the column header to narrow the data. Fill in the blank space.
Filter button
17. What are the steps you need to take to turn the Filter button on or off? Select all that apply. a. Go to the Design tab, Table Styles Options group, and then select/clear the Filter button. b. Go to the Home tab, Editing group, Sort & Filter, and select Filter. c. Go to the Data tab, Sort & Filter group, and then select Filter. d. With a table cell selected, right-click or access the context menu, select Filter, and then select either Clear Filter from, or Reapply.
A, B, C
40. The types of alignment for contents of a cell include: Select all that apply a. Horizontal b. Vertical c. Italic d. Rotation
A, B, D
56. The Quick Access Toolbar has which commands by default? Select all that apply. a. AutoSave b. Save As c. Undo d. Redo
A, C, D
21. What keyboard shortcut can you use to turn on or turn off a Total Row at the end of the table? Select the correct option. a. Ctrl+F b. Ctrl+Shift+T c. Ctrl+Shift+F d. Ctrl+T
B
41. To display text in a cell turned on its side or on an angle, you change the ___________. Select the correct option to fill in the blank space. a. Position b. Orientation c. Wrapping d. Margins
B
5. Which command displays data in an alphabetized or numerical order? Select the correct option. a. Filter b. Sort c. Replace d. Arrange All
B
39. When you need a selection of cells to have only the original default formatting, you should use the _______________________ command. Fill in the blank space.
Clear Formats
18. What is the default name for a new table? Select the correct option. a. Header row b. Total row c. Banded row d. Footer row
B
91. Which is the correct shortcut to access the Replace feature? Select the correct option. a. Ctrl+G b. Ctrl+H c. Ctrl+R d. Ctrl+I
B
29. Which command creates a table and simultaneously applies a table style? Select the correct option. a. Insert Table b. Data Table c. Format as Table d. From Table/Range
C
30. Which ribbon tab contextually appears when a cell in a table is selected? Select the correct option. a. Format b. Analyze c. Design d. View
C
92. When you are in the Excel application, what method can you use to save an existing workbook with a different name? Select all that apply. a. F11 b. File > Save c. F12 d. File > Save As
C and D
96. Select the ___________________ next to the formula bar to complete a data entry into a cell and remain in the same cell. Fill in the blank.
Check mark
14. You can name a range with a right-click or using the context menu. Select the correct option. a. True b. False
A
103. To create a new workbook: Select all that apply. a. Go to File > New b. Select Ctrl+N on your keyboard c. Select Ctrl+O on your keyboard d. Go to File > Open
A and B
61. Instead of removing all the commands you added to the Quick Access Toolbar, you can use the _______________________ tool to set it back to only the default commands. Fill in the blank space.
Reset
20. The command ______________ provides a way to select additional rows and columns to include in an existing table. Fill in the blank space.
Resize Table
25. What keyboard shortcut can you use to insert a table? Select the correct option. a. Ctrl+T b. Ctrl+Shift+= c. Ctrl+Shift+L d. Ctrl+Shift+-
A
6. Which command provides a way to sort with multiple levels? Select the correct option. a. Custom Sort b. Sort A to Z c. Sort Z to A d. Sort Smallest to Largest e. Sort Largest to Smallest
A
62. In the bottom left corner of the Microsoft Excel interface which of the following screen views are not available? Select the correct option. a. Print preview b. Page break preview c. Page layout d. Normal
A
7. A filter based on cell color can be applied to a column. Select the correct option. a. True b. False
A
73. Which of these methods can you use to set the width of a column in a worksheet? Select the correct option. a. Double-click between a column divider to make it AutoFit b. Select the divider between 2 rows and drag up or down c. Right-click or access the context menu for a column header and select Row Height d. Select Format in the Cells group and select Row Height
A
76. Which is the correct shortcut to copy a worksheet to another sheet in the same workbook? Select the correct option. Select the sheet to copy, then use a. Ctrl, drag and drop b. Select the sheet to copy, then use drag and drop c. Select the sheet to copy, then use Shift, drag and drop d. Select the sheet to copy, then use Alt, drag and drop
A
79. To insert a row into a worksheet, you can select the row header and use which of the following keyboard shortcuts? Select the correct option. a. Ctrl+Plus sign (+) b. Ctrl+Hyphen (-) c. Ctrl+Asterisk (*) d. Ctrl+Slash (/)
A
82. If cell A1 contained the number 1 and you used AutoFill to fill the cells automatically down to A20, what number would be in cell A20? Select the correct option a. 20 b. 10 c. 2 d. 1
A
90. You can use the Replace feature to find specific formatting and replace with different formatting. True or false? Select the correct option. a. True b. False
A
94. By default, when you select Enter to complete a cell entry, where will the active cell be? Select the correct option. a. In the row below b. In the row above c. In the next cell to the left d. In the next cell to the right
A
34. Where would you use Headings cell styles? Select all that apply. a. Cells at the top of a column of data b. Cells that label rows of data c. Cells that contain totals d. Cells that contain comments
A and B
2. Which of the following options are choices in the Sort Options dialog box? Select all that apply. a. Case sensitive b. Delete level c. Orientation d. Copy level
A and C
31. Which of the following options are table style categories? Select all that apply. a. Light b. Standard c. Dark d. Custom
A and C
87. Which of the following shortcuts can you use to highlight cells containing formulas? Select all that apply. a. F5 b. F6 c. F4 d. Ctrl+G
A and D
13. Which of the following fields create a named range? Select all that apply. a. Name Box b. Create from Selection c. Define Name d. Name Manager
All of the above
57. You can customize the Quick Access Toolbar via which method? Select all that apply. a. Right-click or access the context menu of a button on the ribbon and add it b. Right-click or access the context menu on the ribbon and select Customize Quick Access Toolbar c. On the File tab, select Options, and then select the Quick Access Toolbar d. Right-click or access the context menu on top of a button on the Quick Access Toolbar and remove it
All of the above
3. The filter choice _____ displays only empty cells. Fill in the blank space.
Blank
22. On which tab can you find the Insert Sheet Columns and Insert Sheet Rows commands? Select the correct option. a. Page Layout b. Insert c. Home d. View
C
67. The keyboard shortcut to access the Paste Special dialog box is: Select the correct option. a. Ctrl+Alt+A b. Ctrl+V c. Ctrl+Alt+V d. Ctrl+Shift+P
C
49. To display a cell's value with a money symbol and two decimal places, you would apply a ___________________________ number format. Fill in the blank space.
Currency, or Accounting
8. A __________ is created to sort by any other characteristic that doesn't sort well alphabetically. Fill in the blank space.
Custom List
11. What is the default name for a new table? Select the correct option. a. Table_1 b. Table 1 c. Table.1 d. Table1
D
43. Which formatting feature for alignment will put contents of a cell on multiple lines within the same cell? Select the correct option. a. Long Date b. Indent c. Increase Font Size d. Wrap Text
D
23. The __________ check box displays special formatting for the first column of the table. Fill in the blank space.
First column
47. To center a title on a worksheet across multiple columns, use the _______________ feature. Fill in the blank space.
Merge & Center and/or Center Across Selection
42. You can align cell contents centered over multiple columns with _______________. Fill in the blank space.
Merge & Center, and Center Across Selection
84. The Find command is located on the Find & _________________________ button on the Home tab Fill the blank space.
Select
99. The _________________________ key moves one cell position to the right of the currently selected cell. Fill in the blank.
Tab or right arrow
44. The alignment setting that makes a paragraph of text flow on multiple lines in one cell is ___________________. Fill in the blank space.
Wrap Text
9. A range can be named in the Name Box. Select the correct option. a. True b. False
A
89. If you used AutoFill to fill Jan from cell A1 across to L1, which of the following AutoFill options will be available to select? Select all that apply. a. Copy cells b. Fill formatting only c. Fill without formatting d. Fill months
All of the above
102. How can you access Backstage view? Select the correct option a. Windows key b. Select File c. Select Home d. Ctrl+B
B
19._________ are even rows that are formatted differently than odd rows. Fill in the blank space.
Banded rows
101. Which area of the Excel application has the following three commands: Save, Undo, and Redo? Select the correct option. a. Status Toolbar b. Mini Toolbar c. Quick Access Toolbar d. Formula Bar
C
103. Where will you find the formula bar? Select the correct option. a. File > Open b. File > Options c. Directly below the ribbon d. On the Quick Access Toolbar
C
97. Which format can a workbook be saved in? Select all that apply. a. .xlsx b. .xlxs c. .xls d. .xlsm
A, C, D
63. To display more than one workbook on the screen at the same time, you would use the ___________________________ command. Fill in the blank space.
Arrange All
15. The ___________ command is where a named range can be created, edited, and deleted. Fill in the blank space.
Name Manager
46. When you have a column name that is much longer than the data in the column's values, what options make it possible to display the entire name without making the column wider? Select all that apply. a. Apply Wrap Text to the column name. b. Indent the column name. c. Change the worksheet margins. d. Rotate the column name text.
A and D
16. You can access a table from which of the following areas? Select all that apply. a. Find b. Name Box c. Go To
B and C
53. In the Munson's List of Events on the EventsList worksheet, which number format does the data in the Year column need? Select the correct option. a. Short Date b. Accounting c. Long Date d. General (no specific format)
D
35. Cell styles can help you to ________________. Select all that apply. a. Keep consistency in formatting b. Make your worksheets easier to read c. Apply formatting more quickly d. Perform calculations
A, B, C
68. When you've copied data, which of the following is a correct method to paste it somewhere else? Select all that apply. a. Select where you want to paste the data, and then select enter on your keyboard. b. Right-click or access the context menu for where you want to paste the data, and select Paste. c. Select where to paste, and then select Ctrl+V. d. Right-click or access the context menu for where you want to paste the data, and then select Paste here.
A, B, C
38. What kinds of formatting can be included in cell styles? Select all that apply. a. Font Size b. Margins c. Fill Color d. Text Alignment
A, C, D
48. Which of the following options can you use to format the contents of a cell? Select all that apply. a. Font Size b. Sort c. Italic d. Underline
A, C, D
74. When you select all the columns in your worksheet and double-click on a column divider, that is known as ______________________________ Fill in the blank.
AutoFit
100. When you are in the Excel application, what shortcut key can you use to open an existing workbook? Select the correct option. a. Ctrl+Alt+O b. Ctrl+O c. Shift+O d. Ctrl+Shift+O
B
50. Two of the main format options for a cell's appearance are: Select the correct option. a. Fill Color and Table. b. Border and Fill Color. c. Page Layout and Border. d. Print Layout and Fill Color.
B
52. Which command do you use to change the color of a cell background? Select the correct option. a. Background color b. Fill color c. Border color d. Font color
B
55. How can you most efficiently copy all Font, Cell, Alignment, and Number formatting from one cell to multiple other cells? Select the correct option. a. Select the one cell with the formatting that you want to copy, select the Copy c command, select the other cells, and then select the Paste command. b. Select the one cell with the formatting that you want to copy, double-click the Format Painter command, select the other cells, then select the Format Painter command to turn it off. c. Select the one cell with the formatting that you want to copy, use the Format Cells command, and then select the other cells. d. Select the one cell with the formatting that you want to copy, select and hold Ctrl while you select the other cells, and then select the Format Painter command.
B
85. What is the keyboard shortcut to search for data in a workbook? Select the correct option. a. Ctrl+E b. Ctrl+F c. Ctrl+G d. F5
B
1. Which ribbon command clears the filter and the sort state for the current range of data? Select all that apply. a. Home ribbon, Editing group, Clear Formats b. Data ribbon, Sort & Filter, Clear c. Home ribbon, Editing group, Sort & Filter, Clear d. Data ribbon, Sort & Filter, Reapply
B and C
98. Which statement is true? Select all that apply. a. There is no difference between using Convert or using Save As to upgrade a workbook to the latest version of Excel. b. Converting a file replaces the old version file with a new version file, leaving one copy. c. When a file is converted, you'll be able to use the full functionality of Excel. d. A file saved in an older version of Excel cannot be opened in Excel 2019.
B and C
77. Which of the following processes can you use to rename a worksheet? Select all that apply. a. Right-click in any blank cell and select Rename Sheet. b. Right-click on the sheet tab and select Rename. c. Select Format in the Cells group and select Edit Sheet Name. d. Select Format in the Cells group and select Rename Sheet.
B and D
70. Which statement is true? Select all that apply. a. When you've right-clicked or accessed the context menu on a cell where you want to paste data, Paste Special is not available on the context menu. b. When you've right-clicked or accessed the context menu on a cell where you want to paste data, you can select Paste Special on the context menu. c. When you've copied data, you can access Paste Special using Ctrl+Alt+V. d. The Paste Special button can be found on the Paste drop-down arrow on the Home tab.
B, C, D
24. ___________ are even columns formatted differently than odd columns. Fill in the blank space.
Banded columns
27. What option is a unique combination of borders and shading to change the appearance of the table? Select the correct option. a. Themes b. Effects c. Styles d. Colors
C
28. A table can be converted to which of the following? Select the correct option. a. Chart b. PivotTable c. Data range d. SmartArt
C
33. Where on the ribbon will you find cell styles? Select the correct option. a. Home tab, Font group b. Page Layout tab, Themes group c. Home tab, Styles group d. Insert tab, Illustrations group
C
45. To position text equally between the top and bottom of a cell, which alignment setting would you use? Select the correct option. a. Merge cells b. Orientation c. Vertical alignment d. Shrink to fit
C
75. To delete a column in a worksheet, you can select the column header and use which of the following keyboard shortcuts: Select the correct option. a. Ctrl+Plus sign (+) b. Ctrl+Slash (/) c. Ctrl+Hyphen (-) d. Ctrl+Asterisk (*)
C
81. What is the keyboard shortcut to go to elements of a workbook? Select all that apply. a. Ctrl+E b. Ctrl+F c. Ctrl+G d. F5
C and D
88. If you used AutoFill to fill Quarter 1 into cell A1 down to A5, what would the contents of A5 contain? Select the correct option. a. Quarter 5 b. Quarter 3 c. Quarter 4 d. Quarter 1
D
93. If you save an Excel workbook as a 97-2003 version, what will the file extension be? Select the correct option. a. .xlsx b. .xlxs c. .xlt d. .xls
D
95. When you enter data into a cell, where else on-screen will what you have entered display? Select the correct option. a. The cell below b. The cell above c. The ribbon d. The formula bar
D
83. If cell A1 contained January and you used AutoFill to fill the cells automatically across to L1, the contents of L1 would be __________________________ Fill the blank space.
December
54. To make text and numbers inside a cell larger, you need to use the _____________________________ formatting option. Fill in the blank space.
Font Size and Increase Font Size
51. The _____________________________ tool allows you to copy formatting from one selection and paste it onto another selection. Fill in the blank space.
Format Painter
32. A ____________ row is automatically included by default when a table is inserted. Fill in the blank space.
Header
4. Each _____ determines the order a custom sort displays the data. Fill in the blank space.
Level
80. The box directly under the ribbon, on the left side of the screen, is known as the __________________ box. Fill the blank space.
Name
37. If you have a cell at the bottom of a column that adds up all the numbers in the column, you might apply the ___________________ cell style. Fill in the blank space.
Total
69. The option that allows you to copy data that is vertical and paste it horizontally is known as _____________________ Fill in the blank space.
Transpose
