Navigating in Excel
Alignment & Formatting
Importing & Printing
Charts & Graphs
- First select a blank cell into which you want your formula to go and
then insert a function into the cell by going to Insert
in the menu and selecting Function.
- The Insert Function window allows you to search for
functions, or select them by category. You should spend some time getting
acquainted with the different functions by scrolling through the list
and reading the descriptions that appear on the bottom of the menu.
- In this example, we are selecting the built-in Standard Deviation
(STDEV) function from the Statistical category.
- The Function Arguments menu is where you specify
the cells that you would like to be used in the formula.
- Here an answer is displayed in the selected cell and the formula
appears in the formula bar.
- In this example we are selecting the built-in EXACT function
from the Text category that will determine if two text
strings are exactly the same.
- Here the False response is returned because the function has identified
that these two sentences are not identical.
- The CountIf function counts the number of cells in
a range that meet a given criteria.
- In this example, we are counting the number of cells in range E1:J12
that contain the word "Book."
- The function returns the result in the selected cell.
Watch the video
dial-up | broadband