This question "** The cell reference for a range of cells that starts in cell B1 and goes over to column E and down to row 10 is a) B1:E9 b) B1-E9 c) B1:E10 d) B1-E10**" is asked from MS Excel topic and more specifically, it is from Naming Cells and Ranges.

The question was asked in Computer Assistant Examination conducted by Public Service Commission in 2074 for Nikshep Tatha Karja Surakshyan Kosh. It aims to test candidate's general knowledge on cell references in Excel.

**Show Your Love! Share this page!**

Question:

*The cell reference for a range of cells that starts in cell B1 and goes over to column E and down to row 10 is*

*The cell reference for a range of cells that starts in cell B1 and goes over to column E and down to row 10 is*

Options:

#### Correct Answer

Explanation:

*The cell reference for a range of cells that starts in cell B1 and goes over to column E and down to row 10 is*

*The cell reference for a range of cells that starts in cell B1 and goes over to column E and down to row 10 is*

Excel worksheet is divided into rows and columns and each intersection of row and column is known as a cell. A cell is the building block of a worksheet and it contains data to be stored or processed.

To identify a cell in a worksheet, it is named according to which column and row it lies. For example a cell in third column and fifth row is C5. Similarly the name of a cell which is in fourth column and sixth row is D6.

A group of cells selected for specific action is called a range. A range is denoted with the first cell address and last cell address of range separated by a column. So, a range name D3:F6 indicates all the cells between D3 and F7 (i.e. D3, D4, D5, D6, E3, E4, E5, E6,F3, F4, F5, F6).

A cell in column E and 10 row is E10. Therefore, a range that starts from B1 and goes over up to E10 is B1:E10.

**Other Explained Questions******

[****bottomad]

[…] to calculate the average of three cells A1, A2 and A3, you can use the following formula The cell reference for a range of cells that starts in cell B1 and goes over to column E and down to… The main function of the ALU is to Which of the following have low failure rate? […]