Excel Practice Sheets
BeginnerStatistical Functions4 min10 points

Find the largest and smallest order

The situation

Before a quarterly review, Harbor Supply's finance team wants the biggest and smallest orders of the month to sanity-check the range.

A1
fx
Find the largest and smallest order — question sheet. Use the arrow keys to move between cells, Enter or F2 to edit, Escape to cancel, Control D to fill down from the cell above, and Control C and Control V to copy and paste.
Row numberABCDE
1OrderCustomerValue
2ORD-1041Ridgeway Hardware$1,250
3ORD-1042Coastal Plumbing$3,400
4ORD-1043Fairmont Builders$890
5ORD-1044Pinecrest Electric$2,100
6ORD-1045Ridgeway Hardware$1,675
7ORD-1046Delta Roofing$4,250
8ORD-1047Coastal Plumbing$2,980
9ORD-1048Summit Interiors$1,455
10Largest
11Smallest
12

Functions in this exercise

  • MAX — Returns the largest number in a range.
  • MIN — Returns the smallest number in a range.

Who this is for

Recommended next

Related exercises