MOS CERTIFICATION PREP

FINISH:

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!!!
• #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
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