MS Excel MCQs

Ctrl +D in MS Excel

1. Fill down in the selection
2. Open the font dialog box
3. none
4. All

Ctrl+R is used in excel to

1. Fill the selection with active cells to the right
2. Right align the content of cell
3. Remove the cell contents of selected cells
4. none

Which one is not a Function in MS Excel?

1. SUMB
2. AVG
3. MAXD
4. MIN

How many characters can be typed in a single cell in Excel ?

1. 256
2. 1024
3. 32767
4. 65535

In Excel which key is used for format number in currency format?

1. Ctrl+Shift+1
2. Ctrl+Shift+4
3. Ctrl+1
4. Shift+1

Which key is used to edit the selected cell in excel?

1. F2
2. F10
3. F4
4. F8

The formula of MS Excel begins with?

1. +
2. -
3. =
4. [

Formula in Excell starts with

1. +
2. -
3. =
4. [

Which of the following function rotate the contents of columns to rows and rows to columns in Microsoft Excel?

1. switching
2. transpose
3. matrix
4. none

___ view displays all the slides in your presentation in horizontally sequenced, thumbnails

1. slide show view
2. slide sorter view
3. outline view
4. none