Excel 2016 Managing Worksheets

Lesson 2 – Managing Worksheets

Excel 2016

Steps

Practice Data

5. Select the cell that contains the data you want to use in the function. The cell address appears after the worksheet name in the formula bar. 6. Hold [Shift] and select the last worksheet you want to include in the 3-D range. The 3-D range appears in the formula bar. 7. Type the closing parenthesis ( ) ). The closing parenthesis ( ) ) appears in the formula bar.

Click cell F3

Hold [Shift] and click the March tab

Type )

8. Press [Enter] .

Press [Enter]

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

Select cell C3 in the Qtr 1 sheet and view the formula in the formula bar. Then, copy the formula to the range C4:C6 . Close MONTH2.XLSX.

Page 28

OFFICEPRO, Inc.