Excel 2016 Introduction

Lesson – Creating Simple Formulas

Excel 2016

As you type or select cell addresses, Excel places a colored border with squares at each corner around each referenced cell. Excel uses a different color border for each cell referenced in the formula.

Enter a formula

NOTE Cell addresses are not case sensitive; you can enter a cell address as either C5 or c5 . However, when you press the [Enter] key, Excel automatically changes all cell references to uppercase. You can display formulas in the worksheet cells (rather than their results) by selecting the Advanced category in the Excel Options dialog box and selecting the Show formulas in cells instead of their calculated results option in the Display options for this worksheet section. This option is useful as a teaching tool or when auditing a worksheet for formula errors.



P ROCEDURES

1. Select the cell in which you want to enter the formula. 2. Type an equal sign ( = ) to begin the formula.

Page 100

OFFICEPRO, Inc.