Computer · MS Excel

In Microsoft Excel, which of the following functions will return the largest numeric value from the cell range A1 to A20?

Verified Solution4 OptionsUpdated: October 2026👁️1 View

1=MAX(A1:A20)✓
2=UPPER(A1:A20)
3=TOP(A1:A20)
4=HIGH(A1:A20)

Correct answer

=MAX(A1:A20)

Download Single Question PDF

Save this question and verified answer as a clean study sheet with live clickable link.

👥

Share with Friends & Study Groups

Challenge your peer aspirants on WhatsApp or Telegram to solve this question!

Online Test Series

Preparing for Computer?

Practice full-length Computer mock tests with real exam timers, instant score analysis, and all-India ranking.

Attempt MS Excel MCQs →All Mock Tests

Chapter Practice

Want more practice questions on MS Excel?

Solve complete topic-wise tests with detailed solutions on GkGet.

Practice MS Excel MCQs →

Recommended practice questions in Computer · MS Excel

Browse More Computer →

What is the primary function of the =INDIRECT() formula in Microsoft Excel?

Solve Question→

Which chart type in MS Excel is primarily used to analyze and display the relationship or correlation between two numerical variables (X and Y)?

Solve Question→

Which option best describes the functionality of the 'Delete Cells' dialog box (accessed via Home tab > Cells group > Delete > Delete Cells) in Microsoft Excel?

In Microsoft Excel, which of the following functions will return the largest numeric value from the cell range A1 to A20?

Download Single Question PDF

Share with Friends & Study Groups

Preparing for Computer?

Practice by Subject

Practice by Exam

Topic-Wise Solved Questions

In Microsoft Excel, which of the following functions will return the largest numeric value from the cell range A1 to A20?

Download Single Question PDF

Share with Friends & Study Groups

Preparing for Computer?

Related Practice Questions

Practice by Subject

Practice by Exam

Topic-Wise Solved Questions