1. Make sure the reference to cell B13 is absolute in the formula in the IF statement formula in cell 16. Drag cell 16 formula down to 17:110. Did it print the person with the most Christmas card...

1. Make sure the reference to cell B13 is absolute in the formula in the IF statement formula in cell 16. Drag cell 16 formula down to 17:110. Did it print the person with the most Christmas card sales?

2. Instead of the profit per box values in row 4, assume that Ann’s profit is calculated as follows: 0.12(Christmas Cards Sales)2 + 0.02(Birthday Card Sales)3 + 3.50V(AU Occasion Card Sales) + 0.05(Thank You Card Sales) * (Mixed Card Sales). In cell C15, determine Ann’s total profit.