ABCDEFGHIJKLMNOPQRST
1
How to use this spreadsheet to practice these problems:
2
Copy down the table at the top outlined in a bright green box.
3
 For the deflator sheet, estimate NGDP, RGDP, Deflators, Real Growth, Real Annual Growth, Total Inflation and Annual Inflation.
4
If you get stuck, highlight the cell for the value you are stuck on, and see what arithmetic you need to do to solve the problem.
5
You can see the arithmetic in the bar at just above the spreadsheet next to "fx". If you place the cursor in that cell, it will highlight the cells you are interested in looking at.
6
For the CPI sheet, estimate the expenditures, and CPI Index values.
7
You can change the years, prices, quantities, for each of the sheets. Try to change these values and calculate the answers on your own.
8
Almost everything in the green boxes can be changed, and the entire spreadsheet will update for you.
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
87
88
89
90
91
92
93
94
95
96
97
98
99
100