Question Discussion & Solution

VisiCalc was the first computer spreadsheet program. It was released to the public in 1979, running on an Apple II computer. While most early microprocessor computers had been quickly supported by BASIC and a few games, VisiCalc introduced a new level in application software. It was considered a fourth generation software program.

The MOD function in Excel is used to find remainder after division of one number (dividend) by another (divisor). In mathematics, this operation is called the modulo operation or modulus, hence the name MOD.

Pressing the Esc key while editing a cell aborts the operation and leaves the cell in it's original state.

Financial Functions are used to calculate depreciation, rates of return, future values and loan payment amounts.
A list of Excel Financial Functions in Excel are:
?Investment value functions including
1. FV
2. FVSCHEDULE
3. NPV
4. PV
5. RECEIVED
6. XNPV
?Internal rate of return functions including
1. IRR
2. MIRR
3. XIRR
?Asset depreciation functions including
1. AMORDEGRC
2. AMORLINC
3. DB
4. DDB
5. SLN
6. SYD
7. VDB
?Payment functions including
1. CUMIPMT
2. CUMPRINC
3. IPMT
4. ISPMT
5. PMT
6. PPMT
?Dollar conversion including
1. DOLLARDE
2. DOLLARFR
?Yield functions including
1. YIELD
2. YIELDDISC
3. YIELDMAT
4. ODDFYIELD
5. ODDLYIELD
6. TBILLEO
7. TBILLYIELD
?Price functions including
1. PRICE
2. PRICEDISC
3. PRICEMAT
4. ODDFPRICE
5. ODDLPRICE
6. TBILLPRICE

When we link data maintained in an excel workbook to a word document the document contains a reference to the original source application.