Excel 2007 Assignment Sheet, Tutorial 4—Working with Charts and Graphics

 

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 Webpage and set all worksheets to be centered horizontally. For this project, the Header/Footer information has been inserted for you except you will need to type your name in the right-hand side of the footer, AND you will need to add Header/Footers to match the existing information in any sheets you create.

 

Activity

Additional Instructions
Submit

Excel Tutorial 4, Sessions 4.1 & 4.2

 

 

 

 

 


Fund.xlsx

(35 points)
Read and complete pages EX 161 – EX 206.

NOTES:  Page 171, Step 2—If the chart title goes to two lines when you press Enter after updating the title; press backspace to delete this extra line.
Page 187, Step 6b—When resizing the chart, hold the Alt key as you drag the chart edge to “lock” it into the column or row borders. Reset the column width of Column J to .1 so your sheet will still center on the page. This will be demonstrated in class.
Page 193, Step 4a—Before clicking outside the chart, try changing two of the lines to another “style” and/or color to make them easier to tell apart when printed on a black-and-white printer. This will be demonstrated in class.

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



 
 
 

 

 

 

 

p. 205, Step 5______
(workbook)

Tutorial 4 :
Review Assignment

 

Crockett.xlsx


(20 points)

 Complete the Practice Review Assignment on pages EX 207 - EX 208. When you are done, save the file as directed and print part of the YI Crockett Family Portfolio workbook as directed below.

NOTES:  Be sure to carefully read and follow the Hints.
Step 18—After making sure that your first three worksheets will all fit on one page each, choose to print pages 2-3 only of the entire workbook (in the print settings). This was demonstrated in class during Week 2.

 

 

 

Step 18 ________

(Second and third sheets of the workbook)

Tutorial 4:
Case Problem 1



 

Kenai.xlsx

(10 points)

 Complete the Apply Case Problem 1 Assignment on pages EX 208 - EX 209. When you are done, save the file as directed and print part of the YI Kenai Fjords National Park.xlsx workbook as directed below.

NOTES: Step 15—After adding the header/footer information to the sheets you created, choose to print pages 2-3 only of the entire workbook (in the print settings). This was demonstrated in class during Week 2.

 

 

Step 15________

(Second and third sheets of the workbook)

Tutorial 4:
Case Problem 2

Tornado.xlsx  & Cloud.jpg

 (10 points)

Complete the Apply Case Problem 2 Assignment on pages EX 209 - EX 211. When you are done, save the file as directed and print the chart sheet of the YI Tornado Sightings.xlsx workbook.

 



Step 14________

(chart sheet)

Tutorial 4:
Case Problem 3

Mitchell.xlsx

(10 points)

Complete the Challenge Case Problem 3 on pages EX 211 - EX 212. When you are done, save the file as directed and print the chart sheet of the YI Mitchell Oil.xlsx workbook.

 




Step 12 ________

(chart sheet)

Tutorial 4:
Case Problem 4

Basketball.xlsx

(15 points)

Complete the Create Case Problem 4 on pages EX 212 - EX 213. When you are done, save the file as directed, and print pages 2-3 of the YI Basketball Report.xlsx workbook.



Step 7___________

(2nd & 3rd sheets)

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.