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 .