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

The Excel feature that allows you to freeze rows and columns so they remain visible while scrolling is Freeze Panes.

This feature enhances navigation by keeping important headings in view.

Explanation

Rehearse the presentation

1. Select Slide Show > Rehearse Timings.

2. Select Next, click the mouse, or press the Right Arrow key to go to the next slide.

3. The time for the current slide is shown to the right of the Pause icon. The time to the right of that is the time for the whole presentation.

4. Select Pause to pause the recording. Select Resume Recording to resume.

5. Select Yes to save the slide timings, or No to discard them.

   You can also press Esc to stop the recording and exit the presentation.

   ***

   ND18-1-2023

Explanation

• Another name for a cell address is cell reference.
• It identifies a specific cell in a spreadsheet by its column letter and row number, such as A1 or B2.

Explanation

In Excel we can Find and Replace within the sheet or workbook.

Explanation

Use a Custom list to sort or fill in a user-defined order. Excel provides day-of-the-week and month-of-the year built-in lists, but we can also create your own custom list.

Explanation

There is no option to set page border in Excel.

Explanation

 main document can merge with data source in Excel.

In mail merge operation, Word is usually Client

Explanation

All important questions about " MS EXCEL"

Microsoft Excel is a spreadsheet application launched in 1985 by the Microsoft Corporation.

MS-Excel uses the _____ function when creating a data table.

spreadsheet

****

Which of the following functions in Microsoft Excel is used to count items in a cell range?

Count

***

In MS Excel, which function automatically total a column or row of values?

SUM

***

MS Excel's function arguments are always written in----------?

Parenthesis

***

In MS Excel, which function automatically totals a column or row of values?

SUM

****

Columns in MS Excel are called?

Fields

***

Constant value in excel also called?

Number

***

Ctrl +D in MS Excel?

Fill down in the selection

***

Ctrl+R is used in Excel too?

Fill the selection with active cells to the right

***

MOD () function is used in MS Excel to get

Remainder

****

ND30-4-2023

Explanation

The default value for any series is 1 in Excel.