Question

Question 9 of 20

Jerry keeps a spreadsheet of all the tools he owns He wants to figure out
how many nails and screws he has so he knows how many more he needs to
buy to have 500 total, If the number of nails and screws is in cells B2 and B3,
what formula would he use to solve this problem?

Answer 1

C. The formula is =500-SUM(B2:B3).

Multiple-choices

A. The formula is EADD(B2:B3).

B. The formula is =SUM(B2:B3)-500

C. The formula is =500-SUM(B2:B3).

D. The formula is =500-ADD(B2 B3).​

Step-by-step explanation:

An excel formula must start with =

The formula needs to express the answer of subtracting the total of screws and nails from 500. If the required total is 500, Jerry needs to order 500 minus the total number screws and nails.

i.e., 500 -(no. of nails + screws)

Using excel commands

=500 - sum(B3,B5)