Wednesday, April 14, 2010

Long Term Goals

  1. Graduate from high school
  2. Staying close to my friends and family after graduating
  3. Being better at organizing and stop procrastinating
  4. Having a job that I want and like
S: I want to become a psychologist or lawyer
M: Within a couple years of graduating
A: Going to college and studying
R: I feel like I can do this because it's something that I want to do
T: The amount of years needed in college

Wednesday, February 17, 2010

Freezing/IF

I was absent 2-16-09

Freeze Panes
1.
2.
3.
4.
a.
b.
c.

IF function
1.
2.
3.

Friday, February 5, 2010

Spreadsheet Critical Thinking

-Excel is helpful in running a business because when using a spreadsheet it'll be easier to figure out the costs and totals of stuff. Also by using a spreadsheet you can change the values to see how it will affect the the totals so the business might want to change something to make a better profit.
-The advantages of creating an automated spreadsheet rather than a hand written one is that when you need to fix something you can fix it quick and by using formulas you can find the amount right away without having to figure out what it would be if you are using a spreadsheet by hand.
The capability to recalculate automatically when values change, make an electronic spreadsheet more valuable than a spreadsheet created by hand because by using formulas you can get the amounts fast unlike with a hand written one where you would need to figure it out and you might not be able to read what you wrote.

Thursday, February 4, 2010

  1. Research and development
  2. Support/ General
  3. Marketing

Wednesday, February 3, 2010

3 ways to view a large spreasdsheet

1. Hide the ribbon
2. Freeze screen
3.
4.
5.
6.

Thursday, January 21, 2010

methods to enter functions

In Excel there are five ways to enter functions. The five ways are to use: the keyboard or mouse, the insert function box in the formula bar, the Sum menu, the AutoSum command on the Formula tab in the Ribbon, and the Name box in the Formula bar.

Thursday, January 14, 2010

In Excel to get the initial cost, current value, gain/loss, and percent gain/loss you need to type in the formula in the row that it's in. To get the initial cost you multiply the Shares and Initial price per share with the formula =D4*E4. Current value is the Shares multiplied by the Current Price Per Share with the formula = D4*G4. Gain/loss is the Current value minus the initial cost with the formula =H4-F4. The Percent gain/loss is the gain/loss divided by initial cost with the formula =I4/F4