Wednesday, February 17, 2010

Goeldner's Quiz

1)Select Location
2)View Tab
3)Window Group
4)Freeze Panes
a)Freeze the Panes
b)Freeze the First Row
c)Freeze the First Column
1)Logic Test
2)IF True
3)IF False

Friday, February 5, 2010

Spreadsheet Critical Thinking

A spreadsheet is helpful in running a business because using a spreadsheet helps a business owner keep track of his sales, perhaps. Changing values in a spreadsheet affect business decisions because for example, say by changing one value causes the other cell numbers to go down, then the business may want to work on why that value changed. The advantages of creating an automated spreadsheet rather than a hand written one is making an automated sheet is faster and easier. A hand written sheet would take much longer to do. The capability to recalculate automatically when values change makes an electronic spreadsheet more valuable than a spreadsheet created by hand because on an automated sheet the numbers change automatically when you recalculate. On a hand made spreadsheet, you would either have to erase all the numbers and redo the sheet or just make a brand new spreadsheet.

Thursday, February 4, 2010

What-If Assumption

Rosakenly
Jessica
Melissa
Marissa

If you change the Marketing Assumption from 9% to 20%, the Marketing Expense would go higher in its amount, the Total Expenses would then change because of the Marketing Expense changing, and that would mean the Operating Income would change as well.
1. Bonuses
2. Commission
3. Marketing
4. Research and Development
5. Support, General, and Administrative
6. Operating Income = Commission - Expenses

Wednesday, February 3, 2010

I think I missed 2

1. Freeze and Unfreeze
2. Fix the Margin to Narrow
3. Make it fit on one sheet
4. Semiannual - Twice a year
5. Gross Margin - The Total of the numbers
6. Projected - To plan something

Tuesday, February 2, 2010

Warren Buffet

Warren Buffet is a stock buyer. In 1998 he started buying Coca-Cola stock like an addict. By 1989, Buffet was now, personally, worth more than $3.8 billion dollars. Within the next ten years, he would be worth ten times that amount. During the remainder of the 1990's the stock catapulted as high as $80,000 per share. Even with this astronomical feat, as the dot-com frenzy began to take hold, Warren Buffet was accused of "losing his touch". In 1999, when Berkshire reported a net increase of 0.5% per share, several newspapers ran stories about the demise of the Oracle. Confident that the technology bubble would burst, Warren Buffet continued to do what he did best: allocate capital into great businesses that were selling below intrinsic value. His efforts did not go unrewarded. When the markets finally did come to their senses, Warren Buffet was once again a star. Berkshire's stock recovered to its previous levels after falling to around $45,000 per share, and Buffet was once again seen as an investment icon.

Monday, February 1, 2010

iPad

The iPad is a new large, high-resolution LED-backlit, IPS display. It is an incredibly responsive Multi-Touch screen. And an amazingly powerful, Apple-designed chip. All in a design that's thin and light enough to take anywhere. iPad isn't just the best device of its kind. It's a whole new kind of device. The 9.7 inch LED-backlit, IPS display on iPad is remarkably crisp and vivid. Which makes it perfect for web browsing, watching movies, or showing off photos. It's also been designed to work in any orientation - portrait or landscape. And because it uses a display technology called IPS (in-plane switching), it has a wide, 178 degree viewing angle. So you can hold it almost any way you want and still get brilliant picture, with excellent color and contrast.