Question

how will you refer all cells in columns b through e?​

Answer 1

Answer:

How to create a reference in Excel

Click the cell in which you want to enter the formula.

Type the equal sign (=).

Do one of the following: Type the reference directly in the cell or in the formula bar, or. Click the cell you want to refer to.

Type the rest of the formula and press the Enter key to complete it.

Answer 2

Answer:

Create a cell reference to another worksheet

Click the cell in which you want to enter the formula. , type = (equal sign) and the formula you want to use. Click the tab for the worksheet to be referenced. Select the cell or range of cells to be referenced.

Explanation:

Hope that helps you