Skip to content

Menu

Game modes

Account

← Office Applications
GK QUESTION#1365

Which function is used to calculate the maximum value in a selected column in MS Excel?

  1. AAuto max
  2. BMaxCorrect answer
  3. CAuto high
  4. DHigh
Show AnswerHide Answer

Answer

B. Max

Show ExplanationHide Explanation

Explanation

The MAX function returns the largest numeric value from its arguments. For example, =MAX(A1:A10) finds the highest number in that column range. When a range is supplied, empty cells and text in the range are ignored. MAX is the function name; the other listed names do not identify this function.

Sign in to report a question issue

Explore this topic

In Microsoft Word, the Mail Merge Wizard is located under the _________ tab.In MS-Excel 365, you can use _________ when you want to change a cell reference within a formula…Consider the following statements about MS PowerPoint: 1. The slide number can be added to each slide of…