What-If Analysis, Charting, And Working With Large Worksheets
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
87Microsoft Excel 2010
3
What-If Analysis,
Charting, and Working
with Large Worksheets
Objectives
You will have mastered the material in this chapter when you can:
•
Rotate text in a cell
•
Create Sparkline charts
•
Create a series of month names
•
Use the Format Painter button to
format cells
•
Copy, paste, insert, and delete cells
•
Create a 3-D Pie chart on a separate
•
Format numbers using format symbols
chart sheet
•
Freeze and unfreeze rows and
•
Rearrange worksheet tabs
columns
•
Change the worksheet view
•
Show and format the system date
•
Answer what-if questions
•
Use absolute and mixed cell
references in a formula
•
Goal seek to answer what-if
questions
•
Use the IF function to perform a
logical test
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education