Excel Formulas & Functions
In a spreadsheet there are three basic types of data that can be entered. LABEL CONSTANT FORMULA My Spreadsheet 5 or 3.75 or -7.4 =5+3 or = 8*5+3 anything that is just text any number math equation
To Format Cells 1. Highlight the cells to be formatted, select format from the menu. 2. From the window that appears, first select the type of data that will be put into the selected cell(s). 3. Click the Alignment tab, and select how you want the data aligned in the cell. 4. The Font tab allows you to select what font you want for the data in the selected cell(s). 5. If you want to apply a border to the selected cell(s), click the Border tab, and select the border type you would like to use.
Operator Its Function Example =2+3 =5-4 =4/2 =5*2 =25% =5^3 =4=7 =4<>7 =3>5 =7<9 =22<=5 =33>=9 “Try this”&“example” Result 5 1 2 10 0.25 125 False True False True False True Try this example
Formulas are entries that have an equation that calculates the value to display. To Enter a Formula 1. Click the cell where you want to enter a formula. 2. Type an equal sign (=) and begin typing the formula. 3. When finished typing the formula, press the Enter key on the keyboard. Edit a Formula 1. Double-click the cell that has the Formula you wish to edit. 2. The Formula will be displayed in the cell. Use the keyboard to edit the Formula. 3. Press the Enter key when finished.
+ / * % ^ = <> > < <= >= &
Addition Subtraction Division Multiplication Percentage Exponentiation Equal to Not Equal To Greater Than Less Than Less Than or Equal To Greater Than or Equal To Text Concatenation
Functions are predefined formulas included in Excel Examples of Functions include: Sum, Average, Max, Min and Count. For example, with Average - Excel knows to compute an average it must add all the items together and divide by their count.
=PMT(C4/12,C5,-C3) .
This formula is a function, as PMT has been predefined in Excel. The PMT function returns the periodic (in this case monthly) payment for an annuity (in this case a loan).