Example Explanation Reference Relative reference =B2 The column and the row both change when copied Absolute reference =$B$2 The column and the row both do not change when copied Absolute column reference =$B2 The column does not change when copied; the row does change Absolute row =B$2 The row does not change when copied; the column does change reference Exercise 6. Genevieve, Harold, Isla, and Janice are at the farmers market buying different quantities of citrus fruits. Oranges cost $0.79 each, lemons cost $0.39 each, and grapefruit cost $1.29 each. a. Calculate the amount each person spent on each fruit. b. Calculate each person's total bill. DATA Quantities Genevieve 9 Janice Harold 3 Isla 7 3 Fruit Oranges Lemons Grapefruit Price $0.79 $0.39 $1.29 2 6 8 5 10 0 12 2