Excel 2016 Managing Worksheets

Excel 2016

Lesson 2 – Managing Worksheets

P ROCEDURES

1. Select the worksheet in which you want to enter the function. 2. Select the cell in which you want to enter the formula. 3. Type = , followed by the function name and an open parenthesis ( ( ). 4. Select the first worksheet containing the data you want to use in the function. 5. Select the cell that contains the data you want to use in the function. 6. Hold [Shift] and select the last worksheet you want to include in the 3-D range. 7. Type the closing parenthesis ( ) ). 8. Press [Enter] .

S TEP - BY -S TEP Use a function in a worksheet.

Steps

Practice Data

1. Select the worksheet in which you want to enter the function. The worksheet appears. 2. Select the cell in which you want to enter the formula. The cell is selected. 3. Type = , followed by the function name and an open parenthesis ( ( ). An equal sign ( = ) and the function name appear in the cell and on the formula bar, and a function tooltip appears. containing the data you want to use in the function. The worksheet name appears on the formula bar, followed by an exclamation point (!), and the specified worksheet appears. 4. Select the first worksheet

Click the Qtr 1 tab, if necessary

Click cell C3

Type =sum(

Click the January tab

OFFICEPRO, Inc.

Page 27

Made with FlippingBook Annual report