*** 10-point assignment due by Thursday, January 26, 2011 at 9:00pm.
Start with the file: T:\teach\classes\for112\all-nps-visit-9698.xls
1. (2 pts) Rename the fiscal9598 sheet:
visits9698
Insert a new worksheet in the workbook and rename it:
NB
Set the order of the
worksheets so NB is the second sheet.
2. (2 pts) Filter the data of visits9698 to
display only the rows of Type: NB
[National Battlefield]
Copy all these filtered NB data rows with the Row 3 column headers to your
NB sheet.
3. (1 pt) Format all the data columns in the NB sheet to be just wide enough for the column data. (Don't just eyeball things!! Do it the savvy way.)
4. (1 pt) In visits9698, first TURN OFF the data filter. Then use Find-Replace to change all occurrences of NMem to: National Memorial
5. (1 pt) In visits9698, go to cell C352. Use the AutoSum icon to help you total up the visits for 1996. Only include rows 4 through 346. Copy your formula across to the other years.
6. (2 pts) In NB,
use the following text in F1 as the header for the formula you are about to
write: % of Total 1998 NPS Visits (Format
like the other column headers and then add word wrap)
The formula in F2 will divide E2 by the value in E352 on visits9698.
Copy your formula down the column and format the results as a percentage
with enough decimal places to not display any results as zero.
7. (1 pt) You'll find a comment in one of the cells in the first 20 rows of visits9698. Follow the comment instructions.
8. Save your modified spreadsheet as your_onid_username-hw3.xls to your ONID space and attach it to an email you send to the instructor. For the e-mail subject line, please use FOR112 HW3.
