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. #VALUE!

B. 15

C. 20

D. 30

Answer: Option C

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

In Excel, which tab contains the 'Page Setup' group?

A. View

B. Page Layout

C. Data

D. Insert

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Page Layout tab has Page Setup.

This question belongs to: Computer Microsoft Office

Question #2

In Excel, what is the shortcut to enter an array formula?

A. Ctrl + Enter

B. Alt + Enter

C. Ctrl + Shift + Enter

D. Shift + Enter

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Array formulas in older Excel require Ctrl+Shift+Enter. In Excel 365, dynamic arrays don't require it, but traditionally it's that.

This question belongs to: Computer Microsoft Office

Question #3

Which reference citation indexing tool in MS Word displays short, descriptive identifier labels immediately below table objects or image figures?

A. Footnote

B. Bibliography list

C. Caption

D. Endnote summary

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The 'Insert Caption' tool generates numbered reference titles (such as 'Figure 1' or 'Table A') directly below or above graphic assets or tables.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs