(See related pages)
|
|
|
Develop separate assumptions and output sections of a worksheet |
|
|
|
(See page(s) MOS XL03S-2-3) Use Insert Function to help write worksheet functions |
|
|
|
(See page(s) MOS XL03E-1-4) Provide data validation for selected worksheet cells |
|
|
|
(See page(s) MOS XL03E-1-14) Define and use names in functions in place of cell references |
|
|
|
(See page(s) MOS XL03S-2-4) Investigate the logical function IF |
|
|
|
(See page(s) MOS XL03E-1-9) Write the index function VLOOKUP |
|
|
|
(See page(s) MOS XL03S-2-4) Write financial functions including PV, PMT, PPMT, and IPMT |
|
|
|
(See page(s) MOS XL03S-2-4) Write and apply the NOW date function |