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?

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).

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)

you will have $2593.74 in 10 years if you set aside $1,000 at 10%

you will have $9321.91 in 20 years if you set aside $2000 at 8%

you will have $1469.32 in 5 years if you set aside $1000 at 8%

you will have $1296.87 in 10 years if you set aside $500 at 10%

you will have $239.66 in 15 years if you set aside $100 at 6%

you will have $4660.96 in 20 years if you set aside $1000 at 8%

answer; manager working long hours; plz check i believe this is correct good luck;