Excel Case 6 - Blue Mesa Schedule

Excel Case 6 - Blue Mesa Schedule - EXCEL CASE 6: BLUE MESA...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
EXCEL CASE 6: BLUE MESA SCHEDULE GRAND MESA NORTHWEST RESORT: CREATING A TEE TIME SCHEDULE SKILLS Apply cell styles Apply date and comma number formats Change the font color Check spelling in a worksheet Copy a formula with absolute cell references Copy cell contents Edit a formula Fill a range of cells with a series Fill adjacent cells with formulas Merge cells and center their contents Modify row height Modify worksheet names Use absolute references Use relative references CASE SCENARIO Situated on a plateau in northwestern Colorado, the Grand Mesa Northwest Resort is a four- season vacation destination for golfers, skiers, hikers, and rafters. As a marketing intern, you prepare many of the printed materials that the resort provides to its guests. During a recent renovation, Grand Mesa added a links-style golf course called the Blue Mesa, and you need to create a schedule of tee times, including fees for greens and carts. You have already prepared the basic material, and now need to use Excel’s formatting features to make the worksheet more appealing to the guests. STUDENT DATA FILE Excel06_FirstLastName_1.xlsx ( Note: Download your personalized start file from cgoffice2007.course.com) Instructions 1. Open the file Excel06_ FirstLastName _1 and rename the file as Excel06_ FirstLastName _2 . Verify that your name appears in cell B4 of the
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
2 CASEGRADER OFFICE 2007
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 4

Excel Case 6 - Blue Mesa Schedule - EXCEL CASE 6: BLUE MESA...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online