Spreadsheet Skills Warm-Up: Formulas, Functions & Totals

What formula would you use to calculate total profit for an ingredient?

• =Quantity + Price

• =Price - Quantity

• =Quantity * Price

• =SUM(Quantity, Price)

Which function would give you the smallest number in a group of cells?

• A. MAX

• B. MIN

• C. LOW

• D. SMALLER

Which Excel function gives you the largest number in a list?

• =BIG()

• =LARGE()

• =MAX()

• =TOP()

What is the correct formula to total values in cells B2 through B6?

• =TOTAL(B2:B6)

• =ADD(B2:B6)

• =SUM(B2:B6)

• =B2 + B6

You want to find the ingredient with the most units sold. Which formula would help?

• =MIN(range)

• =MAX(range)

• =AVERAGE(range)

• =COUNT(range)

Which formula would calculate total revenue if Quantity is in D2 and Price in E2?

• =D2 * E2

• =SUM(D2 + E2)

• =E2 / D2

• =D2 + E2

If the daily quantities sold are in cells C2 to C6, which formula gives the total?

• =TOTAL(C2,C6)

• =SUM(C2:C6)

• =C2 + C6

• =ADD(C2:C6)

What is the result of this formula: =MAX(4, 7, 2, 9, 5)?

• 2

• 4

• 7

• 9

A student wants to find the lowest sales day. Which function should they use?

• =MIN()

• =LOWEST()

• =BOTTOM()

• =LESS()

Which formula would you use to find the average sales per day if sales data is in cells A1 to A7?

• =TOTAL(A1:A7)/7

• =SUM(A1:A7)/7

• =AVERAGE(A1:A7)

• =MEAN(A1:A7)