Microsoft Office Tutorials and References

In Depth Information

EX 230

Excel Chapter 3
What-If Analysis, Charting, and Working with Large Worksheets

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 speciﬁ 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 ﬁ 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”)))