Excel 2016 Introduction

Excel 2016

Lesson – Creating Simple Formulas

3. Enter the first cell referenced in the formula. 4. Enter the first mathematical operator. 5. Enter the next cell referenced in the formula. 6. Continue entering cell references and mathematical operators as needed. 7. When you have finished creating the formula, press [Enter] .



S TEP - BY -S TEP From the Student Data directory, open SALES4.XLSX . Enter a formula into a cell.

Create a formula to compute the Net Profit for District 1 by selecting the Total Sales in cell B16 and subtracting the Expenses in cell B17.

Steps

Practice Data

1. Select the cell in which you want to enter the formula. The cell becomes the Active Cell . 2. Type an equal sign ( = ) to begin the formula. An equal sign (=) appears in the Formula Bar and in the cell. 3. Enter the first cell referenced in the formula. The cell address appears in the Formula Bar and in color in the cell, a matching colored border appears around the referenced cell. 4. Enter the first mathematical operator. 5. Enter the next cell referenced in the formula. The cell address appears in the Formula Bar and in a different color in the cell, a matching colored border appears around the referenced cell. The operator appears in the formula bar and in the cell.

Click cell B18

Type =

Type B16

Type -

Type B17

OFFICEPRO, Inc.

Page 101