7. Test & Evaluate Location: Computer Lab Materials: Microsoft Excel Equations/Functions to produce the Cone Data Table This Handout Process: Open Microsoft Excel Save the file lastname_firstname_ConeChart – Go to box B1 type – “Start” In box C1 type by” – “Increase Box B2 type a starting value of your choice. This value represents the radii values. – Box C2 type an interval that you would like to increase your radius by to show a variety of – values. Titles B4 (cm)” – “radius C4 (cm)” – “height D4 height (cm)” – “slant E4 Area (cm2)” – “Lateral F4 V:LA” – “Ratio G4 of Net Circle (r=s)” – “Circumference H4 of Cone Base (r=r)” – “Circumference I4 Angle of Cone Net” (degrees)” – “Central J4 Angle” – “Explementary Formulas B5 (this means the value your placed in Box B2 will appear when you press – “=B2” Enter) B6 (This to add the constant value from Box C2 to the value in the – “=B5+$C$2” Previous Box) Think about solving the Cone Volume formula for What do you get? “h”. Show calculations here:
7. Test & Evaluate Location: Computer Lab Materials: Microsoft Excel Equations/Functions to produce the Cone Data Table This Handout Process: Open Microsoft Excel Save the file – lastname_firstname_ConeChart Go to box B1 – type “Start” In box C1 – type “Increase by” Box B2 – type a starting value of your choice. This value represents the radii values. Box C2 – type an interval that you would like to increase your radius by to show a variety of values. Titles B4 – “radius (cm)” C4 – “height (cm)” D4 – “slant height (cm)” E4 – “Lateral Area (cm2)” F4 – “Ratio V:LA” G4 – “Circumference of Net Circle (r=s)” H4 – “Circumference of Cone Base (r=r)” I4 – “Central Angle of Cone Net” (degrees)” J4 – “Explementary Angle” Formulas B5 – “=B2” (this means the value your placed in Box B2 will appear when you press Enter) B6 – “=B5+$C$2” (This to add the constant value from Box C2 to the value in the Previous Box) Think about solving the Cone Volume formula for “h”. What do you get? Show calculations here:
Analyzing%20the%20Data%20-%20Creating%20Excel%20Sheet.docx