Excel Spreadsheet Exercise 1

Guidelines:

1. Open the spreadsheet titled, “LOGICAL FUNCTIONS”
2. Using the SUM function, compute all totals for column B through H
3. Using the AVERAGE function, compute all AVERAGES for column B through H
4. Computer the BONUS column using the IF function:
   All Reps get a 10% (0.1) BONUS IF their QUARTER sales are GREATER THAN the QUOTA value. If the Quarter sales are NOT GREATER THAN the QUOTE, there should be no BONUS added to the TOTAL (Column H).
   1. This is the function/formula to use:
      =IF(E8>F8,E8*0.1,0)
   2. Compute the TOTAL column:
      =E8*0.1+G8
5. Add a CLUSTERED COLUMN CHART with a Chart title (Claremont Sporting Goods – 1st Quarter Sales)
6. When you have completed all computations, use the FILTER feature to SORT by Rep Name (A to Z)
7. Merge and Center the Titles across the worksheet (from A through I)
8. Add a HEADER that has your NAME in the TOP RIGHT CORNER
9. RENAME the worksheet Sales: Qtr1
10. Save and Upload