This preview shows page 1. Sign up to view the full content.
Unformatted text preview: 4. Next, we introduce our age categories: a. Click the Sheet2 tab at the bottom b. Rename it "Age Categories" c. Copy the table below into this tab (Cell A1) *or* Just enter it as is: age group Under 25 25 25 to 44 45 45 to 59 60 60 to 74 75 75+ d. Now we are going to use this table to categorize our data by Age Group e. Go back to the Data Tab and in Column I, enter the header "AgeGroups" f. NOW we need to put the proper Age Group Category value for each row of data that we have. Hints: VLOOKUP Function and remember about absolute cell refs ($) 5. Print the first page of the Excel table in landscape format. (Deliverable #2)...
View Full Document
- Fall '08