Wednesday, February 17, 2010

if functions
1. logical test
2. if true
3. if false it gets nothing

freeze
1.0 selection location
2. view tab
3. window group
4. freeze panels

a) freeze panels
b) freeze 1st row
c) freeze 1st column

Friday, February 5, 2010

critical thinking other 2 questions

Although electronic spreadsheets were introduced less than 50 years ago, people have created spreadsheets by hand for hundreds of years.
*What are the advantages of creating an automated spreadsheet rather than a hand written one?
the advantages of creating a spreadsheet automated is that we don't have to take hours, days to make it. we have a really big advantage.
*How does the capability to recalculate automatically when values change, make an electronic spreadsheet more valuable than a spreadsheet created by hand?
it makes it more valuable because it is really easy to change the values and make then correct and it does not take us a really extremely long time to do so.

spreadsheet critical thinking

excel allows you to change values in a worksheet quickly and easily.
How is this helpful in running a business?
This is helpful in running a business because it will help you do things really easy and it will not take long, this is quick and easy. Also it does practically all the work for you because you just click on the buttons.

How can changing values affect business decisions?
Changing values affects business decisions in many ways, if you are going to use formulas to change the values and auto sum them, make sure that you type in the correct formula otherwise you will have a wrong a answer and that will affect your business.

Thursday, February 4, 2010

Expenses
1.freeze
2.split
3.hide ribbon
4.semiannual is twice a year
5.
6.operating income

Wednesday, February 3, 2010

i think i did okay.

1.a way to view a large spreadsheet is by making it larger with the mouse.
2.another way to make a spreadsheet larger is by pressing on command and the button above the tab key
3.another way to open a large spreadsheet is
4.semiannual
5.gross margin
6. projected is a word that has to do with excel and spreadsheets.