Excel 2007 Assignment Sheet, Tutorial 5—Working with Excel Tables, PivotTables, and Pivot Charts
Follow formatting rules on the General Excel Notes Website. Set all worksheets to be centered horizontally, and ignore any directions related to headers/footers and instead do the following:
File, Sheet | Page # of
| Your Name.
You may want to put the date and/or time in the header, but this is not required.
Additional Instructions
Submit
Excel Tutorial 5— Sessions 5.1, 5.2, & 5.3
(40 points)
Read and complete pages EX 217 – EX 271.
NOTES: Page 270—Prior to printing, set all worksheets to print centered on a landscape page except the last sheet, Art Collection, which should be set to fit on three landscaped pages (set Row 1 to repeat at the top of each of these three pages).
After answering the Quick Check questions on pages EX 232-233, 246, and EX 270, check your answers at the end of the chapter and review the Key Terms on page EX 271 to make sure you have a clear understanding of the concepts covered.
p. 270, Step 4______
(workbook; 6 pages)
Tutorial 5 :
Review Assignment
(15 points)Complete the Practice Review Assignment on page EX 272. When you are done, save the file as directed and print the Q7, Q8, and Q10-15 Artist Summary worksheets of the YI Art Museum workbook.
NOTES: Step 16—After setting the Q7 and Q8 worksheets to print centered on a landscape page and making sure that your Q10-15 Artist Summary worksheet will fit on one portrait page, group these three sheets and print them as one unit (should be 3 pages).
Step 16 ________
(Q7, Q8, & Q10-15)
Tutorial 5:
Case Problem 1
(13 points)
Complete the Apply Case Problem 1 Assignment on pages EX 273 - EX 274. When you are done, save the file as directed and print the Q7 and Q8 worksheets of the YI Zoo Pledges workbook.
NOTES: Step 11—Set each sheet to print centered on one landscape page.
Step 11________(Q7 & Q8)
Tutorial 5:
Case Problem 2Ring.xlsx
(18 points)Complete the Apply Case Problem 2 Assignment on pages EX 274 - EX 275. When you are done, save the file as directed and print the YI Ring Farm workbook.
NOTES: Step 11—Center the chart below the PivotTable data.
Step 12—Set each sheet to print centered on one portrait page.
Step 12________(Q5, Q8, Q10-11,
& Q12)Tutorial 5:
Case Problem 3(14 points)
Complete the Challenge Case Problem 3 on pages EX 275 - EX 276. When you are done, save the file as directed and print the Q9, Q11, and Q12 worksheets of the YI High Desert Bank workbook.
NOTES: Step 12—Set each sheet to print centered on one landscape page.
Step 12 ________(Q9, Q11, & Q12)
EXTRA CREDIT
(up to 10 points)
Complete the Create Case Problem 4 on pages EX 276 - EX 278. When you are done, save the file as directed, and e-mail the YI Bowls Stores workbook to your instructor using YouSendIt.com.
Step 11__________(e-mailed workbook)
