Excel | MCQs

Explanation

To removes a sheet from workbook select the sheet, then choose Edit > Delete Sheet these options available in excel 2003 and earlier version.

In Microsoft Excel 2007 onward Choose Home > Delete > Delete Sheet on the Ribbon.

Explanation

Explanation

There is no option to set page border in Excel.

Explanation

Excel sheet:

Cells: The basic unit of an Excel sheet, where data is entered. 

Rows: Horizontal lines that run across the sheet, numbered sequentially. 

Columns: Vertical lines that run down the sheet, identified by alphabetical letters. 

Workbook: A collection of one or more worksheets within a single Excel file. 

Explanation

To adjust a column width to fit its contents in Excel, you can:

Double-click the boundary to the right of the column heading.

This action automatically resizes the column width to match the longest entry in that column.

This ensuring that all data is visible without manually adjusting the width.

Explanation

Explanation

Explanation

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

Explanation

A valid range reference uses a colon (:) to specify a range from C3 to E5.

Explanation