|
Creating a Worksheet
and an Embedded Chart
| Key
Concepts |
- Start and Quit Excel
- Describe the Excel
Worksheet
- Enter text and numbers
- Use the AutoSum button
to sum a range
- Use the fill handle to
copy a range of cells
- Format a worksheet
|
- Create a 3-D Clustered
column chart
- Save a workbook and
print the worksheet
- Open a workbook
- Use AutoCalculate area
to determine statistics
- Correct errors on a
worksheet
- Use the Excel help
system
|
What to do
- Complete SAM training and test
for Excel 1
- Page EX 1 to 55 - Extreme Blading:
this assignment is not submitted or graded
- Page EX 64 - Case 3 - Magic
Theater Weekly Ticket Sales -
Upload the saved file as Magic
Theater Weekly Ticket Sales.xls
|
Points
|
Requirements
|
| 5 |
Logical layout used in worksheet |
| 5 |
Correct use of formulas |
| 2 |
Merge and center worksheet
titles |
| 3 |
Worksheet table formatted
(Autoformat style is fine) |
| 2 |
Inserted Clustered Bar Chart |
| 3 |
Chart inserted into worksheet
with x-axis labels and legend |
| 20 |
Total possible for uploading -
Magic Theater Weekly Ticket Sales.xls |
Drop
Box - Upload
Your Assignments to the Digital Drop Box
Downloads
- Student files from publisher
Return
to Excel Assignments
|