Asked by zenish neupane on Sep 25, 2024

Now Anna wants to know the longest total time she has run.By looking at the total time values,she finds the longest total time to be 54 minutes.Instead of manually entering that value in a cell below the total time data,Anna decides to use the MAX function to determine the longest total time.Why did Anna prefer to use the MAX function?

A) She believes that 54 minutes is her best running time.
B) The MAX function recalculates the highest value each time a new value is entered into the worksheet.
C) She believes that 54 minutes is not her best running time.
D) The MAX function provides a constant value that will not change for this cell when a new value is entered into the worksheet.

MAX Function

A formula used in spreadsheet programs to find the largest number in a set of values.

  • Learn to employ key shortcuts and functionalities within Excel.