Excel 2007 Assignment Sheet 7, Integration & Cases

Follow formatting rules on the General Excel Notes Website; with the exception of macros, skip any directions related to headers/footers and instead follow our general Excel setup instructions:

Header

Date         |                                               |          Time

Footer

File, Sheet          |          Page # of           |          Your Name

 

 

Printable Sheet

Activity

Additional Instructions

Submit

Additional Case 1

 

Grading.xlsx,
Exam Grades.txt,

Homework Grades.txt,
Quiz Grades.txt, Student List.txt

(10 points)

Complete the Additional Case 1 on pages ADD 1-3. When you are done, save the file as directed and print the YI Grading Sheet workbook at the end of Step 24.

 

 

 

Step 24 ________

(workbook)

 

 

Additional Case 2

 

StarDust.xlsx

 

(15 points)

Complete the Additional Case 2 on pages ADD 4-6. When you are done, save the file as directed and print the YI StarDust Scopes workbook’s Price Point Analysis sheet SHOWING FORMULAS  and print the YI Price Point Analysis.pdf page.

 

Step 22,
formulas ______

(worksheet, 1 page)

 

Pdf page _______

(1 page)

Appendix B


Mzoo.xlsx, Zoo Letter.docx

 

(10 points)

Complete the Appendix B on pages EX B1-B9. Print the YI Metro Zoo Ltr.docx.

 

Page EX B8,
Step 4 _________

(Word document, 2 pages)

Additional Case 3

 

Mustard.xlsm, Product List.xmlMustard Orders.xsd

(15 points)

Complete the Additional Case 3 on pages ADD 7-9. When you are done, save the file as directed and print the YI Mustard Hut workbook’s Order Form sheet SHOWING the information for Jane Reynolds and the macro buttons and print the VBA Code for your macros.

 

Step 23________

(worksheet, 1 page)

 

VBA Code _____

(1 page)

EXTRA CREDIT OPPORTUNITY

On Your Own

Create a workbook for your personal or professional use with at least three sheets. This could be something that your work has wanted you to create or something for your home use (such as a budget, checkbook balancing workbook, or tax file).

(up to 10 points)

 

______________

(Workbook)

Although you are not turning in all sheets of the above assignments, you are expected to
complete
ALL steps (unless otherwise noted above) of each assignment.
Check the online Sample Keys to see a sample of what should be turned in, and
check the online full workbooks to check your work on those sheets that you are not turning in.

 

Home Project 1 Assignment Project 2 Assignment Project 3 Assignment Project 4 Assignment Project 5 Assignment Project 6 Assignment Project 7 Assignment Using Page Setup