|
The
only Assignment for Chapter 5 this semseter is to complete the SAM
training and test.
Creating
a Worksheet and an Embedded Chart
NOTE
1
There are several errors in the first printing of the Excel text.
Get the corrected text for Chapter
5 pages 338 - 342 HERE.
View the chapter
notes listing the changes.
NOTE
2
You must use Excel 2003 in order to complete this
assignment.
|
Key
Concepts
|
- Control
the color and thickness of outlines and borders
- Assign
a name to a cell and refer to the cell in a formula using the
assigned name
- Determine
the monthly payment of a loan using the financial function PMT
- Use
the financial functions PV (present value) and FV (future value)
- Create
a data table to analyze data in a worksheet
- Add
a pointer to a data table
|
- Create
an amortization schedule
- Analyze
worksheet data by changing values
- Add
a hyperlink to a worksheet element
- Use
names and the Set Print Area command to print sections of a
worksheet
- Set
print options
- Protect
and unprotect cells in a worksheet
- Use
the formula checking features of Excel
- Hide
and unhide cell grid lines, rows, columns, sheets, and workbooks
|
What
to do
1.
Complete
SAM training and test for Excel 5
You
do not need to submit any work from the Excel Lab Book for Chapter 5
Return
to Excel Assignments
|