Wednesday, February 17, 2010

Freeze and IF

Freeze Panes 4 steps/three options
1)Select Location
2)Go to View
3)WIndow Group
4)Freeze Panes
a)panes
b)1st Row
c)1st column

IF function/3 parts
1)logic test
2)if true
3)if false

Friday, February 5, 2010

Spreadsheet Critical Thinking

Using Excel is helpful in running a business because it helps you keep track of things and using it for finding your expenses and stuff like that. Changing the values affects the business because by changing one value it changes the other things.
The advantages of creating an automated spreadsheets rather than a hand written one is that when your finding the sum of your numbers easier. The capability to recalculate automatically make an electronic spreadsheet valuable because when you create one by hand, you'll probably have to add everything up yourself, and with the spreadsheet, you can just press the sum button on the home tab and you do less work. And when you change one number by hand, you have to go back and calculate everything again. But with an electronic spreadsheet, you can change the number and it'll fix everything to where you don't have to figure it out yourself.

Thursday, February 4, 2010

Isaac W, Thania, Natalie

if we make more commission happen the margin would be smaller cause we'd be paying people more. If we spend less on research and development we would gain more margin If we spend more on marketing, our margin would go down.
If we spend less on bonuses, we would increase on margin. If we increase our cost of goods, our margin would go up. if we decrease our Support, General, and Administrative, we would gain more margin.

Isaac
Thania
Natalie

5 Expences Operating Income

1)One is Support and Administrative

2)Another is Marketing

3)Development and Research

4)
5)

6)Operating Income is: You add all to find the total.

Wednesday, February 3, 2010

3 Ways To View Large Spreadsheets

1) one way is to change the way you view it
2)
3)
4) Semiannual: means yearly or monthly or weekly
5)Projected:
6)Gross Margin: