What type of reference are B4 and C4 in the following formula? TAX RATE:
SALES TAX
ITEM
10.5" Extra Thick Dinner Plates - 20 count
8" Deep Dessert Plates - 15 count
16 oz. Beverage Cups - 30 count
12 oz. Styrofoam Coffee Cups - 20 count
50 count Plastic Spoons - White
50 count Plastic Forks - White
50 count Plastic Knives - White
100 count Dinner Napkins - Blue
UNIT PRICE QUANTITY
$3.79+(84*C4)*$E$2|
$3.99
20
$1.29
10
$1.59
15
$2.59
6
$2.69
6
$2.19
6
$1.39
3
7.5%
LINE TOTAL
$56.85
$79.80
$12.90
$23.85
$15.54
$16.14
$13.14
$4.17
O Relative Reference
O Absolute Reference
O Cross-Worksheet Reference