Microsoft Excel mcq questions With Answer | MS Excel || Computer Fundamental

Answer: Option D

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.

Answer: Option D

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

Answer: Option B

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

Answer: Option B

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

Answer: Option C

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