1. In cell G6 write a formula giving Ann's total sales using the SUM function.
2. Drag the formula in G6 to cells G7:G10. Did this give the right values for Bob's, Charles's, David's, and Ellen's total sales?
3. Without using the SUM function, enter a formula in cell B11 giving the total sales of boxes of Christmas cards.
4. Drag the formula in cell B11 to cells C11:F11. Did this give the right values for total sales of boxes of Birthday, All Occasion, Thank You, and Mixed cards?
5. In cell B12, enter a formula for the total profit made by these five persons selling Christmas cards. Do not enter any numbers, only cell references.
6. Drag the formula in cell B12 to cells C12:F12. Did this give you the right values for the total profit on boxes of Birthday, All Occasion, Thank You, and Mixed cards?
7. Using the SUMPRODUCT function, enter a formula in cell H6 giving Ann's total profit from selling all types of cards.
8. Drag the formula in H6 to cells H7:H10. Do not enter any numbers, only cell references. Did this give the right values for Bob's, Charles's, David's, and Ellen's total profit from selling all types of cards? If not, it is because you did not use absolute addresses for the profits per box. If that is the case, go back to cell H6. In the formula bar, highlight each unit profit and use the F4 key to make the reference absolute. After making all the references to unit profits absolute, now drag the formula in H6 to cells H7:H10. Now, did this give the right values for Bob's, Charles's, David's, and Ellen's total profit from selling all types of cards?
9. In cell B13, use the MAX function in order to determine the maximum Christmas card sales.
10. Drag the formula in cell B13 to cells C13:F13. Did this give the maximum values of Birthday, All Occasion, Thank You, and Mixed card sales?
11. In cell IS enter "Most Christmas Sales." In cell 16, enter an IF statement that will compare Ann's Christmas card sales to the maximum value in cell B13. If it is equal to this value, Ann's name (the entry in cell A6) should be printed in 16; otherwise, nothing should be printed-this is accomplished by entering " ".
12. 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?
13. 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(All Occasion Card Sales) + 0.05(Thank You Card Sales) * (Mixed Card Sales). In cell C15, determine Aim's total profit.
14. In cell C16, use an IF statement that compares Ann's profit using the new method proposed in problem 33 (given in cell Cl 5) with that of the old method proposed in problem 27 (given in cell 146). If the new profit is higher, "NEW' should be printed in cell C16; otherwise, "OLD" should be printed in the cell.
15. Suppose we wish to calculate the sum of all Mixed card sales of those persons who sold less than 20 boxes of Christmas cards. In cell C19, use a SUMIF command to determine this quantity.
Attachment:- greeting_cards_sales.xls