MS EXCEL MCQs Quiz Multiple Choice Questions & Answers Page 2

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

1. ROUND()
2. MOD ( )
3. FACT ( )
4. None of the above

52. Which of the following function will return a value of 8?

1. ROUNDUP(8.4999, 0)
2. ROUNDDOWN(8.4999, 0)
3. ROUND(8.4999, 0)
4. Only B and C

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

1. Save
2. Save As
3. Both (A) and (B)
4. None of the above

54. What is the correct way to refer the cell A10 on sheet3 from sheet1?

1. sheet3!A10
2. sheet1!A10
3. Sheet3.A10
4. A10

55. The Software which contains rows and columns is called

1. Spreadsheet
2. Word processing
3. Database
4. None of the above

56. It is a collection of data that is stored electronically as a series of records in a table.

1. spreadsheet
2. presentation
3. database
4. MS Word

57. Which area in an Excel window allows entering values and formulas ?

1. Standard Tool Bar
2. Title Bar
3. Formula Bar
4. None of the above

58. Excel displays the current cell address in the

1. Status Bar
2. Name Box
3. Formula bar
4. None of the above

59. Which one is not a Function in MS Excel ?

1. SUM
2. AVG
3. MAX
4. MIN

60. Hyperlinks can be

1. Text
2. Drawing
3. Picture
4. All of the above

61. In Excel ……………………………….may not contain in Formula

1. Text Constant
2. Number Constant
3. Circular Reference
4. All of the above

62. Clear the contents by pressing “DELETE” key from a keyboard will clear

1. Text Only
2. Format Only
3. Contents Only
4. Both Contents and Format

63. You can group noncontiguous worksheets with

1. The alt+enter key
2. The ctrl key and mouse
3. The shift key and the mouse
4. The group button on the standard toolbar

64. A smart tag will be removed from a cell when

1. the cell is moved
2. the cell is hidden
3. the data in the cell is changed or deleted
4. None of the above

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

1. The Settings tab under the menu Format -> Cells
2. The Settings tab under the menu Data -> Validation
3. The Settings tab under the menu Data -> Filter -> Advanced Filter
4. the Settings tab under the menu Format -> Conditional Formatting

66. The Cancel and Enter buttons appear in the:

1. Title bar
2. Formula bar
3. Menu bar
4. Sheet tabs

67. In Excel, the Fill Color button on the Formatting toolbar is used for what?

1. To insert a background.
2. To add borders.
3. To select a distribution of figures.
4. To add shading or color to a cell range.

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

1. Today’s date as Text format
2. The time value according to system clock
3. The date value for the day according to system clock
4. None of the above

69. A…………………….is a grid with labeled columns and rows.

1. Toolbar
2. Formula bar
3. Clipboard
4. Worksheet

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

1. Use =if() function to format the required numbers red
2. Apply Conditional Formatting command on Home Tab
3. Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
4. None of the above

71. The default header for a worksheet is

1. Username
2. Date and Time
3. Sheet tab Name
4. None

72. To create a formula, you can use:

1. Value and cell references
2. Values but not cell references
3. Cell references but not values
4. None of the above

73. In order to perform a calculation in a spreadsheet, you need to use a:

1. variable
2. formula
3. table
4. None of the above

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

1. Visual Basic
2. C
3. Visual C++
4. Java

75. MS-EXCEL is based on

1. WINDOWS
2. DOS
3. UNIX
4. OS/2

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)

91. What is the symbol for dividing?

1. /
2. %
3. &
4. #

92. What should be add before a fraction to avoid entering it as a date ?

1. //
2. Zero
3. Space
4. None of the above

93. Which of the following is correct ?

1. =POWER(2*3)
2. =POWER(2^3)
3. 8
4. None of the above

94. Give me an example of a cell address.

1. 11 25
2. 911
3. 41A
4. A21

95. Selecting the Column G & H then choose Insert->Columns. What will happen?

1. 2 Columns will be inserted after Column F
2. 2 Columns will be inserted after Column G
3. 2 Columns will be inserted after Column H
4. 2 Columns will be inserted after Column I

96. Where a row and a column meet, what do you call that?

1. A cell
2. A block
3. A box
4. None of the above

97. In Excel, a Data Series is defined as what ?

1. A collection of related data
2. A type of chart
3. A cell reference
4. None of the above

98. In Excel, Columns are labelled as

1. A, B, C, etc
2. 1,2,3 etc
3. A1, A2, etc
4. $A$1, $A$2, etc.

99. In Excel, Rows are labelled as

1. A, B, C, etc
2. 1,2,3 etc
3. A1, A2, etc
4. $A$1, $A$2, etc.

100. The cell reference for cell range of A2 to M12 is

1. A2!M12
2. A2.M12
3. A2;M12
4. A2:M12