This spreadsheet shows an invoice with a formula that is copied from D15 to D16, D17, and D18. The hourly rate is always $35.

What formula most likely exists in D18?

A.B18*D18
B.B18*B13
C.B18*$B$13
D.B13*$D$13

This spreadsheet shows an invoice with a formula that is copied from D15 to D16 D17 and D18 The hourly rate is always 35 What formula most likely exists in D18 class=

Respuesta :

The formula likely to exist in D18 is C , that is B18*$B$13. This is called mixed cell referencing, whereby absolute and relative cell referencing have to get combined. For example, the values in the first part of the formula keep changing, that is called relative referencing. But, when dollar signs surround a cell in a formula it becomes absolute referencing, its value remains constant matter where it gets placed on the sheet.

Answer:

c

Explanation:

ACCESS MORE