The formulas used in a spreadsheet can be displayed as shown in the diagram below. Note that * is the notation for multiplication and that all entries have been rounded to the closest cent. This example shows Maryland state sales tax, which was 6% in 2011 (6% as a decimal is 0.06).

(a) The values in columns C and D will be displayed to two decimal places as they represent an amount of money. What values will be displayed in cell C3 and cell D3?

(a) The formula in C3 is: .

So, (rounded to 2 decimal places).

The value in D3 is obtained by adding together the values in B3 and C3.

So, = 17.48.

(b) What do you think is being calculated in the cells in column D? Can you suggest a suitable heading for this column, to be entered into D1?