 ## What is a cell reference?

A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate.

In one or several formulas, you can use a cell reference to refer to: …

Data on other worksheets in the same workbook..

## How can you remove borders applied in cells?

On the Home tab, in the Font group, click the arrow next to Borders Button, and then click No Border Button. Click Home > the Borders arrow > Erase Border, and then select the cells with the border you want to erase.

## What is active cell class 9 it?

Answer: An active cell is a cell with heavy black color boundary. More Resources for CBSE Class 9.

## What is MS Excel Class 9?

MS Excel 2010 is a spreadsheet program that contains rows, columns, charts, graphs, mathematical functions and formatting tools. It is used for a number of reasons: Data of large data set can be compiled easily. Due to several inbuilt functions calculations becomes easier.

## What is an example of cell address?

A cell reference or cell address is a combination of a column letter and a row number that identifies a cell on a worksheet. For example, A1 refers to the cell at the intersection of column A and row 1; B2 refers to the second cell in column B, and so on.

## What is difference between cell and cell address?

Ø Cell: In Excel the intersection of a column and a row is called as a cell . … The cell address consists of the column letter and row number. For example the first cell is in first column and first row. First column name is A and first row number is 1.

## Which is not a function in MS Excel?

The NOT function is a built-in function in Excel that is categorized as a Logical Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the NOT function can be entered as part of a formula in a cell of a worksheet. logical_valueAn expression that either evaluates to TRUE or FALSE.

## What is cell and active cell in MS Excel?

The active cell is also referred to as a cell pointer or selected cell. An active cell refers to a cell in an Excel spreadsheet that is currently selected by clicking the mouse pointer or keyboard keys. Remember only one cell can be an active cell at a time. An active cell is bounded by a heavy border around it.

## What is relative cell reference?

By default, a cell reference is a relative reference, which means that the reference is relative to the location of the cell. If, for example, you refer to cell A2 from cell C2, you are actually referring to a cell that is two columns to the left (C minus A)—in the same row (2).

## What are cell ranges?

A cell range in an Excel file is a collection of selected cells. This range is usually symmetrical (square), but can exist of separate cells just the same. A cell range can be referred to in a formula as well. … Eventually separate cells can be added to this selection, then the range is called an irregular cell range.

## Which is an example of a formula?

A formula is an expression which calculates the value of a cell. … For example, cell A3 below contains a formula which adds the value of cell A2 to the value of cell A1. For example, cell A3 below contains the SUM function which calculates the sum of the range A1:A2.

## What is the use of fill handle Class 9?

In Microsoft Excel, a fill handle is a feature to extend (and fill) a series of numbers, dates, or even text to a desired number of cells. In the active cell of the spreadsheet, the fill handle is a small black box at the bottom right corner, as shown in the image.

## What is a cell?

Cells are the basic building blocks of all living things. The human body is composed of trillions of cells. They provide structure for the body, take in nutrients from food, convert those nutrients into energy, and carry out specialized functions. … Cells have many parts, each with a different function.

## What is pivoting in Excel?

A Pivot Table is used to summarise, sort, reorganise, group, count, total or average data stored in a table. It allows us to transform columns into rows and rows into columns. It allows grouping by any field (column), and using advanced calculations on them.

## What is an active cell cell?

The active cell is the selected cell in which data is entered when you begin typing. Only one cell is active at a time. The active cell is the cell surrounded by a black border.

## What is current cell?

In a spreadsheet application, the current cell is the active cell, the cell that you are manipulating at the moment.

## What is the use of active cell?

Alternatively referred to as a cell pointer, current cell, or selected cell, an active cell is a rectangular box that highlights the cell in a spreadsheet. An active cell helps identify what cell is being worked with and where data will be entered.