Griffin | Computer Apps II
 
Resume Table of Contents  

Computer Apps II
Excel - Project 6

Project 6
Creating Templates and Working with
Multiple Worksheets and Workbooks

 
1. Excel Project 6 Assignment
Duration: 2 Periods
  Read the Case Perspective, Objectives, Intro, and Project Preview. p. 377 - 452
 

Chapter 6 Power Point

Objectives:

  • Create and use a template
  • Use the ROUND function
  • Utilize custom format codes
  • Define, apply, and remove a style
  • Use the Research task pane to find a synonym
  • Add a worksheet to a workbook
  • Create formulas that use 3-D references
  • Draw a 3-D Cylinder chart
  • Use WordArt to create a title and create and modify lines and objects
  • Assign comments to cells
  • Use the Research task pane to research a topic
  • Add a header or footer, change margins, and insert a page break
  • Use the Find and Replace commands
  • Search for files and create and use a workspace file
  • Consolidate data by linking workbooks
2.

Complete Project 6. Type your name and date in the left header. Print the worksheets and 3-D chart shown on page 379 and hand into the instructor in the order shown.

sm

Project 6 Awesome Images Consolidated Worksheet

Awesome Images Profit Potential.xls: Company
Awesome Images Profit Potential.xls: Company
(show formulas)
Awesome Images Profit Potential.xls: Cleveland
Awesome Images Profit Potential.xls: Lexington
Awesome Images Profit Potential.xls: San Diego
Project 6 Awesome Images 3-D Cylinder Chart
(Note: Do not use Word Art on the chart!)

Grading:
1. Awesome Images Consolidated Worksheet  ___ 5 points
2. Awesome Images 3-D Cylinder Chart  ___ 5 points
Total  
 ___ 10 points
p.378 - 452
3. Excel AYK 1 Assignment
Duration: 1 Period
p. 455 - 456
 

Complete the Apply Your Knowledge 1 Assignment. Type your name and date in the left header. Print 4 pages: Quarter 1 and Quarter Totals and the formulas for both. Hand in to the instructor in the order shown below.

Note 1: Verify your student data disk shows Hours Worked for Employee ST4234 to be 603.00.

Employee Rate of Pay Hours Worked Gross Pay
ST4234
17.75
603.00
10,703.25

Note 2: Make sure to write 5 synonyms and 1 antonym as noted in the book.

Apply 6-1 Quarter 1 Total
Apply 6-1 Quarter 1 Total (Show Formulas)
Apply 6-1 Payroll Total
Apply 6-1 Payroll Total (Show Formulas)

Grading:
1. Apply 6-1 Quarter 1 Total  ___ 5 points
2. Apply 6-1 Payroll Total  ___ 5 points
Total  
 ___ 10 points
 
4.

Excel ITL 1 Assignment
Duration: 1 Period

p. 456 - 458
 

Complete the In The Lab 1 Assignment. Type your name and date in the left header. Print and hand into the instructor in the order shown below.

Note 1: Make sure to write the synonyms as noted in the book.

Lab 6-1 JoggerWear Template
Lab 6-1 JoggerWear Note

Grading:
1. Lab 6-1 JoggerWear Template  ___ 5 points
2. Lab 6-1 JoggerWear Note  ___ 5 points
Total  
 ___ 10 points
5.

Excel ITL 2 Assignment
Duration: 1 Period

p.
 

Complete the In The Lab 2 Assignment. Type your name and date in the left header. Print and hand into the instructor.

Lab 6-2

Grading:
1. Lab 6-2  ___ 10 points
Total  
 ___ 10 points
6.

Excel ITL 3 Assignment
Duration: 1 Period

p.
 

Complete the In The Lab 3 Assignment. Type your name and file name in the lower left footer. Print and hand into the instructor.

Lab 6-1 Stock Quotes

Grading:
1. Lab 6-1 Stock Quotes  ___ 10 points
2.    ___ 10 points
Total  
 ___ 10 points
7.

Excel Cases and Places Assignment
Duration: 2 Periods

 
 

 

Grading:
1.    ___ 10 points
Total  
 ___ 20 points
 
8. CH6 Quiz Optional – Complete the Online Practice Test  

top