MS Excel MCQ Quiz for Government Exams - Part 3

1.The Spelling Tool is placed in ________ Tab.

2.Formatting a cell in Currency, you can specify

3. If you need a text to show vertically in a cell. How will you achieve this?

4.You can automatically adjust the size of text in a cell if they do not fit in width by

5.Which of the cell pointer indicate that you can make selection

6.Which of the cell pointer indicate that you can fill series

7.Which one is the last column header in Excel 2019?

8.How can you remove borders applied in cells?

9.You can set page border in excel from

10.Which of the following you can paste selectively using Paste Special Command?

11.Paste Special allows some operations while you paste to new cell. Which of the following operation is valid?

12.Comments put in cells are called

13.Which of the following is not true regarding Conditional formatting?

14.Getting data from a cell located in a different sheet is called

15.What happens when you press Ctrl + X after selecting some cells in Excel?

16.In EXCEL, you can sum a large range of data by simply selecting a tool button called…?

17.Which function is not available in the consolidate dialog box?

18.Which language is used to create macros in Excel?

19.Which tool you will use to join some cells and place the content at the middle of joined cell?

20. How can you set 0.5 inch indentation for a cell in Excel

21.Merge cells option can be applied from

22.You can auto fit the width of column by

23.Selecting the column G & H then choose Insert by right clicking, What will happen?

24.How to restrict the values of a cell so that only whole numbers between 9 and 99 can be entered in a cell.

25.If particular workbook have to open each time When Excel started, where that workbook should be placed?

26.If the values in A1 is “MCQ” and B1 is “Questions”, Which function will return “MCQ@Questions” in cell C1?

27.What does COUNTA() function do?

28.What is the correct way to refer the cell A10 on sheet3 from sheet 1?

29.What is entered by the function =today()

30.How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?

31.The shortcut key CTRL+R is used in Excel to

32.While finding and replacing some data in Excel, which of the following statement is valid?

33. Which of the following is not true about Find and Replace in Excel

34. Which is the shortcut key to replace a data with another in sheet?

35.Which of the following is correct syntax in Excel?

36.If 4/6 entered in a cell without applying any formats, Excel will treat this as?

37.To record a sequence of keystrokes and mouse actions to play back later we use:

38.What are the tabs that appear at the bottom of each workbook called?

39.A _____________ is grid with labeled columns and rows.

40.The active cell:

41.B7:B9 indicates:

42. Cancel and Enter button appear in the:

43.Special category of Number tab in format cells dialog box can be used to apply formats like

44.Formatting a cell in Number format you can’t set

45.Which would you choose to create a bar diagram?

46.What do you call the chart that shows the proportions of how one or more data elements relate to another data element?

47.In a report, you need to show the monthly rainfall in Nepal. The best way to do this is to insert a

48.You are editing an worksheet that you had previously saved. If you want to save the edited sheet without losing the original one, which command should you use?

49. Which of the following function will use to find the highest number in a series of number?

50. Which of the following shortcuts can be used to insert a new line in the same cell?

51.What is the shortcut key to insert new comment in a cell?

52.To show/hide the grid lines in Microsoft Excel