In Excel, which function is used to calculate the future value of an investment? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which function is used to calculate the future value of an investment?

A. PV

B. FV

C. NPER

D. PMT

Answer: Option B

Solution (By JKSSB Mock Tests)

FV calculates future value based on periodic payments and interest.

This question belongs to: Computer Microsoft Office

Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1

What is the purpose of the HLOOKUP function in Excel?

A. Searches horizontally for the maximum value

B. Performs a case-sensitive search

C. Looks up a value in the leftmost column and returns from a column to the right

D. Looks up a value in the top row of a table and returns a value from a specified row below it

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
HLOOKUP searches for a value in the first row and returns from a specified row. VLOOKUP searches in first column.

This question belongs to: Computer Microsoft Office

Question #2

In MS Access, what is a 'Primary Key'?

A. A field used for sorting

B. A field that allows duplicate values

C. A field that uniquely identifies each record in a table

D. A field that stores external data

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
A Primary Key is a field (or combination of fields) that uniquely identifies each record in a table. It cannot contain null or duplicate values.

This question belongs to: Computer Microsoft Office

Question #3

Which of the following functions in MS Excel is used to find the relative position of a specified item within a given range of cells?

A. MATCH

B. OFFSET

C. VLOOKUP

D. INDEX

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The MATCH function searches for a specified value in a cell range and returns the relative row or column position of that item.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs