Step 1: Create Excel Worksheet to Calculate GPA
Design and construct an Excel worksheet that can be used to calculate your GPA. Make sure you use formulas to total and calculate your grades for past courses as well as future ones.
Step 2: Create Excel Worksheet to Calculate Class Statistics
Create a worksheet that calculates class statistics, such as the percentage of male and female students and the number of students who have photos posted in Canvas.
Step 3: Create Excel Worksheet to Calculate MPG
Design a worksheet to keep track of car mileage and how much you pay for gas during a two-week period. Use the information to calculate MPG for your car.
Step 4: Research
- Conduct research on different types of errors that might occur in Excel and how to prevent/correct them.
- Conduct research on the Internet on how to clear a conditional format from a worksheet cell. Summarize your findings.
Step 4: Find and Replicate Organization Chart
Search the Internet to find an organization chart (or, you can use one from your workplace.) Replicate the chart using Excel.