MS Excel MCQs

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

You can check the conditions against _____when applying conditional formatting

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

Which shortcut key is for auto sum ?

1. Alt + =
2. Ctrl + Shift
3. Alt + F1
4. Ctrl + =

which option is not avail.able in Paste special dialogue box ?

1. Subtract
2. Divide
3. SQRT
4. none

Which of the following EXCEL feature allows users to evaluate values and return a result?

1. Formula
2. Formating
3. Filters
4. None of these

Which of following series type is not valid for fill series dialogue box ?

1. Time
2. Autofill
3. Growth
4. All

Which of following is not the correct method of editing the cell content ?

1. Press the Alt key
2. Click the formula bar
3. Press the F2 key
4. none

Which of following is not a valid zoom percentage in Excel?

1. 10
2. 100
3. 300
4. 500