Datasheet

Sample MOS Scenarios
43
MOS Scenario 2: Add Worksheets and Find Data
Rename the worksheet to March 2005, then add two more sheets and name them March 2004
and March 2003. Rearrange the sheets so they are in chronological order and make each tab
a different color. Copy all of the data from the March 2005 sheet and paste it into both of the
other sheets. Find all occurrences of The French Corner and change them to The French Riviera
on all three sheets. Make sure all column widths are adjusted appropriately.
MOS Scenario 3: Insert, Move, and Delete Cells and Save Files
On the March 2005 sheet, delete row 2 and change the height of the new row 2 to 20 points. On
the March 2004 sheet, insert a cell above C9 so that the value in C9 moves down to C10. Cut the
value in C12 and paste it into C11. Save the file into the My Documents folder inside a new
folder you create called MOS Scenarios. Name the file ChapterOneScenarios.xls. Move to the
March 2005 sheet and save the file as a text (tab-delimited) file in the same location with the
name ChapterOneScenarios.txt.
4002book.fm Page 43 Friday, March 24, 2006 11:36 PM