Excel 2016 Managing Worksheets

Excel 2016

Lesson 2 – Managing Worksheets

Steps

Practice Data

2. Select the cell in which you want to create the formula. The cell is selected.

Click cell B3

3. Type = .

Type =

An equal sign ( = ) appears in the cell and on the formula bar.

4. Select the worksheet containing the data you want to use in the formula. The worksheet name appears on the formula bar, followed by an exclamation point (!), and the specified worksheet appears. 5. Select the cell containing the data you want to use in the formula. The cell address appears after the worksheet name in the formula bar. 6. Type the desired mathematical operator. The operator appears in the formula. 7. Select the worksheet containing the next piece of data you want to use in the formula. The worksheet name appears in the formula bar, and the specified worksheet appears. 8. Select the cell containing the data you want to use in the formula. The cell address appears after the worksheet name in the formula bar. 9. Continue adding mathematical operators and cell addresses as needed to complete the formula. The formula is completed.

Click the January tab

Click cell E3

Type +

Click the February tab

Click cell E3

Follow the instructions shown below the table before continuing to the next step

10. Press [Enter] .

Press [Enter]

The result of the formula appears in the cell containing the formula.

OFFICEPRO, Inc.

Page 25