Microsoft Office Tutorials and References
In Depth Information
Extend Your Knowledge
Apply Your Knowledge continued
Perform the following tasks:
1. Enter a formula in cell C7 that multiplies cell C2 times the sum of cells C3 through C6. Write the
formula so that when you copy it to cells D7 and E7, cell C2 remains absolute. Verify your formula
by checking it with the values found in cells C7, D7, and E7 in Figure 3–82.
2. Enter a formula in cell F3 that multiplies cell B3 times the sum of cells C3 through E3. Write the
formula so that when you copy the formula to cells F4, F5, and F6, cell B3 remains absolute. Verify
your formula by checking it with the values found in cells F3, F4, F5, and F6 in Figure 3–82.
3. Enter a formula in cell C8 that multiplies cell C2 times the sum of cells C3 through C6. Write the
formula so that when you copy the formula to cells D8 and E8, Excel adjusts all the cell references
according to the destination cells. Verify your formula by checking it with the values found in
cells C8, D8, and E8 in Figure 3–82.
4. Enter a formula in cell G3 that multiplies cell B3 times the sum of cells C3, D3, and E3. Write the
formula so that when you copy the formula to cells G4, G5, and G6, Excel adjusts all the cell
references according
to the destination cells.
Verify your formula by
checking it with the
values found in cells
G3, G4, G5, and G6 in
Figure 3–82.
5. Change the document
properties, as specifi ed
by your instructor.
Change the worksheet
header with your name,
course number, and other
information requested by
your instructor. Save the
workbook using the fi le
name, Apply 3-1 Absolute
Cell References Complete,
and submit the revised
workbook as requested by
your instructor.
Figure 3–82
Extend Your Knowledge
Extend the skills you learned in this chapter and experiment with new skills. You may need to
use Help to complete the assignment.
Nested IF Functions and More About the Fill Handle
Instructions Part 1:
Start Excel. You will use nested IF functions to determine values for sets of data.
Perform the following tasks:
1. Enter the following IF function in cell C1:
=IF(B1=“CA”,“West”, IF(B1=“NJ”,“East”, IF(B1=“IL”,“Midwest”,“State Error”)))
 
 
Search JabSto ::




Custom Search