To find the largest quantity of items ordered from Rex Technologies, what Excel formula should be used in A12

For finding the largest quantity of items ordered from Rex Technologies the excel formula used is max(). Inside max you must specify the range of rex technologies quantity column cells just like if quantity is in D column and rex technologies items start from cell 4 to cell 7 then the formula will be max(D4:D7)

Explanation:

In max formula first argument is starting cell of range and last is ending cell of range. In this scenario starting cell is D4 and end cell D7

answer; its the top layer;