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