Explanation

Explanation

$ sign is used to create an absolute cell reference in MS Excel.

In Excel, an absolute reference is a cell reference in which the column and row coordinates stay constant while copying a formula from one cell to the other.

A dollar symbol ($) is used before the coordinates to correct them.

For instance, $D$2 is an absolute reference to cell D2

Explanation

• A worksheet is an electronic spreadsheet that lets users to Calculate, Enter & Analyze data.
  

  A spreadsheet is a computer application for computation, organization, analysis and storage of data in tabular form.

  
  

Explanation

The cell is the basic structural, functional, and biological unit of all known organisms.

Explanation

MS Excel (Microsoft Excel) is a popular spreadsheet software program used for data analysis, calculation, and visualization.

It allows users to create and edit spreadsheets, charts, and graphs.

It is widely used in various fields such as business, finance, and education.

MS Excel is a part of the Microsoft Office suite and is used for:

• Data entry and management
• Calculations and formulas
• Chart and graph creation
• Data analysis and visualization
• Budgeting and forecasting

In MS Excel you can enter 3 types of Data in a cell,labels, values and formulas.

Explanation

The Name Box normally displays the address of the "active cell" on the worksheet.

Data or Formula of the Current Active Cell can be viewed inside the Cell Contents box of the Excel Formula bar

Explanation

In MS Excel, "character" is not a valid data type.

There are Three types of data in cells: labels, values, and formulas.

1. Labels (text) are descriptive pieces of information, such as names, months, or other identifying statistics, and they usually include alphabetic characters.
2. Values (numbers) are generally raw numbers or dates.
3.  Formulas are instructions for Excel to perform calculations.

Explanation

The MOD function in Excel is used to find the remainder after the division of one number (dividend) by another (divisor).

The syntax for the MOD function in Microsoft Excel is: MOD( number, divisor )

***

Explanation

• The formula bar displays the content of the active cell in MS Excel.
  • The formula bar can be used to edit the content of any cell and can be expanded to show multiple lines for the same formula.

Additional Information 

• The name box in the worksheet displays the address of the selected cell.
• The title bar displays the title of the window and It includes the close, minimize, and maximize buttons.
• An active cell refers to a cell in an Excel spreadsheet that is currently selected by clicking the mouse pointer or keyboard keys.

Explanation

 Columns are denoted and identified by a unique alphabetical header letter,

which is located at the top of the worksheet.

*************

VU  FIA SUB INSPECTOR  PAPER 30-1-2021