Activity # 2Spread Sheet Unit
|
||||||||||||||||||||||||||||||
Spreadsheet #2 – Profit Sheet
1.
Create a
spreadsheet header with your company’s name and "Profit Sheet"
2.
Estimate
the width for the columns
3.
Highlight
column B and format it with “currency.”
4.
Indent
the individual expenses two spaces from the left side of the column by pressing
the space bar 4 times before you type them.
Press the space bar 8 times before “Total Expenses.”
5.
Enter the
expenses according to the spreadsheet on this sheet.
6.
Create
formulas to determine the total expenses. (Add
up all the individual expenses by using the auto sum button)
7.
Create a
formula to determine the Net Income (Gross Income minus Total Expenses)
8.
Save the
spreadsheet as “SS2 Profit Sheet”
9.
Answer
the following questions on the spreadsheet you just created.
·
Have you
made enough money according to this spreadsheet to afford a $600 printer next
year?
·
How much
was you advertising cost?
·
What was
the total amount of you expenses?
·
If you
spend $600 on the new printer, how much money will you have left over?
10.
Print
preview the spreadsheet and the answers and make sure it fits on one page, then
print.
11.
Go
to Tools – Options
and turn off the Gridlines and turn
on the Formulas.
12. Print preview again and make sure it fits on one page and print a copy with the formulas showing.
|
||||||||||||||||||||||||||||||
|
Created By: John Kelsey |
||||||||||||||||||||||||||||||