Question

in the interactive below, fill out five products for a company and sells in column A and their respective prices in column B. Inter five as the quantity in cells C2 through C6. write an expression in column D to find the value of each cell by multiplying the corresponding B and C cells. for example the cell D2 should use the formula =B2*C2. The cell D7 should be determined by writing an expression to add cells D2 through D6.type in the items you’re purchasing in column A, type in the price of the items in column B. Enter an expression using an asterisk in columb D to multiply two cells together. For example in D2, type “=B2*C2” without the quotation marks.

Answer 1

We are tasked to complete a table by providing information on the prices of 5 items and finding their total cost.

To do this, we must first think of 5 items and find out (or at least estimate) their unit prices.

Item Price

pencil $2

notebook $4

Chapstick $3

book $7

bookmark $1

Then, in column D, we need to type the following formulas:

=B2*C2

=B3*C3

=B4*C4

=B5*C5

=B6*C6

And finally, in cell D7, type in =D2+D3+D4+D5+D6 or =sum(D2:D6).