Monday, January 25, 2010

News

KFox News

Internet

Juarez Man Charged With Killing 2-Year-Old Stepson

January 24, 2010

Police in Cuidad Juarez said one man has been charged with murder of a 2-year-old boy. Police said Israel Rivera Alvarez, 37, allegedly punched the 2-year-old, leaving him seriously injured. Rivera Alvarez's girlfriend and mother of the victim, Ericka Ibarra, called police but when they arrived she told him the boy had fell. Police called an ambulance but when they arrived on the scene the boy had no signs of life. Ibarra later confessed to police Rivera Alvarez had hurt the boy. Both Rivera Alvarez and Ibarra were arrested in connection with the boy's death.

Thursday, January 21, 2010

Quick Quiz- Entering Functions

The five methods you can use to enter functions in Excel are the average, the lowest, the highest, the range, and the Auto Sum. You write =AVE and that will give you the formula, for the lowest you write =MIN and that will give you the formula, for the highest you write =MAX, for the range you go to insert function (fx) and then type range and click on the SUMIF, and for the Auto Sum you just click on the Auto Sum button in the home tab. So if you know the formulas it will be easier to type them than to go to insert functions (fx) and look for them. So theirs is five different functions to enter formulas.

Thursday, January 14, 2010

Stock Portfolio Spreadsheet Data & Formulas

To get the sum for F4 you will need to multiply D4 and E4 and that will give you the total of the initial cost, and do the same thing for D4 through F12. To get the Current Value you need to add the Initial Cost and the Current Price Per Share and that will give you the total for Current Value. To get the Gain/Loss you will need to subtract the Current Value from the Initial Cost and that will give you your Gain/Loss. To get the Percent Gain/Loss you have to take Gain/Loss and subtract the Initial Cost from it.