Microsoft Excel
2002 is the next installment of the Excel. Excel 2002 includes
such new features as a formula-auditing toolbar, speech: easily
dictate, navigate, and provide other commands with a microphone,
function argument tool tips and error checking smart tags.
Excel 2000 overview
Microsoft Excel is a program capable of creating and editing spread sheets. Spread
sheets can allow you to create your own payroll, balance your check book, organize large
amount of data in an easy to read format, and much more.
Unlike a word processor such as Microsoft Word, the Excel documents are created with
several hundred columns and rows that break down to several thousand cells. The user has
the capability of modifying these cells by color, number format, size, fonts, layout, and
thousands of additional available options.
In addition to modifying the look of Excel, users also have the capabilities of taking
the data contained in each of the cells and creating graphs based on the data contained
within the Excel file.
PC
EXCEL 2002
REQUIREMENTS
Computer:
100% IBM Compatible
Processor:
Intel
Pentium 133 MHz
Intel Pentium II 400 MHz required for speech recognition
Memory:
24MB
RAM for Windows 98
32MB RAM for Windows ME / NT4.0 SP3 / 2000
128MB RAM required for speech recognition
Drives:
150MB
minimum hard disk
drive space
4x CD-ROM
Sound:
Multimedia
computer required for sound and other multimedia effects.
Video:
Super
VGA (800 x 600) 256 colors or higher-resolution
Controls:
Keyboard /
Mouse
Operating System:
Microsoft
Windows 98 / ME / NT4.0 SP3 / 2000
Other:
Graphics tablet
recommended for handwriting input features.
Close-talk microphone for audio-output device required for
speech recognition
Price:
$200.00 -
$300.00
PC
EXCEL 2000 REQUIREMENTS
Computer:
100% IBM Compatible
Processor:
Intel
Pentium 75MHz or higher
Memory:
16MB
RAM for Windows 9x
32MB RAM for Windows NT4.0
Drives:
146MB
Hard disk
drive space
2x CD-ROM
Sound:
Multimedia
computer required for sound and other multimedia effects.
Video:
VGA or higher-resolution
Controls:
Keyboard
/ Mouse
Operating System:
Microsoft
Windows 95 / 98 / NT 4.0 with Service Pack 3
Other:
Requires
Microsoft Outlook 2000 or Outlook Express 5.0 for Microsoft
Office e-mail
Formulas
are what helped make spread sheets so popular. By creating formulas, you can have instantaneous
calculations when ever changing any information in your spread sheet. Formulas will always
begin with = and usually have the cell references in parentheses. In the below chart we
have shown several useful formulas and how to use them.
=
= simply will create a cell equal to another; for example, if you were to put =A1 in B1
what ever was in A1 would automatically be put in B1. You could also create a formula that
would make one cell equal to more than one value; for example, if you have a first name in
cell A1 and a last name in cell B1, you could put in cell A2 =A1&" "&B1
which would put cell A1 in with B1 with a space between.
=AVERAGE(X:X)
Average will display the average amount in between cells; for example, if you wanted to
get the average amount for cells A1 to A30, you would type in A31 or another cell
=AVERAGE(A1:A30)
=COUNTIF(X:X,"*")
Will count the cells that have a certain value. For example, if you had
=COUNTIF(A1:A10,"TEST") put in cell A11 then anywhere between A1 through A10
that has the word test would be counted as 1, so if you had 5 cells that had the word test
A11 would say 5.
=IF(*)
If can sometimes be the most complicated statement if used for advanced features
but can be very simple for non advanced features. The * in the left column is to
represent wild character(s) because the possibilities are endless. The syntax of the IF
statement are =IF(CELL="VALUE" ,"PRINT OR DO THIS","ELSE
PRINT OR DO THIS"). So a good example of the syntax would be
=IF(A1="","BLANK","NOT BLANK"), this would make any cell
besides cell A1 say "BLANK" if a1 had nothing within it, and "NOT
BLANK" if any information was within it. The if statement can, of course, become a lot
more complicated but can be easily reduced if following the above structure.
=MIN/MAX(X:X)
Min and Max represent the Minimum amount in the cell(s) specified or the Maximum
amount in the cell(s) specified; for example, if you wanted to get the Minimum amount
between cells A1 and A30 you would put =MIN(A1:A30) the same aspect if you wanted to get
the Maximum about =MAX(A1:A30)
=SUM(X:X)
Sum represents the function to add or subtract information by placing a : or a + this
would add the cells represented by X. For example, if you wanted to add Cell A1 + B1 you
would enter the below formula in C1 or any cell of your choice. =SUM(A1:A2). If you
wanted to subtract the cells you would enter =SUM(A1-A2). You can also do =SUM(A1*A2)
which would multiply the amount, or =SUM(A1/A2) which would divide the amount.
=SUMIF(X:X,"*"X:X)
Very nice formula that allows you to only add information if there is a certain value
in the fist selected cells. An example of this would be
=SUMIF(A1:A6,"TEST",B1:B6) which would only add the values B1:B6 if test was put
somewhere in between A1:A6. So if you put TEST (not case sensitive) in A1, but had
numbers in B1 through B6, it would only add the value in B1 because TEST is in A1.
=TODAY()
Would print out the current date in the cell entered.
=TREND(X:X)
To find the common value of cell, for example, if cells A1 through A6 had 2,4,6,8,10,12
and you entered formula =TREND(A1:A6) in a different cell, you would get the value of 2
because each number is going up by 2.
Spreadsheet
CH000462
Forum