DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Consolidate
|
|
|
Calculate now
|
|
|
Use in formula
|
|
|
Define name
|
Detailed explanation-1: -Go to the Formulas tab > Define Names group, click Use in Formulas, and then click Paste Names… Or, simply press the F3 key.
Detailed explanation-2: -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.
Detailed explanation-3: -To get a list of all the Named Ranges and pasting it in Formula: F3. To create new name using Name Manager Dialogue Box: Control + F3. To create Named Ranges from Selection: Control + Shift + F3.
Detailed explanation-4: -The quickest way to make a named range in Excel is to use the Name Box. Highlight the range of cells you want to name. Type your desired name into the Name Box, which is the box in the upper left-hand corner of the spreadsheet that contains the cell reference. Press “Enter, ” and the cell range now has a unique name.