Unit 18: Working with Data and Events

October 20, 2014  |  By  | 


Instructional Procedures Directions: Read Sec 34.1 and 34.2. Use the data in the table and recreate in Microsoft Excel. Follow the step-by-step directions below. Afterwards, type and answer questions 1-3 in complete sentences from Sec 34.1 and 34.2 under your table that you have created and formatted. TOP TEN MOST EXPENSIVE AND LEAST EXPENSIVE STATES FOR AUTOMOBILE INSURANCE, 2011 (http://www.iii.org/fact-statistic/auto-insurance) Rank Most expensive states Average expenditure Rank Least expensive states Average expenditure 1 New Jersey $1,183.95 1 Idaho $535.15 2 D.C. 1,138.03 2 South Dakota 540.04 3 Louisiana 1,110.68 3 North Dakota 549.81 4 New York 1,108.64 4 Iowa 552.54 5 Florida 1,090.65 5 Maine 577.38 6 Delaware 1,052.28 6 North Carolina 600.33 7 Rhode Island 1,004.14 7 Wisconsin 601.40 8 Michigan 983.60 8 Nebraska 602.57 9 Connecticut 970.22 9 Wyoming 619.88 10 Maryland 956.17 10 Ohio 619.96 Step 1: Type the name of the table. Merge the cells so the title can go across the top of the table. Step 2: Type in all of the information in the cells as you see in the cells above except for the headings for each column. Step 3: Highlight the entire area you typed in.

More from TIONA HORTON

Page 1 / 2