CSCI 100 Fall 2014 Excel Exam

1. Download the file http://employees.oneonta.edu/allisodl/CSCI100/excel14b.xlsx and save it to your P: drive. Open the file in Excel.

2. (18 points) Go to Sheet 1. Insert two rows between row 1 and row 2. Merge and center cells A1:E1. Add the text “Which Computer to Buy?” in the merged cells using Verdana 18 point font. In cell B3 add the text “Prepared By:” using Copperplate Gothic Light 12 point font. In Cell E3 add your name in Times New Roman 14 point font. In cells B4:E4 add the text “Alienware”, “Northwest”, “Lenovo”, “Origin PC”, using Lucida Handwriting Font, 14 point. Format cells B5:E5 and B10:E12 using currency format with two digits after the decimal place, a leading dollar sign, and with negative numbers shown with a minus sign. Format cells B6:E7 and B9:E9 using the General format, and cells B8:E8 as percentages with two decimal digits. Adjust all columns so that they are the minimal width needed to display their data.

3. (32 points) Calculate the values for cells B9:E12 and put them in the table. Print the spreadsheet out in portrait mode showing the values, and in landscape mode showing the formulas.

4. (50 points) Create a clustered column chart using the data in Sheet 2 showing the number of both sexes with a high school degree, a bachelor’s degree, a master’s degree, and a Ph.D. You should use the age ranges 18-24, 25-34, 35-44, 45-54, 55-64, 65-74, and over 74. You should put your chart on a new sheet labeled Degrees by Age. Add a chart title as a centered overlay with the text “Degrees by Age”. Use 32 point Elephant font for the title. Move the legend to the right side of the chart. Label the horizontal axis “Age”, and the vertical axis “Number of Degrees”, using Arial 18 point in both cases. Add a footer with the course and section number on the left, your name in the middle, and the date on the right, and print the chart in landscape orientation.

5. Staple both sheets to the test, make sure your name is on every page, and turn in your test answers.