This first exercise will familiarize you with the basic uses of a spreadsheet, using Excel as an example. At this point, you will see a sample spreadsheet, and learn how to edit spreadsheets and use formulas.
The completed basic spreadsheet found at the end of this exercise.
If you are having trouble with any of these things, you can go back to the Excel Intro page to catch up.
In this exercise you will be creating a spreadsheet for a (very) small business, which handles Toys of several varieties.Your spreadsheet should have the following columns:
Cost: How much it costs to get the item.
Price: How much the item is sold for.
#Sold: How many of those items have been sold. This column should be centered.
Gross: The Gross profit. #Sold * Price.
Expenses: How much it costs to make everything. #Sold * Cost.
Net: The Net profit. #Sold * (Price - Cost).Your spreadsheet should have the following rows:
The top row should be centered.
YoYo: Data for yo-yos.
Ball: Data for balls.
Bat: Data for bats.
Book: Data for books.
Banjo: Data for banjos.
Frog: Data for frogs.
Fish: Data for fish.
Puppy: Data for puppies.
Computer Games: Data for computer games.
Average: The average Net Profit. This row should be bold.
Total: Totals for Gross, Expenses, and Net. This row should be bold.When you are done, save your spreadsheet on a disk, sort the data alphabetically, and print a copy for the TA.
Here is a sample spreadsheet from the above exercise.
Once you have completed this exercise, you can move on to Excel Excercise 2