Which of the following formulas is valid in MS Excel to find the highest value from cells A1 through A10? MCQ with Answer and Explanation

Question

Share Report Error

Which of the following formulas is valid in MS Excel to find the highest value from cells A1 through A10?

A. =MAX(A1:A10)

B. =HIGH(A1:A10)

C. =MAXIMUM(A1:A10)

D. =TOP(A1:A10)

Answer: Option A

Solution (By JKSSB Mock Tests)

The native function name to extract the maximum number from a given range of cells in Excel is MAX.

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

What is the function of the 'F2' key in MS Excel?

A. Opens the Print dialog

B. Saves the workbook

C. Selects the entire column

D. Edits the active cell, placing cursor at the end

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
F2 allows editing directly in a cell. Ctrl+Space selects column.

This question belongs to: Computer Microsoft Office

Question #2

In Access, what is the purpose of the 'AutoNumber' data type?

A. To store random numbers

B. To copy numbers from another table

C. To auto-increment a field based on a formula

D. To automatically generate a unique number for each record

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
AutoNumber is a data type that automatically generates a unique sequential number when a record is added, often used as a primary key.

This question belongs to: Computer Microsoft Office

Question #3

The shortcut to open the 'Page Setup' dialog in MS Excel is:

A. Ctrl + F2

B. F12

C. Ctrl + P

D. Alt + P, S, P (or Page Layout tab)

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
No direct single shortcut; you can use Alt+P, S, P. Or from Page Layout tab. I'll ask: Which tab contains Page Setup group? Answer: Page Layout. So I'll adjust.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs