CLICK HERE FOR BLOGGER TEMPLATES AND MYSPACE LAYOUTS »

Monday, November 17, 2008

Microsoft is EXCELent you have my word!

Overview:
For the past few classes, we have been learning all about Microsoft Excel. Microsoft Excel is a computerized spread sheet that came out in the 1990's. Microsoft Excel has become an Industrial Standard, meaning most people have this program and use it. Before Excel and programs like Excel, creating spreadsheets was truly a hassle. Excel consists of many lettered columns and numbered rows. Like an LCD Monitor, Excel works much like a game of Battleship. These numbers and letters are used to locate cells on the spreadsheet. Each cell has million of tiny calculators, allowing the user to put in individual commands towards certain cells. Microsoft Excels functions are much like other Microsoft programs, making the user feel more comfortable toward Microsoft programs.

Advantages:
- Calculations errors? Not a problem excel deals with those very conveniently
- Least amount of work involved as possible

More Facts:
There are 3 types of information that can be put into a cell.
-Text- Words
-Value- Numbers
-Formula - a mathematical phrase that tells the cell what to calculate.

Formulas known so far:

=SUM(number1, number2,...) - Totals the numbers given
=AVERAGE(number1, number2,...) - Gets an average for the numbers given
=MAX - Gives the largest amount as an answer
=MIN - Determines smallest amount in a given group of numbers
=COUNT - (Counts how many cells have number amounts given)
=COUNTA - (Counts both NUMBERS and TEXT)
=IF (condition, value-if-true, value-if-false) - Returns an answer to an 'IF' question
=PMT(rate, NPER, PV, FV, type) - PMT Function (The periodic payment for an income)

[(rate) interest rate per period, (NPER) number of payments until repaid, (PV) present value of the loan; the amount we're borrowing, (FV) future value of the money; for saving or investing, (type) enter 0 or 1 to indicate when payments are due.]

That's all I've got so far on our journey to conquer EXCEL!

I'll report on what I find next in future posts!

0 comments: