Excel 2007 Assignment Sheet, Tutorial 2—Formatting a Workbook

General Excel Notes—Ignore any steps in the book that direct you to place information in the header/footer of your workbooks. Instead, follow formatting rules on the General Excel Notes Website and set all worksheets to be centered horizontally.

Printable Sheet
 

Activity

Additional Instructions
Submit

Excel Tutorial 2 Sessions 2.1 & 2.2



 

 

Background.jpg
ExerComp.xlsx

(40 points)
Read and complete pages EX 57 – EX 100.

NOTES:  After answering the Quick Check questions on pages EX 80 and EX 100, check your answers at the end of the chapter and review the Key Terms on page EX 101 to make sure you have a clear understanding of the concepts covered.
Be prepared to discuss any of these questions or terms in class.

                  At step 3 on page 100, print regular version of the Monthly Sales worksheet AND the formulas version of the Yearly Sales worksheet of the YI ExerComp Sales Report workbook for submission with this assignment.

 



 

 

 

p. EX 100,
Step 3+__________

(Monthly Sales +
Yearly Sales, formulas)

Tutorial 2:
Review Assignment

X410.xlsx and Paper.jpg




(15 points)
Complete the Review Assignment Practice on pages EX 102 - EX 104.

NOTES:  Skip Step 4.
Step 12—fourth line should begin “…format to cell D4 that adds…”

When you are done, save the file as directed, and attach the two dated sheets printed as pages 2 and 3 of the workbook, YI  X410 Sales Comparison.xlsx, to this assignment.




 

Step 20__________
(Pages 2 and 3 of  the workbook)

Tutorial 2:
Case Problem 1

Frosti.xlsx

 

 (15 points)

Complete the Case Problem 1 Apply on pages EX 104 - EX 106. When you are done, save the file as directed, and attach the Glomitts page only from YI FrostiWear Sales Report.xlsx  to this assignment.

 



 


Step 14 __________

(Glomitts page)

Tutorial 2:
Case Problem 2

GrillRite.xlsx

 

(15 points)

Complete the Case Problem 2 Create on pages EX 106 - EX 108. When you are done, save the file as directed, and attach the printed Packing Slip sheet from YI GrillRite Packing Slip.xlsx to this assignment.

 



 


Step 22__________

(Packing Slip)

Tutorial 2:
Case Problem 3

Iowa.xlsx

 

(15 points)

Complete the Case Problem 3 Challenge on pages EX 109 - EX 110. When you are done, save the file as directed, and attach the first and last pages only of the Iowa sheet from the YI Iowa Election Results.xlsx workbook to this assignment.

 



 


Step 22__________

(Page 1 & 9)

EXTRA CREDIT
Life.xlsx

(up to 10 points)

Complete the Case Problem 4 Create on pages EX 110 - EX 111. When you are done, save the file as directed, and attach the Meal Planner sheet of YI Life Managers Nutrition Table.xlsx to this assignment.

 

Step 16__________

(Meal Planner)

 

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.