CIS 110 Excel 2 Assignment

Creating a Worksheet and an Embedded Chart

 Key Concepts

  •  Enter formulas using keyboard & pointing mode
  •  Recognize smart tags and option buttons
  •  Apply the Average, Max and Min functions
  •  Verify a formula using Range Finder
  •  Format a worksheet using buttons and commands
  •  Add conditional formatting to a range
  •  Change the width of a column and height of a row
  •  Check the spelling of a worksheet
  •  Preview how a printed copy of the worksheet will look
  •  Print a partial or complete worksheet
  •  Display and print the formula version of a worksheet
  •  Use a Web query to get real-time data from a Web site
  •  Rename sheets in a workbook
  •  E-mail the active workbook from within Excel

What to do

  1. Complete SAM training and test for Excel 2
  2. Pages EX 66 to 126 - Blue Chip Stock Club: this assignment is not submitted or graded
  3. Page EX 143 #4 Luvs Steel
    Upload the saved file as Luvs Steel.xls
    Note: The chart must be on a separate worksheet (not embedded). 


    View example chart solution

Points

 Requirements

2

Logical layout used in worksheet

2

Formatted title with background color and large font size

2

Used 2 lines for long labels

5

Correct use of formulas

4

Worksheet formatted (Autoformat style is fine)

3

Chart inserted into a new worksheet with title and data labels

2

Formatted chart title and data labels (color and size)

20

Total possible for uploading - LA Cable.xls

Drop Box to the Digital Drop Box

Downloads - Student files from publisher

Return to Excel Assignments