MS Excel MCQs

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