Pop Quiz

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

Spreadsheet Critical Thinking

If you need to change values in a worksheet when you own a business or are in a business using Excel allows you to change values quickly and easily.
When someone changes values in a worksheet it helps the business or company know where they are at in their income and their amount they spend.
The advantages of creating an electronic spreadsheet rather than a written one are the electric one can be changed as many times as needed where as the written one would have to be redone.
Being able to calculate the sums of numbers automatically is more valuable then calculating yourself because if you calculate numbers yourself there may be a chance that you can miscalculate and end up with the wrong numbers. But if you do it using an electronic worksheet the numbers will probably almost always be correct.

1. Advertisements
2. Bonuses
3. Employee salaries
4.
5.
6. Operation Income is the amount of money it takes to run a business.

3 Ways

1-3.Three ways to view a large spreadsheet is to zoom out and then you will see the whole spreadsheet, another way is by seeing the preview of the spreadsheet, and the last way is by making the columns smaller.
4.Semiannual means that something is being produced only two times a year not annually.
5.Projected means the estimate of how much something will cost.
6.The Gross Margin is the total of profit

Problems with Big Spread Sheets Isaac, Leslie, Aliya, Ceci

The problems of having a large spreadsheet are not being able to view the entire spreadsheet, including numbers and calculations. If a boss wanted a one paper spreadsheet we would have to shrink the size of the text in our spreadsheet. We wouldnt be able to include graphs in our spreadsheet because there wouldn't be enough space.

New News Report

Technology
5. New gaming technology announced to launch in 2010.
New consoles in 2010 are probably not going to happen, so because of this there is new software coming out. Project Natal is a revolutionary interface for Xbox 360, it ditches joysticks for an array of cameras and microphones that track your movements, recognize your face and respond to your voice. Microsoft says it'll be available this holiday season. Sony and Microsoft are said to be catching up to the Wii Console. Sony is going to make a motion controller that is similar to the Wiimote, but much more accurate. This controller can detect movements when in your hand (i.e. when having a virtual sword in your hand instead of the controller projected on the screen).

1. Website
2. http://www.cnn.com/2010/TECH/01/13/gaming.gear.2010/index.html
3. 10:30 PM on January 24, 2010
4. Gaming Technology, CNN News
6. This story is important because I am a gamer and I care about the gaming world right now.

How to Enter Formulas For Excel

To enter a formula in Excel you first have to select the cell you want to add a formula to. When you have selected it you will add the formula. In this case the formula for my spreadsheet is for F4 I will type =d4*e4. After I have done this the formula will calculate the numbers in my spreadsheet. Next i will go to G4 and type the formula =D4*G4. I will then get the sum. After that i will go to J4 and enter my formula which is =I4/F4. Lastly i will enter the last formula in cell F4. The formula is =D4*E4