CIS 110 Excel 6 Assignment

Creating Templates and Working with Multiple Worksheets and Workbooks

 Key Concepts
  •  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 cell 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 of 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

What to do

  1. Complete SAM training and test for Excel 6
  2. Pages EX 378 to 453 - Awesome Images Profit Potential: this assignment is not submitted or graded
    Note: You will need to Download the AWI files to complete the search part of the assignment on page 447.
  1. Pages EX 458 to 460 - #2 Web Salon Quarterly Sales Analysis -
    Download the required template file
    Upload the file as Web Salon Quarterly Sales Analysis.xls

    NOTE:
    There is an error in the instructions in step 3, page 459. The book tells you to change the title in cell A2 but the title is actually in cell A1. See example

Points

 Requirements

5 used formula to sum all worksheets
5 created 4 worksheets
5 worksheet formatted
5 chart added and formatted
20 Total possible for uploading
Web Salon Quarterly Sales Analysis.xls

Submit to the Digital Drop Box

Downloads

Return to Excel Assignments