Which of the following mathematical formulas is evaluated correctly to find the geometric mean of cells A1 through A3 in MS Excel? MCQ with Answer and Explanation

Question

Which of the following mathematical formulas is evaluated correctly to find the geometric mean of cells A1 through A3 in MS Excel?

A. =GEOMEAN(A1:A3)

B. =MEAN.GEOMETRIC(A1:A3)

C. =PRODUCT(A1:A3)^(1/3)

D. =GMEAN(A1:A3)

Answer: Option A

Solution (By JKSSB Mock Tests)

The native, built-in function to compute the geometric mean of an array or numerical dataset range in Excel is GEOMEAN.

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, the 'Format Painter' shortcut to paste formatting is:

A. F4

B. Ctrl + V

C. Ctrl + Shift + V

D. Ctrl + Alt + V

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+Shift+V pastes formatting only.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In MS Word, what is the purpose of the 'Section Break'?

A. To create columns

B. To insert a page break

C. To divide a document into sections that can have different formatting

D. To start a new chapter

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Section breaks allow you to apply different page formatting (like margins, headers/footers, columns) to different parts of the document.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

Which key should be pressed to move to the next slide during a PowerPoint presentation?

A. Enter

B. Tab

C. Spacebar

D. Any of the above

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
All these keys advance to the next slide: Spacebar, Enter, Page Down, Right Arrow, Down Arrow, or N.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs