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

C. NPER

D. FV

Answer: Option D

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

In MS Access, the 'Validation Text' property is used to:

A. Set the default value

B. Define the input mask

C. Format the field

D. Display a custom error message when the validation rule is violated

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Validation Text provides a message.

This question belongs to: Computer Microsoft Office

Question #2

In Excel, to quickly copy a formula down to adjacent cells, double-click:

A. The cell border

B. The column header

C. The formula bar

D. The fill handle of the cell

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Double-clicking the fill handle copies the formula down as far as contiguous data in the adjacent column.

This question belongs to: Computer Microsoft Office

Question #3

Which option under the MS PowerPoint Slide Show tab allows a presenter to configure presentation screens to run continuously in an automated loop at a public kiosk?

A. Set Up Slide Show

B. Presenter View properties

C. Custom Slide Show

D. Rehearse Timings tool

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The 'Set Up Slide Show' dialog box contains configuration options to set the presentation type to 'Browsed at a kiosk (full screen)', which runs the slide show in a continuous loop until Esc is pressed.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs