steps for the freeze a pane
1.select cell
2.go to tab window
3.in the window group
4.select colum


1.logic test
2.if true
3.if false

The advantage by learning about automated Spread Sheets is that it makes everything fast and reliable.

In a spread sheet with pencil and paper if you change something nothing else would change and you would have to start all over again. An automated Sheet you change something and the corresponding cells will change and you don't have to start all over again.

1. Advertising
2.marketing
3.bonus
4.
5.
6.Gross margin

tree ways to view large spread sheets

1.At the bottom of the work book you can zoom out as much as you can
2.
3

4.Semiannual
5.Projected
6Gross Margin

i think the best easiest way is just to put the formula, although theres five ways,this is the best way (Ex. D4:D12) AVERAGE. And it makes you feel smart. the other way is to select the cells and go up to the auto sum

Creating a letter is easy the first thing you need to do is choose the right font size for your header with the right color and picture.pictures are better found on clip art because dragging and then use return to go down on the lines and then write to whom the letter is being send to if its a company don't forget to put the name of the factory the persons working for or any kind of organization also put it in