MS EXCEL Objective Questions | MCQ Quiz for Practice

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