IF FREEZE QUIZ!!!

Freeze Panes

1. Select your location
2. Go to view
3. Window group
4. Freeze Panes

3 Options

1. Panes
2. 1st Row
3. 1st Column

IF Functions

1. Logic Test
2. If True
3. If False
   

Spreadsheet Critical Thinking

Having a spreadsheet automatically will help businesses by entering information. If you make a spreadsheet by hand then if your boss would say to change something you would have to draw it all over again and throw away that paper to make a new one. But if you were to use it automatically then you would just have to change that tiny thing on the computer and not have to start all over again. So the electronic spreadsheet is more helpful and useful then writing the spreadsheet by hand. It will make it more easier and faster.

Assumptions

Crystal, Janelle
If you were to change the Cost of Good Sold the Gross Margin would go up. If the gross margin goes up the Operating income will go up. Then the Semiannual Financial Projection will change.

Expenses & Income

Expenses

1. marketing
2. research&development
   
3. .
4. .
5. .
6. .

Operating Income

3ways to view large spreadsheets

1. To cut the pane in to two.
2. To make the screen smaller.
3. To
4. Semiannual-
5. Projected-To move something to somewhere else.
   
6. Grass Margin-The margins or space on the top of the page the bottom or the sides of the page.