Activity

Additional Instructions

Submit

Excel Tutorial 11— Sessions 11.1,
11.2, & 11.3

 

Data.xml, Doc.xsd, History.txt, Horizons.accdb, Horizons.htm

(30 points)

Read and complete pages EX 575 – EX 629.

NOTES:  Page 584, after Step 6—PrintPreview to see where this sheet breaks on a landscaped page. Set your print area to only print this one page for this sheet (on mine, the print area was A1:M34).
Page 604, after Step 10—Edit the value in A11 to be DAL.
 

After answering the Quick Check questions on pages EX 591-592, EX 611, and EX 629, check your answers at the end of the chapter and review the Key Terms on page EX 629 to make sure you have a clear understanding of the concepts covered.

p. 627, Step 8_____

 (Workbook, 6 pages)

Tutorial 11:
Review

Index.xlsx, NYA2009.txt, Horizons.accdb, Summary.htm, Info.xml, Info.xsd 

(22 points)

Complete the Review Assignment on pages EX 630-631. When you are done, save the file as directed and print the Summary, Five Day Averages, and Yield and PE Ratios worksheets from the YI Index Report workbook.

NOTES: Step 2—After importing the data, check the PageSetup properties for this sheet to make sure that it will print the first 3 rows at the top of every page when printed.
Step 11— Move and resize the chart to cover the range of C1:I14.

Step 21 ______

(specified sheets,
3 pages)

Tutorial 11:
Case Problem 1

Homes.txt

(10 points)

Complete the Apply Case Problem 1 Assignment on page EX 632. When you are done, save the file as directed and print the Home Summary sheet of the YI Home Sales Analysis workbook.

NOTES: Step 6—Set the Page Setup properties for the Home Listings sheet to repeat the first row at the top of each page when printed.

Step 9_________

(Home Summary sheet)

Tutorial 11:
Case Problem 2

 

Confections.xlsx, Confections.accdb

 

(22 points)

Complete the Apply Case Problem 2 Assignment on pages EX 632-634. When you are done, save the file as directed and print the Customers and Product Orders worksheets from the YI Kate’s Confections workbook.

NOTES: Step 14—Set the Page Setup properties for the Product Orders sheet to repeat the first 5 rows at the top of each page when printed.

Step 16 _______

(Customers and Product Orders sheets, 3 pages)

Tutorial 11:
Case Problem 3

 

Exchange.xlsx, YRate.xml

 

(16 points)

Complete the Challenge Case Problem 3 Assignment on pages EX 634-635. When you are done, save the file as directed and print the Calculator and Japanese Yen Recent History worksheets from the YI Exchange Rate Calculator workbook.

NOTES: Step 15—Set the print area for the Japanese Yen Recent History sheet A1:J45 and print only one page for this sheet.

Step 17 _______

 (specified sheets,
2 pages)

EXTRA CREDIT OPPORTUNITY

Tutorial 11:
Case Problem 4

Green.xlsx, Antiques.accdb

(up to 10 points)

NOTES: Step 6—Repeat the first row of the Orders sheet when printed.

Step 13 _______