MS Excel MCQ Quiz for Government Exams - Part 1

1.MS-Excel provides the default value for steps in Fill Series dialog box?

2.In the formula, which symbol specifies the fixed columns or rows?

3.To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the

4.You can enter which type of data into worksheet cells?

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

6.Which button do you click to add up a series of numbers?

7.Which of the following Excel screen components can NOT be turned on or off?

8. Which of the following option is not available in Paste Special dialog box?

9.Which command will you choose to convert a column of data into row?

10.Long text can be broken down into many lines within a cell. You can do this through

11.Which of the following series type is not valid for Fill Series dialog box?

12.Which of the following you can use in Paste Special command

13.To return the remainder after a number is divided by a divisor in EXCEL we use the function

14.How do you rearrange the data in ascending or descending order

15.How many worksheets can a workbook have ?

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

17.Which setting you must modify to print a worksheet using letterhead?

18.We can save and protect the workbook by

19.In order to perform a calculation in a spreadsheet, ou need to use a :

20.You accidentally erased a record in the sheet. What command can be used to restore it automatically?

21.NOT, AND, OR and XOR are

22.MS-Excel can be used to automate

23.What is the shortcut key to hide entire column?

24.What is the shortcut key to insert new sheet in current workbook?

25.Multiple Calculations can be made in a single formula using

26.How do you wrap the text in a cell?

27.When working in the page break preview, you can

28. Excel uniquely identifies cells within a worksheet with a cell name

29.When you work with large worksheets , you may need to

30.Data can be arranged in a worksheet in an easy to understand manner using

31.Rounding Errors can occur

32.Which of the following is correct?

33.Excel worksheet cells work very similarly to what comman element of the window graphical user interface.

34.When you use the fill effects in the format data series dialog box, you can not

35.Except for the ______ function, or formula with a logical function shows the word "TRUE" or " FALSE" as a result

36.Chart tips can

37. To view a cell comment

38.Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?

39.Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?

40.When you print preview a worksheet

41.When you see a cell with a red triangle in the top right corner, what does this signify?

42.Which of the formulas will Excel Not be able to calculate

43. You can use drag and drop method to

44. It is acceptable to let long text flow into adjacent cells in a worksheet when

45.The Paste Special command lets you copy and paste

46.To insert three columns between D and E you would

47.A circular reference is

48.When you copy a formula

49.You can drag and drop to embed excel worksheet data in a word document

50. To drag a selected range of data to another worksheet in the same workbook, use the

51.You can select a single range of cells by

52.When you group worksheets

53.When all the numbers between 0 and 100 in a range should be displayed in Red color , apply

54.You can check the conditions against ______when applying conditional formatting

55.The number in our worksheet look like this: 1000. You want them to look like this: $1,000. How can you accomplish this?

56. Which of the following is an absolute cell reference?

57.Which of the following describes how to select all the cells in a single column?

58.Hyperlinks cannot be

59.Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?

60.Tab scroll buttons are placed on Excel screen

61.Documentation should include

62.The default header for a worksheet is

63.Which function will you use to enter current time in a worksheet cell?

64. You can group noncontiguous worksheets with

65.Weight refers to

66. You need the insert function dialog box.

67.What’s a quick way to extend these numbers to a longer sequence, for instance 1 through 20?

68.A function inside another function is called a ….. Function.

69.Which function calculates your monthly mortage payment?

70.What is an expression that tells how the numbers in determined set of cells are to be calculated?

71.If you are working in English(US), Chinese or Japanese, Excel 2016 can speak data as you enter it, to help you verify accuracy. How do you activate this feature?

72.To copy cell contents using drag and drop, press the

73.If you press …, the cell accepts your typing as its contents.

74.What is the keyboard shortcut (button or buttons to be pressed) for creating a chart from the selected cells?

75.You can use the formula palette to

76.“Qtr 1, Qtr 2, Qtr 3” is an example of a

77.You can edit existing Excel data by pressing the

78.The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is ….

79.A user wishes to remove a spreadsheet from a workbook.Which is the correct sequence of events that will do this?

80.Which feature describes a background that appears as a grainy, non smooth surface