Your Excel project
Open the very basic excel sheet by clicking here.
Open the first saved version of the Excel workbook by clicking here.
- Begin by looking at how the formulae in C3, B20, and I20 are written. You can do this by clicking in them and looking at the formula bar near the top of the screen.
- What do you see about how they are written?
-
What is in the cells to indicate certain functions?
Step I.
|
We will stick with fairly basic Excel functions, but please know that you can go completely wild with Excel. It can forever dominate your destiny - see Star Wars. We are going to start out by entering and sorting data. Begin by following the instructions in Step 1. |
|
||
Part II.
Directions: |
Here are some handy tips for the data: Keeping the data in similar groups that you can identify by appearance and location is handy. Keeping your column and function descriptionsis also very handy. I like to have my data sets close enough together that they can appear on one screen view.
|
You will create your own support file for the first two steps of this project. |
||
Part III.
|
Evaluation Form
In your Excel Workbook, keep all of the following as saved pages:
-
Save your class list with the data sort, mean, median, and mode functions completed.
15 points - all are complete
12 points - all but one are complete
9 points - all but two are complete
6 points - only one is complete
-
Save your shopping list with the graph, sales tax calculator, and totals completed.
15 points - all are complete
11 points - all but one are complete
8 points - all but two are complete
-
Save your interest planner with the deposit amounts, years, and total calculations completed.
15 points - all are complete
11 points - all but one are complete
8 points - all but two are complete