Computer Science, asked by joshutsiena, 1 day ago

Apply the names to cells and cell ranges and use them in a formula, perform the following activities.​

Answers

Answered by icthakurabhi
0

Answer:

1 . Select the cell or cell range that you want to name. ...

2 . On the Formulas tab, click Define Name in the Defined Names group. ...

3 . In the Name text box, type up to a 255-character name for the range. ...

4 . Click OK.

Explanation:

Please make my answer Brainliest

Answered by mukeshmasih04
0

Explanation:

Name a cell

Select a cell.

In the Name Box, type a name.

Press Enter.

Define names from a selected range

Select the range you want to name, including the row or column labels.

Select Formulas > Create from Selection.

In the Create Names from Selection dialog box, designate the location that contains the labels by selecting the Top row,Left column, Bottom row, or Right column check box.

Select OK.

Excel names the cells based on the labels in the range you designated.

Use names in formulas

Select a cell and enter a formula.

Place the cursor where you want to use the name in that formula.

Type the first letter of the name, and select the name from the list that appears.

Or, select Formulas > Use in Formula and select the name you want to use.

Press Enter.

Manage names in your workbook with Name Manager

On the Ribbon, go to Formulas > Defined Names > Name Manager. You can then create, edit, delete, and find all the names used in the workbook.

mark brainlist answers

Similar questions