Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

Excel Exam Spring 2004

VIEWS: 29 PAGES: 2

									                                               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
search, IM, etc) to get answers to your questions. An initial spreadsheet that you
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
the web only to download this spreadsheet.

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
 Price data from BestBuy, 3/14/04

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