On the 'Orders' worksheet, enter a formula in cell J2 that uses an Excel function to return the "OrderTotal" value of the individual order that has the highest "OrderTotal" value.

Explanation: You are told that you want the highest "OrderTotal" value to be. 2. Type in the formula =MAX(G1:G550).

Manage Tables and Lists

Question

On the 'Orders' worksheet, enter a formula in cell J2 that uses an Excel function to return the "OrderTotal" value of the individual order that has the highest "OrderTotal" value.

Explanation

Explanation: You are told that you want the highest "OrderTotal" value to be. 2. Type in the formula =MAX(G1:G550).

Topics

#MAX function#column formula#highest value#aggregate function

Community Discussion

No community discussion yet for this question.

Full 77-727 Practice