In Excel, which error value indicates that a formula contains invalid numeric values? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which error value indicates that a formula contains invalid numeric values?

A. #VALUE!

B. #NAME?

C. #DIV/0!

D. #REF!

Answer: Option A

Solution (By JKSSB Mock Tests)

#VALUE! appears when wrong data type is used. #REF! invalid reference, #DIV/0! division by zero, #NAME? unrecognized text.

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

Share Report

Which key combination is used to switch between open applications in Windows (and also in Office)?

A. Windows + Tab

B. Alt + Tab

C. Ctrl + Tab

D. Shift + Tab

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Alt+Tab switches between open windows. Ctrl+Tab switches between document windows within an application.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In Excel, which function is used to calculate the internal rate of return for a series of cash flows?

A. PV

B. IRR

C. RATE

D. NPV

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
IRR calculates the internal rate of return. NPV calculates net present value, PV present value, RATE interest rate.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

Which of the following is NOT a type of animation effect in PowerPoint?

A. Entrance

B. Exit

C. Emphasis

D. Transition

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Transition is a slide change effect, not an object animation. The four animation types: Entrance, Emphasis, Exit, Motion Paths.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs