9 In cell E4, enter a formula that repeats the value in cell 5.000
B2. Do not type the value; use a formula.
10 In cell E5, enter a formula to calculate the product of the
5.000
Food & Beverages( in column E) and the Sales Tax Rate.
11 In cell E6, enter a formula to calculate the Subtotal of
5.000 the Food & Beverages( in column E) and the Sales Tax Amount.
12 In cell E7, enter a formula to calculate the Tip Amount 5.000 based on the Subtotal and the Tip Rate.
13 In cell E8, enter a formula to calculate the Total Bill 5.000 based on the Subtotal and the Tip Amount.