Navigate

Question Detail

Which function calculates your monthly mortage payment ?

  • PV
  • NPER
  • PMT
  • All of above

Answer: Option C

Similar Questions :

1. Which function will you use to enter current time in a woksheet cell ?

  • =time()
  • =nowtime()
  • =now()
  • =currentTime()

Answer: Option C

2. Macros can be executed from the which of the following menu ?

  • Format
  • Home
  • Insert
  • Tools

Answer: Option D

3. On an excel sheet the active cell in indicated by ?

  • A dotted border
  • A dark wide border
  • A blinking border
  • By italic text

Answer: Option B

4. 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

5. How is data organized in a spreadsheet ?

  • Rows and columns
  • Layers and planes
  • Lines and spaces
  • Height and width

Answer: Option A

Read more from - MS Excel Questions Answers