Ms Excel - Study Mode

[#96] The active cell:
Correct Answer

(D) Only A and B

Explanation

Solution: An active cell is a rectangular box that highlights (a bold border around) the cell in a spreadsheet. An active cell helps identify what cell is being worked with and where data will be entered.

[#97] Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
Correct Answer

(D) Financial

Explanation

Solution: 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

[#98] B7:B9 indicates:
Correct Answer

(B) Cells B7 through B9

Explanation

Solution: B7:B9 indicates a range of cell between Cells B7 through B9.

[#99] The Cancel and Enter buttons appear in the:
Correct Answer

(B) Formula bar

Explanation

Solution: Three buttons Cancel, Enter, and Function Wizard appear in the Formula bar.

[#100] Which of the following methods cannot be used to enter data in a cell
Correct Answer

(C) Pressing the Esc key

Explanation

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