MS EXCEL Quizzes | Trivia Quiz for Practice

76. You want to record experiment information and create a chart that shows the rate of crystal growth over a period of time. The best application to use would be:

1. word processing
2. spreadsheet
3. database
4. graphics

77. Microsoft Excel is a powerful

1. Word processing package
2. Spreadsheet package
3. Communication S/W Package
4. DBMS package

78. MS Excel is a

1. Word Processing Program
2. Spreadsheet Program
3. Presentation Program
4. None of the above

79. An Excel Workbook is a collection of

1. Workbooks
2. Worksheets
3. Charts
4. Both (A) and (B)

80. We can save and protect the workbook by

1. Write Reservation Password
2. Read-only Recommended
3. Protection Password
4. Any of the above

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

1. XY Chart
2. Line Chart
3. Pie Chart
4. Column Chart

82. How many sheets are there, by default, when we create a new Excel file ?

1. 1
2. 3
3. 5
4. 10

83. How many worksheets can a workbook have?

1. 3
2. 8
3. 255
4. none of above

84. What value will display if the formula = “$55.00″+5 is entered into a cell?

1. 60
2. 60
3. “$55.00″+5
4. $60.00

85. What will be the output if you format the cell containing 5436.8 as ‘#,##0.00’?

1. 5430.00
2. 5436.80
3. 5436.80
4. 6.8

86. The cell reference for cell range of G2 to M12 is

1. G2.M12
2. G2;M12
3. G2:M12
4. G2-M12

87. Formulas in Excel start with

1. #
2. %
3. =
4. +

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

1. &
2. %
3. $
4. All of the above

89. What is the symbol for multiplying?

1. >
2. /
3. !
4. *

90. How to specify cell range from A9 to A99 in Excel?

1. (A9, A99)
2. (A9 to A99)
3. (A9 : A99)
4. (A9 – A99)