|
Creating a Worksheet and
an Embedded Chart
|
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
Insert an appropriate Clip Art when needed.
1.
Complete
SAM training and test for Excel 4
2.
Page
EX 242 to 294 - E-Money Lenders Loan Payments Calculator:
this assignment is not submitted or graded
3.
Pages
EX 302 to 303 - #3 Internet Bank of Chicago Loan Calculator
Upload the file as
Internet
Bank of Chicago Loan Calculator.xls
|
Points
|
Requirements
|
|
2
|
Worksheet formatted (Autoformat
style is fine)
|
|
2
|
Correct use of range names
|
|
4
|
use of Autosum
|
|
4
|
use of absolute cell
references
|
|
2
|
inserted graphic
|
|
2
|
Bonus
|
|
4
|
calculation errors
|
|
20
|
Total possible for
uploading
Internet Bank of Chicago Loan
Calculator.xls
|
Submit
to the Digital Drop Box
Downloads
- Student files from publisher
Return
to Excel Assignments
|