Excel 2016 Managing Worksheets

Lesson 2 – Managing Worksheets

Excel 2016

Type a plus sign (+) and then click cell E3 on the March worksheet to complete the formula. The completed formula should be:

=January!E3+February!E3+March!E3.

Return to the table and continue to the next step (step 10).

Copy the formula to the range B4:B6 .

U SING 3-D R ANGES IN F UNCTIONS  D ISCUSSION

You can perform calculations on cells in multiple, adjacent worksheets by creating functions that use 3-D ranges. For example, you can use a 3-D range to sum the monthly totals that appear at the same cell address in multiple, adjacent worksheets. Since the function refers to the same cell address in adjacent worksheets, you can group the worksheets and then create the function. This technique can save time in creating functions such as SUM and AVERAGE .

In formulas that contain 3-D ranges, the worksheet names are separated from the cell address by an exclamation point (!). For example, in the following formula, the SUM function adds the numbers in cell F3 in four quarterly worksheets:

=SUM(Qtr 1:Qtr 4!F3)

A 3-D range in a SUM function

Page 26

OFFICEPRO, Inc.