EXCEL TEST:

  1. Read and do Case 4 on pages 255 to 256–MAKE NOTE:
    • The 6 bullet points need to be done for EACH CHART!!!
    • #1–DOWNLOAD THIS FILE & save it to your drive–you need to open it in Excel on your computer–NOT ONLINE
    • #2–Do it
    • #3–Read & do it–Use the example
    • #4–Read & do it–Use the example
    • #5–Do ONLY 1 pie chart representing the points for each Maryland player–Use the example (similar to the column chart only choose pie chart instead)
    • #6–Insert a formula to subtract 2 cells–Use the examle
    • #7–Read & do it–Use the example
    • #8–Read & do it–Look at the example
    • #9–Read & do it–Use the example
    • ADDITIONAL INSTRUCTIONS:
      1. On the Box Scores sheet:
        1. Enter a function to calculate the totals for the following columns for both teams:
          1. OFF
          2. REB
          3. AST
          4. PF
          5. PTS
        2. Enter an absolute cell reference in B36 & C36 to the total points for each team in cells I20 & I33
        3. Enter a formula in cell B37 to divide 25 by 57
        4. Enter a formula in cell C37 to divide 28 by 58
        5. Enter a formula in cell B38 to divide 17 by 27
        6. Enter a formula in cell C38 to divide 12 by 24
        7. Enter an absolute cell reference in B40 & C40 to the total assists for each team in cells G20 & G33
        8. Enter an absolute cell reference in B41 & C41 to the total rebounds for each team in cells F20 & F33
      2. Put your name in the left header and the filename in the right header for every page.
      3. Print as follows:
        1. Documentation sheet–portrait–fit to 1 page
        2. Game Report sheet–landscape–fit to 1 page
        3. Box Score sheet–answers–portrait–fit to 1 page
        4. Box Score sheet–formulas–landscape–fit to 1 page
        5. Game Log sheet–answers–portrait–fit to 1 page
        6. Game Log sheet–formulas–landscape–fit to 1 page
        7. Season Record sheet–portrait–fit to 1 page