Critical Thinking Questions Case 2 Anna Is a Competitive Runner

Critical Thinking Questions Case 2 Anna is a competitive runner. She wants to improve her performance and decides to keep track of data for six months to determine if the time of day or year affects performance numbers. On a single worksheet, she labels the columns B through E as follows: (B) Start Time, (C) End Time, (D) Total Time, (E) Distance. The rows are labeled: (2) Date, (3) Maximum, (4) Average, (5) Minimum. After three months, Anna wants to know the longest total time she has run, as listed in the Total Time column. By looking at the values in the column, she finds the longest total time to be 54 minutes. Instead of manually entering that value in cell D3 (Maximum Total Time) , Anna decides to use the MAX function to determine the value rather than manually entering the 54 minutes. 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.