Explanation

PMT, one of the financial functions, calculates the payment for a loan based on constant payments and a constant interest rate.

Explanation

To select an entire column in MS-EXCEL:

• Click the column heading letter.
• Press CTRL + Space Bar key.

Explanation

The Wrap feature allows text to appear on multiple lines within a single Excel cell.

It improves readability without expanding the cell width.

Explanation

• To protect a worksheet, you can lock cells to prevent changes, formatting, or deletion.
• This is done by using the "Protect Sheet" feature in spreadsheet software like Microsoft Excel or Google Sheets.

Explanation

Shift + F2 is the correct answer. 

Comments can be added to cells using Insert > Comment.

Right-click the cell and then click Insert Comment (or press Shift+F2).

Explanation

In MS excel, a range identifies a range by the cells located at diagonally opposed corners.

 A range is a group of cells in a spreadsheet that have been selected. If the cells are all together in a rectangular or square shape, it is an adjacent range.

AGM 17-12-2022

Explanation

The MS excel worksheet are made up of rows and columns.

In worksheet, intersection of row and column is a rectangle, it is called as cell.

Cells are used to store the numbers, value, text or formula.

Document is not a term of MS excel

Explanation

A bar chart or bar graph is a chart or graph that presents categorical data with rectangular bars with heights or lengths proportional to the values that they represent.

The bars can be plotted vertically or horizontally.

A vertical bar chart is sometimes called a column chart

**** 

RY19012023

Explanation

Explanation

Formulas are equations that perform calculations on values in your sheet.

All formulas begin with an equal sign (=).

You can create a simple formula by using constant and calculation operators.

For example, the formula =5+2*3, multiplies two numbers and then adds a number to the result.