Exit Ticket: Spreadsheet Totals, Ranges & Formulas

What formula correctly calculates Monday's total revenue if Quantity is in B2 and Price in C2?

• =SUM(B2 + C2)

• =B2 * C2

• =SUM(B2 * C2)

• =B2 + C2

Which function would return the highest total daily revenue from cells R2 to R6?

• =MAX(R2:R6)

• =HIGHEST(R2:R6)

• =SUM(R2:R6)

• =TOP(R2:R6)

What function would return the lowest quantity of Blood sold from cells H2 to H6?

• =MIN(H2:H6)

• =LOW(H2:H6)

• =SMALL(H2:H6)

• =BOTTOM(H2:H6)

A student typed =SUM(B2*C2) to calculate Bat Ear revenue. What is the correction?

• Use =B2+C2 instead

• Use =B2*C2 only

• Use =SUM(B2:C2)

• Use =TOTAL(B2*C2)

Which of the following ranges correctly totals the Feather quantities for the week?

• =SUM(N2:N6)

• =FEATHER(N2:N6)

• =TOTAL(N2 to N6)

• =ADD(N2:N6)

You need to find the total weekly revenue from Beard Hair located in column F. Which is correct?

• =SUM(F2:F6)

• =TOTAL(F2:F6)

• =F2+F6

• =SUM(F2 to F6)

Which formula correctly finds the total quantity of Eyeballs (Human) sold in column J?

• =MAX(J2:J6)

• =SUM(J2:J6)

• J2 + J6

• =AVERAGE(J2:J6)

If Quantity is in cell H4 and Unit Price is in I4, what is the correct formula for Thursday's Blood revenue?

• =H4 + I4

• =H4 * I4

• =SUM(H4:I4)

• =MULT(H4,I4)

Which of the following best represents a proper cell range for daily totals in column R?

• A. R2:R6

• B. R2-R6

• C. R2 to R6

• D. R2...R6

You want to know which ingredient had the smallest quantity sold in a week. You total each ingredient and then use:

• =MIN()

• =MAX()

• =SUM()

• =COUNT()