Google Sheets Review: Math Functions and Arithmetic Operators

If the quantity is in cell B1 (5) and the price per item is in cell C1 (20), which formula calculates the total cost?

• =SUM(B1, C1)

• =PRODUCT(B1, C1)

• =B1 + C1

• =B1 - C1

Which formula calculates the difference between total sales in cell D1 and total cost in cell D2?

• =D1 - D2

• =SUM(D1, D2)

• =MINUS(D1, D2)

• Both a and c

If the sales for three products are in cells F1, F2, and F3, which formula calculates the total income?

• =PRODUCT(F1:F3)

• =ADD(F1:F3)

• =SUM(F1:F3)

• =F1 + F2 + F3

If you want to calculate the average monthly expense using the total expense in cell G1 and the number of months in cell G2, which formula would you use?

• =SUM(G1, G2)

• =PRODUCT(G1, G2)

• =G1 / G2

• =MINUS(G1, G2)

In a table, cells H1 to H5 contain the sales made each day. Which formula calculates the total sales for the week?

• =SUM(H1:H5)

• =PRODUCT(H1:H5)

• =H1 + H5

• =AVERAGE(H1:H5)

If the profit per item is in cell J1 (15) and the number of items sold is in cell J2 (40), which formula calculates the total profit?

• =SUM(J1, J2)

• =J1 * J2

• =PRODUCT(J1, J2)

• Both b and c

If a table shows the number of hours worked each day in cells L1 to L7, which formula calculates the total hours worked for the week?

• =PRODUCT(L1:L7)

• =SUM(L1:L7)

• =L1 + L7

• =MINUS(L1, L7)

You want to calculate the total cost of items in a shopping list. The quantity of each item is in column M and the price per item is in column N. What formula should you use in cell O1 to calculate the total cost for the first item?

• =M1 + N1

• =PRODUCT(M1, N1)

• =SUM(M1, N1)

• =M1 / N1

In a sales report, the revenue from January to June is in cells P1 to P6. If you want to calculate the total revenue and subtract the expenses in cell P7, which formula should you use?

Revenue is the money that a company receives, especially from selling goods or services.

• =SUM(P1:P6) - P7

• =PRODUCT(P1:P6, P7)

• =SUM(P1:P7)

• =P1 + P6 - P7