What will be the result of the MS Excel formula =AVERAGE(10, 20, 30) if entered into a modern worksheet? MCQ with Answer and Explanation

Question

Share Report Error

What will be the result of the MS Excel formula =AVERAGE(10, 20, 30) if entered into a modern worksheet?

A. 20

B. 15

C. #VALUE!

D. 30

Answer: Option A

Solution (By JKSSB Mock Tests)

When passed directly as individual arguments inside a formula, numeric strings are parsed into numbers. Thus, (10 + 20 + 30) / 3 = 20.

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

In MS Word, what does pressing the 'Ctrl + W' shortcut key combination do?

A. Applies a bold style format to the active word block

B. Saves the current document and opens a blank document

C. Closes the currently active document window

D. Launches the web browser lookup helper

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl + W closes the active document or file window in most MS Office suites without exiting the core parent software program altogether.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In MS Word, the automated reference assistant feature that scans across an entire document to build a hyperlinked directory map of heading milestones is called:

A. Bookmark registry

B. Navigation Pane

C. Smart Lookup framework

D. Cross-reference guide

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The Navigation Pane indexes document headings (formatted with Heading styles), creating an interactive, click-to-jump directory outline map on the left side of the screen.

This question belongs to: Computer Microsoft Office