Explanation

In Microsoft Excel 2016, the Print Titles option is available in the Page Layout menu

Explanation

The basic unit of a worksheet in Excel where data is entered is called a cell.

A cell is the intersection of a row and a column in a spreadsheet.

Each cell has a unique name or cell address, which is based on its column and row.

For example, the cell in column "C" and row "3" is cell C3.

Explanation

There is no function in Excel like AVG, at the time of writing,

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

****

ND7-5-2023

Explanation

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

A worksheet consists of rows (horizontal) and columns (vertical) where data is entered into cells at their intersections.

Explanation

Explanation

Explanation

Performs a calculation: The expression "=A1 + A2" performs a calculation by adding the values in cells A1 and A2.

Uses cell references: The formula uses cell references (A1 and A2) to specify the values to be used in the calculation.

Explanation

To select an entire column in MS-EXCEL:

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