Simple MS Excel Formula Example
Short Description
Simple MS Excel Formula Example. With Excel, it is easy to sum and … Type the formula directly in the cell. Entering Formulas. In Excel, formulas always …
Website: www.sonoma.edu | Filesize: 120kb
Content
Simple MS Excel Formula Example
With Excel, it is easy to sum and average your data.
Here’s how to insert a formula:
1. Click on a cell (where you would like your result to be).
2. Type the desired formula in the formula bar.
*If the X and check marks do not appear, click on the = sign.
OR
1. Click on a cell (where you would like your result to be).
2. Type the formula directly in the cell.
Entering Formulas
In Excel, formulas always
begin with “=”.
The cell highlighted on the
right is the sum of the row.
B2 to F2 represent the cells
that are counted in the sum.
Sum =sum(cell selection)
Average =average(cell selection)
Addition =B2+F2
Subtraction =B2-F2
Multiplication =B2*F2
List of basic formulas:
To make a selection, highlight all
of the desired cells using the
mouse.
Division =B2 / F2
Shortcuts
The “S” is a shortcut for sum.
1. Highlight the row or column you would like to sum up.
2. Click on the “S” shortcut.
The “fx” button will bring up a list of formulas you…
Get the file Download here
Related Searches: sum sum sum, formulas in excel, excel formula, excel formulas, formula 1
Comments
Leave a Reply
