MS Excel MCQs

Which of the following is not a valid data type in Excel?

1. Date/Time
2. Label
3. Character
4. Number

Which symbol is used to execute formulas in MS Excel

1. :
2. =
3. #
4. ~

An excel workbook is a collection of ___?

1. Worksheets and Charts
2. Charts
3. Worksheets
4. Workbooks

Microprocessors was introduced in which generation of computer___?

1. Second Generation
2. Fourth Generation
3. Third Generation
4. Both (A) and (B)

In MS Excel, to insert a sum formula in a cell

1. =sum(A1:A2)
2. =Add(a1:a2)
3. =sum(1A:2A)
4. =Add(1A:2A)

What is the default row height of MS Excel?

1. 20
2. 13
3. 14
4. 15

Number of default worksheets in MS Excel?

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

MS Excel Formula starts with _______?

1. .
2. _
3. =
4. none

Which bar is used for the current cell and its constraint?

1. Name box
2. Row headings
3. Formula bar
4. None of these

What is the use of a horizontal Scroll Bar in MS Excel?

1. to view the data from left to the right
2. to view the data in Excel from up and down
3. to view the data from right to the left
4. None of these