Before You Begin: Start Microsoft Excel. Open a new, blank spreadsheet.
Try This: Do the following steps
1. Enter the following labels in Row 1, beginning with Cell A1:
Date, Location, Sales, Profit. Format Row 1 as Bold.
2. Select A2. Enter: January
3. Select A2. Use the AutoFill command to
fill January through December in Column A.
4. Select B2. Enter the location as Ann
Arbor. Use the AutoFill command to fill the location through December
5. Select D2. Enter the formula for Profit.
Profit is 25% of the Sales. Use the AutoFill to fill the Formula from D2:D13.
6. Go to the bottom of Columns C and D, use
the AutoSum command to find the total Sales and total Profit for the
year.
7. Copy Sheet 1 two times.
8. Rename Sheet 1 to Ann Arbor.
9. Rename Sheet 2 to Detroit. Change the
Location to Detroit and AutoFill.
10. Rename Sheet 3 to Lansing. Change the
Location to Lansing and AutoFill.
11. Adjust the column widths where
necessary to fit the contents.
12. Go to the Ann Arbor sheet. Enter the
sales for January as $10,000. Format the column to be Accounting. Enter
the sales for February as $11,000. AutoFill down. The increment is an
increase of sales each month.
13. Go to the Detroit sheet. Insert 3 blank
rows at the top of the sheet. Add labels in column A for
Start
and
Increment. Enter the value
$15,000 for start. For increment enter 5,000. Enter the formula in the
Sales. January is $15,000, the starting point. February and beyond will
be start plus increment. Create an Absolute Reference for the Increment.
Use AutoFill and fill down.
14. Go to the Lansing sheet. Insert 3 blank
rows at the top of the sheet. Add labels in column A for Start
and Increment. Enter the value $20,000 for start. For increment
enter 110%. Enter the formula in the Sales. January is $20,000, the
starting point. February and beyond will be start times the increment.
Create an Absolute Reference for the Increment. Use AutoFill and fill
down.
15. Insert a new blank sheet in the
workbook. Rename the sheet Totals.
16. Enter the following labels on the
Totals sheet: Month, Sales, Profits
17.
Enter January in Cell A2 and AutoFill through December.
18. Enter the formula for Sales to add the
three locations (make sure you select January across all three
sheets—remember that Detroit and Lansing have the reference rows at the
top.)
19. Use the AutoSum to add the total sales
and total profit on the Totals sheet.
20. SAVE as YOUR NAME Legs Eggs and Pigs Practice. |
|
| |
