EXCEL FUNCTIONS
1) Sum: It returns sum of the values
Ex: =sum(A1:A3),
=sum(A1:A3, 100)
2) Multiply: It returns the Multiplication of numbers
Ex: = product(245,456)
=product(a1:a5)
3) Divide: It returns the division of two numbers
Ex: =(c1/d1)
=(245/5)
4) Average: It returns the average of the given numbers
Ex: =average (A1:A4)
=average(34,35,46,56)
5) Max: It returns the maximum value of a given range or numbers
Ex: =max(a1:a5)
=max(23,25,56,76)
6) Min: It returns the Minimum value of a given range of values
Ex: =min(a1:a5)
=min(12,45,13,34)
7) Sqrt : It returns the square root of a given value
Ex: =sqrt(12)
=sqrt(a1)
8) Today: It returns the todays day
Ex: =today()
9) Subtracting: It returns the subtraction value of a given range
Ex: =(24-34-65)
10) If : It returns the condition true value or false value
Ex: =IF(A1 > 5, "Greater than Five", "Less than Five")
11) Count: It returns the number value are there in the given range of cells
EX: =COUNT(A1:A5)
Excel 5.0 Keyboard Shortcuts
Move to cell A1...................................................................... CTRL-Home
Move to A Column of worksheet ........................................... Home
Go To ......................................................................................... F5
Move one window Left/Right .................................................... Alt-Page Up/Alt-Page Down
Move one window Up/Down..................................................... Page Up/Page Down
Insert AutoSum .......................................................................... ALT+=
Select entire Column ................................................................. CTRL+Spacebar
Select entire Row ....................................................................... SHFT+Spacebar
Clear Cell Contents .................................................................... Del/Backspace
Recalculate Worksheet .............................................................. F9
Switch from displaying Values/Formulas .................................. CTRL+`(single left quotation mark)
Edit a Cells Data ....................................................................... F2
Edit a Cells Contents (data, notes, etc.) .................................... CTRL+F2
Other Windows Keyboard Shortcuts
Save ........................................................................................... CTRL-S
New ........................................................................................... CTRL-N
Open .......................................................................................... CTRL-O
Print ........................................................................................... CTRL-P
Select All ................................................................................... CTRL-A
Undo last action ......................................................................... CTRL-Z
Repeat last action ....................................................................... F4
Cut ............................................................................................. CTRL-X
Copy .......................................................................................... CTRL-C
Paste........................................................................................... CTRL-V
Find ........................................................................................... CTRL-F
Find & Replace .......................................................................... CTRL-H
Fill Down .................................................................................. Ctrl-D
Fill Right ................................................................................... Ctrl-R
Spell Checker ............................................................................. F7
Help Menu ................................................................................. F1
Formatting Shortcuts
Bold ........................................................................................... CTRL-B
Italics ......................................................................................... CTRL-I
Underline ................................................................................... CTRL-U
Format Cells ............................................................................. Ctrl-1
Insert Cells ................................................................................ Ctrl-SHIFT-=
Other Important Terms and Symbols
& ..................................................... Concatenation
= ...................................................... Equal to
< ...................................................... Less than
> ...................................................... Greater than
<= ................................................... Less than or equal to
>= ................................................... Greater than or equal to
<> ................................................... Not equal to
Circular ........................................... A cell is referencing itself
Edit ................................................. Editing is in process
Enter ............................................... Data entry is in process
Filter ............................................... A database is being filtered (selected by specific criteria)
Point................................................ A cell or a range needs to be selected for use in a formula
Ready .............................................. Excel is ready to accept a command
Recording ....................................... Macro recorder is recording
