Question Detail

Which function calculates your monthly mortage payment ?

PV
NPER
PMT
All of above

Answer: Option C

Similar Questions :

1. VLOOKUP function used to ?

Finds related records
Looks up text that contain "v"
Check if two cells are identical
None of above

Answer: Option A

2. Which function in excel counts the numbers of characters in a cell ?

LENGHT
LGT
LT
LEN

Answer: Option D

3. Which of these will not select all the cells in a document ?

Using the Edit – Select All menu
Pressing Ctrl + A on the keyboard
Clicking three times with the right mouse button in the spreadsheet

Answer: Option C

4. When you press Ctrl + X after selecting some cells in Excel, what will happen then

The cell content of selected cells disappear from cell and stored in clipboard
The selected cells are deleted and cells are shifted up
The selected cells are deleted and the cells are shifted left
The cells selected are marked for cutting

Answer: Option D

5. On Excel screen, Tab scroll buttons are

towards the top left corner
towards the top right corner
towards the bottom right corner
towards the bottom left corner

Answer: Option D

Read more from - MS Excel Questions Answers