Freezing the IF :D

Freeze Panes

1. Select Location

2. View Tab

3. Window Group

4. Freeze Panes

a.) panes b.) 1st Row c.) 1st Column

IF Function

1.) Logic Test

2. If True

3.) If False

Critical Thinking :|

*How is this helpful in running a business? Excel is helpful because you change the values in the spreadsheets with the click of one button.

*How can changing values affect business decisions? It affects business decisions because if the values were to change to bad numbers, the company would have to make quick decisions to try to get values back to a good number.

*What are the advantages of creating an automated spreadsheet rather than a hand written one? For one, if you were to have a hand written spreadsheet you would have to erase or white out the numbers that change or were not correct. If you use an automated spreadsheet you can just click the cell and change the number.

*How does the capability to recalculate automatically when values change, make an electronic spreadsheet more valuable than a spreadsheet created by hand? Well it calculates the values for you, if you were to hand write it, you would have to add all the numbers together to get your answer making you do more work.

Assumptions Yoli, Tahnee, Isaac D

If the cost of goods goes down the gross margin increase. If the cost of goods down the gross margin will decrease. If the expenses increase, the total amount would be increase, changing the entire pie-chart.

1. R & D Research and Development

2. Support, General & Administrative

3. Marketing

4.

5.

6. Operating Income

=Gross Margin- Total Expenses.

Spreadsheets

1. reduce the size of the entire spreadsheet.

2. reduce the text on the spreadsheet.

3.

4. Semiannual-

5. Projected-

6. Gross Margin-

iPad= Ehhh.

The newest product apple put on the self is the IPad. Too me, I find the IPad to be a larger version of an iPod touch. I don’t like how they are trying to make it seem like the best new thing. Wow it has three programs that the Mac computers have, Numbers, Pages, and Keynote. In videos they just talk about how the IPad can have apps. What a big whoop!! It’s an iPod with a big screen. IPhone, iPod, IPad all have calendars, music, Internet, contacts, maps, notes, music, and videos, I don't find the iPad different from their other products.