MS Excel MCQs

How to fit long text in a single cell with a multiple lines :

1. Start typing in the cell and press the enter key to start another line
2. Use the wrap text option in the format -> alignment menu
3. Use the shrink to fit option in the format ->cells->alignment menu
4. None of these

Which function can be used to calculate the monthly mortgage payment :

1. PMT
2. PV
3. MORT
4. None of these

Which allow to access from one cell to another

1. Address
2. Formulas
3. Values
4. None of these

which key is used for help in MS excel------?

1. F1
2. F2
3. F3
4. NONE OF THESE

In Excel which shortcut key is used to go to the formula tab?

1. Alt+M
2. Ctrl+M
3. Ctrl+C
4. Ctrl+B

in excel which key is used for format numbers in comma format?

1. ctrl+shift+1
2. ctrl+shift+4
3. crtl+1
4. shift+1

Shortcut key to insert a new worksheet in Excel is _____.

1. Shift + F8
2. Shift + F9
3. Shift + F10
4. Shift + F11

The delete key of keyboard is assigned to which command in excel ?

1. Edit > Clear > All
2. Edit > Clear > Contents
3. Edit > Delete
4. none

What is the keyboard shortcut to insert a SUM formula in MS Excel?

1. CRTL+ =
2. ALT + =
3. ALT + S
4. CTRL + ALT+ =

Which key is used to enter the current date in Excel?

1. Ctrl+:
2. Ctrl+Shift:
3. Ctrl+;
4. None of these