Excel 2016 Introduction

Excel 2016

Lesson – Creating Simple Formulas

NOTE You can enter a period ( . ) in place of a colon ( : ) when you are manually entering the endpoints of a range in a function (A1.A5). When you press the [Enter] key, Excel automatically replaces the period ( . ) with a colon ( : ). The name of a function is not case-sensitive. For example, you can type SUM , Sum , or sum into a cell. If you do not type the ending parenthesis when entering a function, Excel will add it for you. Some functions require more than one argument and some have optional arguments. Optional arguments are shown with square brackets in the ScreenTip for each function. The five functions listed above can have up to 254 additional arguments. Type a comma after a range to enter another argument. =AVERAGE(B5:B8,D5:D8,C16) calculates the average of all the numbers in B5 to B8 , D5 to D8 and cell C16 .



P ROCEDURES

1. Select the cell into which you want to enter the formula. 2. Begin the formula by typing the equal character [=] 3. Type the first letter or two of the function name. 4. Press the down arrow on the keyboard to highlight the desired option in the Formula AutoComplete list.

5. Press the [Tab] key to select the highlighted function. 6. Drag to select the range of cells to be calculated. 7. Release the mouse button. 8. Press [Enter] .



S TEP - BY -S TEP Use Formula AutoComplete to create a formula using a basic function.

Steps

Practice Data

1. Select the cell into which you want to enter the formula.

Click cell B12 , if necessary

The active cell moves accordingly.

2. Begin the formula by typing the equal character [=] The equal character[=] is entered in the selected cell.

Type [=]

OFFICEPRO, Inc.

Page 109