Excel 2016 Managing Worksheets

Lesson 2 – Managing Worksheets

Excel 2016

=Qtr 1!E3+Qtr 2!E3+Qtr 3!E3+Qtr 4!E3

A 3-D formula



P ROCEDURES

1. Select the worksheet in which you want to create a 3-D formula. 2. Select the cell in which you want to create the formula. 3. Type = . 4. Select the worksheet containing the data you want to use in the formula. 5. Select the cell containing the data you want to use in the formula. 6. Type the desired mathematical operator. 7. Select the worksheet containing the next piece of data you want to use in the formula. 8. Select the cell containing the data you want to use in the formula. 9. Continue adding mathematical operators and cell addresses as needed to complete the formula. 10. Press [Enter] .



S TEP - BY -S TEP Create 3-D formulas in a worksheet.

Steps

Practice Data

1. Select the worksheet in which you want to create a 3-D formula. The worksheet is selected.

Scroll as necessary and click the Qtr 1 tab

Page 24

OFFICEPRO, Inc.