Question

derrick has created a spreadsheet that displays the results of a science experiment for mrs. blues class. he needs to write a formula that displays the highest cell value within a data range. which formula would produce the correct result? a =highest(j5:j9) b =most(j5:j9) c =max(j5:j9) d =min(j5:j9)

Explanation:

In spreadsheet software, the MAX function is specifically designed to return the highest value in a specified data range. The functions HIGHEST and MOST are not standard spreadsheet functions for this purpose, and MIN returns the lowest value, so they are incorrect. Thus, =MAX(J5:J9) is the correct formula.

Answer:

C. =MAX(J5:J9)