MS Excel MCQs

Worksheet in excel by default ___

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

What do you mean by a workspace ?

1. Group of Workbooks
2. Group of Rows
3. Group of Worksheets
4. None

To select an entire column in MS Excel, press?

1. Ctrl +r
2. Ctrl +s
3. Ctrl +c
4. none

Microsoft excel is a powerful______

1. Spreadsheet package
2. Word processing package
3. DBMS package
4. None

A numeric value can be treated as label value if ___ precedes it.

1. =
2. ( ‘ )
3. #
4. None

___the cell pointer indicates that you can fill series

1. Doctor’s symbol (Big Plus)
2. Small thin plus icon
3. Mouse Pointer with anchor at the tip
4. None

___ is the short key to select the entire column in Excel.

1. Alt + space bar
2. Shift + space bar
3. Control + space bar
4. None of the above

______ the cell pointer indicate that you can move the content to other cell .

1. Doctor’s symbol (Big Plus)
2. Mouse Pointer with anchor at the tip
3. Small thin plus icon
4. All

You can check the conditions against _____when applying conditional formatting

1. Cell value
2. Formula
3. Both of above
4. none

You can set border in Excel from ___

1. From Line Style tool in Drawing toolbar
2. You can not set page border in Excel
3. From Border tool in Formatting toolbar
4. none

Worksheet in excel by default ___

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