MCQs on MS Excel
1. Through MS Excel, you can _____.
a. Sort data to see it in a different order
b. Filter data to see just pieces of it
c. Use data in formulas to create new data
2. In Office 2007, Microsoft replaced the menus and toolbars with a new interface called _____. a. Quick Access Toolbar b. Office Button d. None of the above
3. To format the contents of your Excel file, from the cell level to the sheet level, you refer to _____. b. Insert tab c. Page Layout tab d. Data tab
4. To work with the data in your sheet by adding formulas to the data, you use _____. a. Insert tab b. Review tab c. Data tab
5. To save a previously saved workbook with a new name or on a different drive,_____.
a. click Save on the File Menu c. press Ctrl+S d. None of the above
6. The default format for files created in Excel 2007 is _____. a. xls c. xltm d. xlsm
7. The extension .xlsm to indicate the Excel files that _____. b. in the binary format
c. contain all the data, document formatting, and formulas in a compress file d. None of the above
8. Before Excel 2007 was released, the number of rows that spreadsheets allowed was _____. b. fixed c. 26
d. There was no limit, just as there is none row
9. You can collapse the Ribbon by double-clicking a tab. b. False
10. Which tab contains the commands for adding content to your worksheet? a. Home tab b. Data tab d. Formulas tab 11. The .xlsx files _____. b. are binary files
c. are files in a proprietary format
d. can be opened only by Excel
12. The Ribbon is made up of which of the following _____. a. Tabs b. Groups c. Buttons
13. Which of these file formats can Excel open? a. xlsx b. xls c. xlsb
14. When cell G55 is selected, which of the following cells can always be reached in one keystroke? a. cell A1
b. The first cell with data in column G d. cell XFD55
15. When sharing files with people who are using other versions of Excel, you will need to _____.
a. send them the .xlsx file, which they will be able to open
b. send them a printout of the file, and tell them to mark it up and you will edit it
d. you cannot share files with people using older versions of Excel
16. When a formatted number does not fit within a cell, it displays _____. b. #DIV/0 c. #DIV@ d. None of these
17. What symbol is used to enter number as text? b. " c. = d. +
18. Which of the following is concatenating operator? a. Apostrophe (') b. Exclamation (!) d. Hash (#)
19. In Excel, functions can be entered using any of the following methods except the _____. b. Keyboard or Mouse
c. Insert Function box in the formula bar
d. AutoSum command on the Formulas tab
20. Using the _____ button on the Ribbon instructs Excel to display additional decimal places in a cell. a. AutoFormat b. Currency Style d. Percent Style
21. Red triangle at the top right corner of a cell indicates_____.
a. There is an error in the cell
c. The font color of the text in cell is red
d. The cell can't accept formula
22. To select multiple non-adjacent cells in a worksheet you will click them holding _____. b. Alt key c. Shift key
23. How many sheets are there in Excel Workbook by default? a. 2 c. 4 d. 5
24. Which of the following component displays the contents of active cell? a. Name box c. Menu bar d. Status bar
25. To move to the previous worksheet press _____. b. Ctrl+PgDn c. Shift+Tab d. Ctrl+Tab
26. A quick way to return to a specific area of a worksheet is to type in the _____. b. Formula bar c. Zoom box d. None of these
27. When Excel starts and blank worksheet displays on the screen, all of the columns have a default width of _____.
b. 64 characters, or 8.43 pixels c. 12.75 points, or 17 pixels d. 17 points, or 12.75 pixels
28. As with column widths, when you decrease the row height to 0, the row is _____.
b. visible temporarily at the top of the worksheet c. deleted
d. visible temporarily on the left side of the worksheet
29. To rename sheets, double-click the sheet tab in the lower-left corner of the window, type the new sheet name and then _____. a. click the Cancel box b. press the Esc key c. click the Name box
30. The individual elements of data, results of functions, and other types of information are stored in: a. sheets b. formulas c. cells
31. Cell references in formulas must be entered in uppercase, and spaces cannot be added before or
after arithmetic operators _____. a. True
32. The Average function requires that the argument (the range) be included within parentheses
before the function name _____.
33. Excel does not allow the contents of a cell to be aligned vertically _____.
34. With conditional formatting, if the value of the cell changes and no longer meets the specified
condition, Excel suppresses the conditional formatting _____. b. False 35. Cell D7 refers to _____.
c. Cell in column D7 and any row
d. Cell in any column and row D7
36. Which spot on a cell would you click and pull down on to use the autofill feature in Excel? a. A b. B c. C
37. What should the mouse cursor look like when you are trying to resize a column of cells? a. A capital I
b. A horizontal line with two arrows coming out of it d. A large white plus
38. The default header for a worksheet is _____. a. Username b. Date and Time c. Sheet tab Name
39. How many sheets are there in Excel?
a. Each document only has one sheet
b. Each document starts with three sheets and you can’t add more
d. There are 65536 sheets in each document
40. Why does the SUM function in B7 show zero?
c. The function contains a circular reference
d. The function is still being edited so hasn’t calculated a result yet
41. You can use a function to combine text from two cells into one cell. But you can use an operator
to do the same thing. Which operator is that? b. = (equal sign) c. (space) d. All of the above
42. The multiplication arithmetic operator is represented by which of the following symbols? a. ^ c. / d. x
43. You can create only a horizontal page break by first selecting _____. b. A cell in row 1 c. A cell in column A d. a and c
44. Given the following image:
The result in cell C3 will be: a. an empty cell d. None of the above
45. Given the following image:
a. The database has been filtered so there must be hidden rows containing other income figures
b. The correct formula for this situation is SUMPRODUCT rather than SUM
d. Incorrect data validation has been used
46. Given the following image:
a. The table should be sorted by employee ID so the values are in numerical order
c. Either of the above will fix the problem
d. The employee ID column of numbers should be formatted in yellow
47. The following formula should show “Fair”, “Good” or “Excellent” depending on the value of A1
but there is an error in the logic. What value produces an incorrect result?
= IF(A1<500,“Fair”,IF(AND(A1>500,A1<1500),“Good”, “Excellent”))
a. A value of 0 will display “Good”
c. A value of 1500 will display “Fair”
d. A value of -500 will display “Excellent”
48. Given the following image:
a. This is what the CellAbove function does
b. CellAbove is a relative range reference
c. CellAbove is an external indirect function
49. When you copy a formula, _____.
a. Excel erases the original copy of the formula
c. Excel adjusts absolute cell references
d. Excel doesn’t adjust relative cell references
50. To copy cell contents using drag and drop press the _____. a. End key b. Shift key d. Esc key
51. Comments can be added to cells using _____. a. Edit > Comments c. File > Comments d. View > Comments
52. Right-click something in Excel _____. a. Deletes the object
b. Nothing the right mouse button is there for left handed people d. Selects the object
53. How can you delete a record?
a. Delete the column from the worksheet
c. Select Data>Delete record from the menu
d. Click the Delete button on the Standard toolbar
54. The cell reference for cell range of G2 to M12 is _____. a. G2.M12 b. G2;M12 d. G2-M12
55. There are three types of data found in a spreadsheet. They are _____. a. data, words, numbers b. equations, data, numbers
56. Which of the following special function keys allow the content in cell? a. Esc b. Shift d. Tab
57. To select a column the easiest method is to _____.
a. Double click any cell in the column
b. Drag from the top cell in the column to the last cell in the column d. Click the column label
58. Formatting a cell in Number format you can’t set _____. a. Decimal places b. Use 1000 separator c. Negative numbers
59. What do these little green icons on the Excel Recent Documents list menu mean?
b. Always show the document on the Recent Documents list
c. Always show the Recent Documents list
d. Increase the number of documents shown in the Recent Documents list by one
60. The headings for columns A, B and C have been changed. How has this been done?
b. Using an Excel 2010 table. This is what happens when you scroll down the page
c. Using Find and Replace advanced settings
d. By applying Excel 2010’s new Conditional Formatting rules
61. What has happened to Excel?
a. It’s operating in Page Layout view
c. It’s showing the sheet in Print Preview mode d. None of the above
62. The Developer Ribbon is hidden by default. Where would you go to make it visible?
b. Office button > Excel Options > Popular
c. Office button > Excel Options > Trust Centre
d. Office button > Excel Options > Formulas
63. What formula would you enter in B16 to show the total for just the person selected on only the date entered?
a. =SUMIFS(Sales,SalesDate,B14,Name,B15)
c. All of the above will produce the correct answer
d. All of the above will produce the wrong answer
64. Which of the following is invalid statement? a. Sheet tabs can be colored
b. Some picture can be applied as a background of a sheet
c. You can set the column width automatically fit the amount of text
65. Using the _____ button on the Ribbon instructs Excel to display additional decimal places in a cell. a. AutoFormat b. Currency Style d. Percent Style
66. Red triangle at the top right corner of a cell indicates _____.
a. There is an error in the cell
c. The font color of the text in cell is red
d. The cell can't accept formula
67. With conditional formatting, if the value of the cell changes and no longer meets the specified
condition, Excel suppresses the conditional formatting _____. b. False
68. Which function will you use to enter current time in a worksheet cell? a. =today() c. =time() d. =currentTime()
69. To select a column the easiest method is to _____.
a. double click any cell in the column
b. drag from the top cell in the column to the last cell in the column d. click the column label
70. By default, pages created in Excel 2007 are created as _____. b. landscape pages
71. You can make the Table Tools tab appear at any time, regardless of whether you are working in a table. a. True
72. Which of the following is a relative address? a. $C16 b. C$16 c. C16
73. Which of the following is the absolute address of a cell? a. $G78 b. G$78 d. $G$78
74. Which of the following refers to the absolute the entire column? b. A$25 c. A25 d. $A$25
75. Which of the following refers to the absolute the entire row? a. $F23 c. F23 d. $F$23
76. When you use the Insert Function button, you need to know the exact function you want to use? a. True
77. Which of the following is not a valid name for a range? a. HappySheetResult c. Date_Of_Ground_Breaking d. YesOrNo
78. Which of the following elements is the only one you should never make invisible? a. Title b. Grid lines d. Legend
79. To change from one chart type to another, you must rebuild the chart from the scratch. a. True
80. When you need to see percentages of a whole, the best kind of chart to use is b. bar chart c. line chart d. bubble chart
81. The order of data in the legend is fixed and cannot be changed. b. False
82. Markers on line charts are always boxes? a. True
83. Trend-lines can be used with which type of chart? a. bar chart c. pie chart d. area chart
84. Everything you can do with a PivotTable, you can also do by hand. b. False
85. Which of the following is not an advantage of using PivotTable? a. Speed
b. Additional understanding of the data d. Flexibility
86. PivotTables can help you analyze inventory data. b. False
87. Which of the following is required for the creation of a PivotTable?
a. Blank lines within the data
c. A connection to an SQL server
d. A minimum of 100 rows of data
88. In the field definitions for a PivotTable, Q1 and Quarter 1 are the same. a. True
89. Which of the following cannot be automatically determined with a PivotTable?
a. The number of times a name appears in a table
b. The sum of the years in a table
c. The minimum number of items sold in a month
90. You can change the visibility of the data in a PivotTable in which of these ways _____.
a. Click the minus sign for a cell in the first column of the table
c. Change the formula for the value cells d. Right-click a value cell
91. Data in a PivotTable cannot be formatted. a. True
92. Changing the visible data for a PivotChart affects _____.
a. only the visible data on that PivotChart
b. the visible data on all PivotCharts
c. the visible data for the current PivotChart and the PivotTable it is based on
93. Which of the following charts cannot be based on a PivotTable? a. line chart b. pie chart
d. None. Any chart type can be created from a PivotTable.
94. You can’t complete which of the following tasks from the Custom List dialog box? a. View any custom lists b. Delete a custom list d. Edit a custom list
95. You can filter only on numeric data. a. True
96. Which of the following does not prevent Excel from grouping and outlining your data?
a. No labels are defined for the data set
b. Empty cells are in the data set
c. You have empty rows of data
97. Which one of these examples has duplicate cell content? a. Jenny and jenny b. 99.00 and 99 d. sixty and 60
98. All columns in a sheet must be checked for duplicates at the same time. a. True
99. Duplicate data can be valid data. b. False 100. Error circles _____.
a. can be applied to more than one sheet at a time
b. stay active when a file is closed
d. can be different colors at different times
101. Input messages can be set to be shown _____. a. tothe left of the cell c. whenever a cell is blank
d. always, no matter whether the cell is selected
102. Data lists for a validation rule can be on a different sheet from the data. a. True
103. When are consolidation results refreshed?
b. Whenever the file is opened
c. Whenever the data used for the consolidation is changed
d. When the consolidation sheet is copied
104. Which of the following statements is true?
b. Cells in multiple sheets can be changed during the creation of a single scenario
c. Formulas can be used to define the change to a cell when creating a scenario
d. Cells containing formulas can be used as the by changing cell of a goal
105. Only five cells can be used to create a single scenario. a. True
106. Goal Seek always finds an answer. a. True
107. All answers found by Goal Seek are valid. a. True
108. Which of the following situations prevents you from being able to create an exponential trend- line?
a. Too many data points are in the series
b. Negative data points are in the series
d. Too much of a difference exists between data points in the series
109. By default, how far in the future does a Linear Forecast Trend-line reach? a. One month c. Three months d. Four months
110. How many series of data are charted with a pie chart? b. Two c. Three d. Four
111. Which addressing method is used when you create an advanced filter _____. a. relative addressing
112. Only _____ can be consolidated.