# Excel Exam Spring 2004 by VISAKH

VIEWS: 29 PAGES: 2

• pg 1
```									                                               Name:___________________

Excel Exam Spring 2004
Instructions:  This exam is closed book, closed notes, closed neighbor, open
mind. Feel free to use the built in Microsoft help, but do not use the internet (web
can use to do this exam and save some typing is available at
http://employees.oneonta.edu/allisodl/csci100/excel7.xls, and you may access

1. (50 Points) Create an Excel worksheet as shown below comparing payments
for the loans shown. Format your worksheet as shown in the table below.
1
A Comparison of Four Loans
Panasonic SC-
Bose Lifestyle 35                   Sony DAV-FC8          Bose Lifestyle 18
ST1
Cost of home
\$2999.99            \$799.99            \$599.99          \$1999.99
theater system
Number of
12                  12               4                  12
payments/year
Number of years
5                      1            2                   3
for loan
Interest rate                     8%                  3%               5%              6.75%
Total number of
payments
Payment
Total amount
paid over life of
loan
Cost of Loan
1

2. (25 Points) Using the data in the table on the next page, create a pie chart on
a new sheet showing the percentage of the US population that is under 21,
the percentage that is between 21 and 39, the percentage that is between 40
and 64, and the percentage that is 65 and over. Your pie chart should be a
pie with 3D visual effect and should have a title “Population by Age Group”. It
should include a legend at the bottom of the pie chart, and should label each
slice with the appropriate percentage. You should rotate the pie chart by 110
degrees so that the slice for under 21 is at the bottom, and adjust the
elevation to 30%. You should pull the under 21 slice out from the other slices.
You should add a footer with the course and section number on the left and
your name on the right, using 8 point Arial font.
3. (25 Points) Using the data in the table on the next page, create a stacked
column chart with a 3D visual effect on a new sheet. Title the chart
“Population by Age and Ethnicity. Label the horizontal axis “Age Group” and
the vertical axis “Population”. Move the legend to the top of the chart, and
turn on just the value axis major gridlines. Rotate the vertical axis label so
that it reads from bottom to top. Change the grid lines so that there is one
every 20,000,000 people. Add a footer with the course number and section

Page 1 4/19/2011
Name:___________________

left justified, the date centered, and your name right justified. Insert an
autoshape of a block arrow pointing down above the 100 and over column,
and add a text box above it with the text “1388 People over 100!!”. Format
the text box to have a white background and black text.
4. Print out the two charts in landscape mode and your loan calculation sheet in
portrait mode, and turn them in stapled together with this test sheet.

US Population, 2000 Census1
Total                            White                           Black                         Hispanic
Male             Female           Male             Female          Male            Female         Male            Female
Total             138,053,563      143,368,343      103,773,194      107,687,432     16,465,185      18,193,005     18,161,795      17,144,023
0-12 years         26,720,639          25,469,655    18,201,190         17,252,608    4,028,366         3,906,414    4,752,031       4,545,629
13-17 years        10,338,557           9,764,961     7,290,732          6,853,759    1,503,810         1,447,106    1,582,813       1,461,786
18-20 years         6,257,235           5,971,666     4,346,172          4,150,696      874,363          882,789     1,102,828           921,799
21-29 years        17,415,354          16,880,535    12,091,158         11,674,909    2,204,875         2,391,378    3,321,670       2,782,917
30-39 years        21,640,465          21,576,587    16,034,998         15,815,281    2,568,064         2,876,899    3,142,526       2,807,533
40-49 years        21,018,608          21,515,659    16,487,535         16,589,086    2,323,320         2,652,289    2,065,243       2,014,077
50-59 years        15,116,453          15,938,332    12,439,196         12,881,926    1,419,327         1,692,771    1,120,401       1,200,567
60-64 years         5,136,627           5,668,820     4,292,670          4,653,172      468,895          594,574       347,409           402,998
65-69 years         4,400,362           5,133,183     3,753,923          4,286,302      374,464          507,322       268,184           331,169
70-79 years         6,947,368           9,325,886     6,103,498          8,074,714      498,891          782,519       341,154           462,838
80-89 years         2,711,398           5,023,787     2,427,073          4,474,840      172,646          371,748       100,944           177,010
90-99 years              340,440        1,058,875          297,721        947,076           26,438        81,695           15,635         34,024
100-109 years              9,513          39,553             6,989         32,512            1,602         5,283             866           1,581
110 and older                544            844               339               551            124            218             91                 95
1
Values don’t quite add up since some people weren’t certain of their gender or ethnicity. Data taken from factfinder.census.gov.

Page 2 4/19/2011

```
To top