Axis. Press Equals and select cell A5. Click on the Axis Titles button. Select Primary Vertical Axis- Rotated Title. Press Equals and select cell E4. Click on Data Labels and select Outside End. 16. Resize Chart, Select the chart. Click the adjust Data Labels Format Tab in the Chart and format Vertical Tools Tab. Axis. Adjust the size to Height: 5” Make sure there is a box and Width: 7”. around the axis values. Click on each Data Label and move it just enough to avoid overlapping and lines. Select the Vertical Axis. Right click and select Format Axis. Click the Number Tab and adjust the Decimal Places to zero. Click Close. 17. Print Animal Make sure the print area Click cell A1 on the Animal Science Chart is set to Print Active Science Chart Worksheet. Worksheet. Sheets. Click File, Print. Change the Orientation to Landscape. Change Scaling to Fit Sheet on One Page. Click on Page Setup and select the Header/Footer Tab. Click Custom Header… In the Left Section type your name, in the Center Section type your class section. Click on the Right Section then click the Date button. Press Print. 18. Submit an Place your file in the correct electronic copy of folder for grading. your file. TOTAL SCORE Job Operation Sheet Name: Class: Agriscience _____________________________________ Area: Agriscience- Data Analysis Date: ____________________ Job: Creating a Data Table in Word Step Procedures Key Points Assessment 1. Open New Blank Open Excel file Be sure to Save As and “Class Document file and Experiment Graphing insert your last name.
Axis. Press Equals and select cell A5. Click on the Axis Titles button. Select Primary Vertical Axis- Rotated Title. Press Equals and select cell E4. Click on Data Labels and select Outside End. 16. Resize Chart, adjust Data Labels and format Vertical Axis. Select the chart. Click the Format Tab in the Chart Tools Tab. Adjust the size to Height: 5” and Width: 7”. Click on each Data Label and move it just enough to avoid overlapping and lines. Select the Vertical Axis. Right click and select Format Axis. Click the Number Tab and adjust the Decimal Places to zero. Click Close. Make sure there is a box around the axis values. 17. Print Animal Science Chart Worksheet. Click cell A1 on the Animal Science Chart Worksheet. Click File, Print. Change the Orientation to Landscape. Change Scaling to Fit Sheet on One Page. Click on Page Setup and select the Header/Footer Tab. Click Custom Header… In the Left Section type your name, in the Center Section type your class section. Click on the Right Section then click the Date button. Press Print. Make sure the print area is set to Print Active Sheets. 18. Submit an electronic copy of your file. Place your file in the correct folder for grading. TOTAL SCORE Job Operation Sheet Class: Agriscience Area: Agriscience- Data Analysis Job: Creating a Data Table in Word Name: _____________________________________ Date: ____________________ Step Procedures Key Points Assessment 1. Open New Blank Document file and Open Excel file “Class Experiment Graphing Be sure to Save As and insert your last name.