Cell and Range Names 100%

What is the first step when creating a 3-D range name? Open the New Range window, and click 3-D. Press the Shift key while selecting the new sheet . Open the Name Manager, and click New. Click a cell to insert the cell reference.

c

What are two examples of information displayed in the Name Manager? all range names in the workbook and the cell references to which the range names refer the cell references to which the range names refer and all function names available in the workbook all function names available in the workbook and all formulas used in the workbook all formulas used in the workbook and all range names in the workbook

a

Complete each sentence to describe how to add range names to existing formulas. Select the cells containing formulas with cell references that should be changed to names. Click the ✔ FormulasHomeView tab. In the Range NamesFormulas✔ Defined Names group, click the Define Names drop-down arrow. Click Existing Names✔ Apply NamesFormat Names . Use the dialog box to select the names.

formulas defined names apply names

Complete each sentence to describe how to work with range names. A range name should be entered in the title box in the status barHome tab on the Ribbon✔ name box in the formula bar . To move the selection to a specific range by its name, click the ✔ name box drop-down arrowNames view on the status barrange name in the scroll box . Then, click the ✔ range nameformula boxstatus bar

name in the box formula name box drop down arrow range name