What-If Analysis, Charting, And Working With Large Worksheets Page 70
ADVERTISEMENT
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87EX 206
Excel Chapter 3
What-If Analysis, Charting, and Working with Large Worksheets
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
Start Excel. You will use nested IF functions to determine values for sets of data.
Instructions Part 1:
1. Using the Insert Function dialog box, enter the following IF function in cell B1:
IF(A1=“TX”, “Central”, “Time Zone Error”)
2. Select cell B1, select the text “Time Zone Error” in the Formula Bar, click the Logical button
(Formulas tab | Function Library group), click IF, and enter the following IF function:
IF(A1=“OR”, “Pacifi c”, “Time Zone Error”)
3. Select cell B1, select “Time Zone Error” in the Formula Bar, click Logical button (Formulas tab |
Function Library group), click IF, and enter the following IF function:
IF(A1=“VA”, “Eastern”, “Time Zone Error”)
4. Verify that the formula in cell B1 appears as follows:
=IF(A1=“TX”,“Central”, IF(A1=“OR”,“Pacifi c”, IF(A1=“VA”,“Eastern”,“Time Zone Error”)))
5. Use the fi ll handle to copy the nested IF function down through cell B6. Enter the following
data in the cells in the range A1:A6 and then write down the results that display in cells B1 through
B6 for each set. Set 1: A1 = TX; A2 = NY; A3 = OR; A4 = MI; A5 = TX; A6 = VA. Set 2: A1= WI;
A2 = OR; A3 = IL; A4 = VA; A5 = NJ; A6 = TX.
Set 1 Results: ____________________________________________________________________________
Set 2 Results: ____________________________________________________________________________
6. Save the workbook using the fi le name, Extend 3-1 Create Series Complete Part 1, and submit the
workbook as specifi ed by your instructor.
Instructions Part 2:
Start Excel. Open the workbook Extend 3-1 Create Series. See the inside back
cover of this book for instructions for downloading the Data Files for Students, or see your instructor
for information on accessing the fi les required in this book.
Perform the following tasks:
1. Use the fi ll handle on one column at a time to propagate the twelve series through row 14, as
shown in Figure 3–85. For example, in column A, select cell A2 and drag the fi ll handle down to
ctrl
cell A14. In column C, hold down the
key to repeat Saturday through cell C14. In column
D, select the range D2:D3 and drag the fi ll handle down to cell D14. Likewise, in columns G
through L, select the two adjacent cells in rows 2 and 3 before dragging the fi ll handle down to the
corresponding cell in row 14.
ctrl
2. Select cell D19. While holding down the
key, one at a time drag the fi ll handle three cells
to the right, to the left, up, and down to generate four series of numbers beginning with zero and
incremented by one.
3. Select cell H19. Point to the cell border so that the mouse pointer changes to a plus sign with four
arrows. Drag the mouse pointer down to cell H21 to move the contents of cell H19 to cell H21.
4. Select cell H21. Point to the cell border so that the mouse pointer changes to a plus sign with four
ctrl
arrows. While holding down the
key, drag the mouse pointer to cell K21 to copy the contents
of cell H21 to cell K21.
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education