Excel 2016 Introduction

Lesson – Creating Simple Formulas

Excel 2016

NOTE The formula checking rules can be enabled or disabled as desired. You can view the error checking options by selecting the File Tab menu, and the Excel Options button. Select the Formulas button, then go to the Error checking rules section. You can then select or deselect error checking options. The automatic color for the triangular error indicator is green, but you can use the Error Indicator Color list to select a different color. You can also select the Error Checking Options command on the error checking smart tag menu to open the Error Checking page of the Options dialog box.



P ROCEDURES

1. Select a cell displaying a green triangle in the upper, left corner. 2. Point to the error checking smart tag to display the ScreenTip.

3. Click the error checking smart tag

to display a list of error checking

options. 4. Select the desired option.



S TEP - BY -S TEP Use error checking options to correct an error in a formula.

Steps

Practice Data

1. Select a cell displaying a green triangle in the upper, left corner. The cell is selected, and the error checking smart tag appears to its left. 2. Point to the error checking smart tag to display the ScreenTip. A ScreenTip displays the reason for the identified error. 3. Click the error checking smart tag to display a list of error checking options. A list of available error checking options appears.

Click cell F9

Point to

Click

Page 122

OFFICEPRO, Inc.