Page 1 - Learning Computers and Technology
P. 1
07-MA-Spreadsheet 5/4/07 9:02 AM Page 241
|
Lesson 7
Spreadsheets:
Mathematics
Activity 1: Time Charts Activity 11: Organizing Data
■ Format Data ■ Use AutoFormat to Quickly Format a
■ Enter a Formula Worksheet
■ Create a Series ■ Use Table Styles to Quickly Format a
■ Change Column Width Worksheet
Activity 2: Measurements Activity 12: Proportions
■ Apply Number Formats
Activity 13: Stock Market Statistics
Activity 3: Calculating with a ■ Use Copy and Paste
Spreadsheet ■ Chart Basics
■ Create Charts
■ Change Data Alignment
■ About Styles
Activity 4: Calculating Percentages ■ Apply Styles
■ Use Functions
Activity 14: Charting Time
■ Common Functions
■ Relative Reference ■ Resize or Move a Chart
■ Absolute Reference Activity 15: Organizing Information in a
Activity 5: Putting it All on the Line Spreadsheet
■ Chart Elements ■ Add a Legend
■ Change a Chart
Activity 16: Sports Statistics
■ Change Chart Text
Activity 17: Tracking Wild Animals
Activity 6: Fahrenheit and Celsius
■ Add Data Labels
Activity 7: Finding the Median and Activity 18: Calculating the Median and
the Mean
the Mean
■ Sort Records in a List
■ Insert a Function
■ Rules for Sorting
Activity 19: Using a Spreadsheet to
Activity 8: Calculating Running Speed Organize Data
■ Insert and Delete Columns and Rows
■ Format a Chart
■ Compare Workbooks
■ Add Data Labels
Activity 9: Sports Statistics Activity 20: Increasing Quantities
■ Wrap Text
Activity 21: Statistics in Athletics
Activity 10: Calculating Costs
241