|
Creating a Worksheet and
an Embedded Chart
|
Key Concepts
|
- Rotate
text in a cell
- Create
a series of month names
- Use
the Format Painter to format cells
- Copy,
paste, insert and delete cells
- Format
numbers using format symbols
- Freeze
and unfreeze titles
- Show
and format the system date
|
- Use
absolute cell references in a formula
- Use
the IF function to perform a logical test
- Show
and dock toolbars
- Create
a 3-D pie chart on a separate chart sheet
- Color
and rearrange worksheet tabs
- Change
the worksheet view
- Goal
seek to answer "what-if" questions
|
What to do
1.
Complete SAM training and test for Excel 3
2.
Page EX 146 to 208 - Aquatics Wear: this assignment is not submitted or
graded
3.
Page EX 222 - #2 Vashons IT Hardware
Upload the saved files as Vashons IT Hardware.xls
|
Points
|
Requirements
|
|
4
|
Worksheet formatted similar to
page EX 147
(bold all cells, add drop shadow, add column headings,
assumptions)
|
|
4
|
Correct use of formulas
Autosum, Absolute Cell references,
|
|
2
|
Correct use if IF function
in calculating Bonus
|
|
4
|
Chart inserted as new
worksheet formatted similar to page EX 147
(leader lines, colored labels)
|
|
4
|
Correct
"What-If" Analysis
|
|
2
|
Listed Assumptions values
in separate area of worksheet
|
|
20
|
Total
possible for uploading Vashons
IT Hardware.xls
|
Submit
to the Digital Drop Box
Downloads
- Student files from publisher
Return
to Excel Assignments
|