Excel MCQ Questions Answers

1. Today is an example of a(n) ____________________ function.

2. To switch to ____ mode, you double-click the cell.

3. To split a merged cell, select the cell and click the ____ button.

4. To select nonadjacent changing cells, press and hold the _______ key as you click each cell.

5. To rotate text in a worksheet, in the format cells dialog box, you can click and drag the ________.

6. To resize an embedded chart, ____.

7. To perform a what-if analysis with more than two input cells, you _______.

8. To keep a workbook displayed in the recent files list in backstage view, you click the ________.

9. To create range names for multiple cells at once, use the ________ tool.

10. To center worksheet data horizontally and vertically on a page, use the ________ dialog box.

11. To add a sort field in the sort dialog box, click the ____ button.

12. To add a blank table to a page, use the table button on the ____ tab.

13. The worksheet is organized into individual cells. _________________________

14. The report layout tools tabs are ____ tabs available only when working with report objects.

15. The insert function dialog box has a(n) ____ option

16. The formula bar displays the value or formula of the active cell. _________________________

17. The find & select button is found in the editing group on the ____ tab on the ribbon.

18. The fields you use to order your data are called sort ____.

19. The default view for a worksheet is ____.

20. The default border color around a chart title is ____.

21. The conditional formatting button provides access to the _____.

22. The code _____ will display the filename of the current workbook.

23. The clear all option in the clear button removes the ____ from the active cell.

24. The best way to apply page setup options to multiple worksheets is to ________.

25. The amount of money being loaned is known as the ____.

26. The accounting number format assigns a floating dollar sign. _________________________

27. The _____ sheet button allows you to add worksheets to a workbook.

28. The ____ is the typeface used to display and print data. it is measured in

29. The ____ identifies which data markers are associated with each data series.

30. The ____ button allows you to move through a formula step by step.

31. The ____ button allows you to erase recent cell entries.

32. The ____ aggregate function finds the smallest value.

33. Select _______ to apply formatting to several cells at the same time.

34. Print all, pages, and selected record(s) are options available from the ____ for printing forms.

35. Placing a chart in a ____ dlls.

36. Only images that are ____ are free for anyone to use without permission.

37. Normal view shows how the worksheet will appear when printed. _________________________

38. Names are ____ to the workbook

39. You would ________ a table if you wanted to display only data that matches specific criteria.

40. You should hold down the ____ key to select the nonadjacent cells.

41. You can use _____ to reference cells within an excel table.

42. You can use ____ to move around in a document that is too large to fit on the screen at once.

43. You can switch to page layout view by clicking the page layout button ____.

44. You can replace a formula with its function so it remains constant.__________

45. You can display the ____ tab to specify page setup options.

46. You can customize a format code in a cell entry to specify how ____ are displayed in a cell.

47. You can click the ____ button to undo an automatic correction.

48. You can add a text box using the chart tools ____ tab.

49. When you type text in a cell it is ________.

50. When you _______ data, you specify which records you want to retrieve using specific criteria.

51. When working with a large worksheet, you can split the window into ____ panes.

52. When formatting a worksheet to be printed, ________ show where page breaks are located.

53. When excel opens, a new blank ________ is displayed.

54. When a cell is part of an active formula, it is surrounded with ________.

55. When a cell contains a(n) ____ reference, it means that one of its defining values is itself.

56. Viewing and printing options for forms and records are available on the ____ tab.

57. The date you change a file is an example of a(n) ____ property.

58. ____ are named combinations of values that are assigned to variables in a model.

59. When you use a range check, you compare a variable to the _____ value in the range.

60. Pseudocode uses the end-structure statement ____ to clearly show where the structure ends.

61. Like other block-level elements, you can ____ tables using the same styles you've already studied.

62. By default, numbers appear in the _____ and generally display values exactly as you type them.

63. You have a column of dog breeds that are in all capital letters. What function would you use to convert those dog breeds so that only the first letter of each word is capitalized?

64. A colleague shared an excel file with you, and you want to display a worksheet that is hidden in it. How you can do that?

65. Your transactions data set contains more than 10,000 rows. Some rows contain the same transaction. How would you remove the rows containing the identical transactions?

66. To insert a new column to the left of a specific column, right-click the header containing the column's letter and select _.

67. Cell D1 contains the value 7.877. You want cell D1 to display the value as 7.9 but keep the original number in calculations. How can yu=ou accomplish this?

68. What is one way to center text in a cell?

69. You want to find the second-largest invoice in a column containing all the invoices in a given month. What function would you use?

70. You want to restrict the values entered in a cell to a specified set, such as Hop, Skip, Jump. Which type of data validation should you use?

71. If a range name is used in a formula and the name is deleted, what happens to the formula?

72. How do you remove only the conditional formatting from a cell and leave all other formatting intact?

73. A file extension of .xlsm indicates what type of workbook?

74. To ensure that a collection of shapes are evenly spaced apart from left to right, select the shapes, click Page Layout > Align, and then click _.

75. Which chart type provides the best visual display of the relationship between two numeric variables?

76. What ribbon command on the Home tab can you use to change a cell's fill color automatically, based on the value of the cell?

77. To split text across cells without using Merge & Center, click Formt Cells. The, on ** Alignment** tab, click**_**.

78. How would you search an entire workbook with Find & Select?

79. Cell A1 contains the number 3. Which formula returns the text Apple?

80. Which formula contains a valid absolute reference?

81. What is the difference between a workbook and a worksheet?

82. How do you remove everything (values, formatting, etc.) from a cell?

83. What is the result of the formula =4&3?

84. How do you remove the background of an inserted image?

85. Before publishing a document, you want to identify issues that may make it difficult for people with disabilities to read. Which feature should you use?

86. Columns D, E, and F are hidden in your worksheet. What is one way to unhide these columns?

87. Which is a valid Excel formula?

88. How can you use Format Painter to apply the format of a single source cell to several nonadjacent destination cells?

89. How can you drill down into a PivotTable to show details?

90. What is the intersection of a worksheet row and column?

91. What is the difference between pressing the delete key and using the clear command in the Home tab's Editing group?

92. In the worksheet shown below, cell C6 contains the formula=VLOOKUP(A6,$F$2:$G$10,2,FALSE). What is the most likely reason that #N/A is returned in cell C6 instead of mallory's ID (2H54)

93. From which field list was the pivotTalble created?

94. Which function returns the number of characters in a text string in cell A1?

95. Which formula calculates the total value of a single row of cells across a range of columns?

96. What is Colors[Inventory] referring to here? =SUMIFS(Colors[Inventory],Colors[Colors],"Orange")

97. An .xlsx workbook is saved into .csv format. What is preserved in the new .csv file?

98. In the formula =VLOOKUP(A1,D1:H30,3,FALSE), the lookup value (A1) is being looked for in _.

99. Cell A2 contains the value 8 and cell B2 contains the value 9. What happens when cells A2 and B2 are merged and then unmerged?

100. The NOW() function returns the current date and time as 43740.665218. Which part of this value indicates the time?