User defined blocks of code can be created in
1 answer:
You might be interested in
Answer:
See explanation below
Explanation:
Named ranges are a very important tool in Microsoft Excel. It is used in assigning a name to a particular number of cells. It is great for automation and makes formula much easy to understand and use.
One way to create named ranges is theory the Name Box.
To create named ranges in the design marketing sheet we do this;
1) We click on cell B8 and then navigate to the name box at the top right corner of the sheet just above the column A.
•The name box is where the cell address of any cell that is active is displayed.
•You would see that “B8” is displayed on the name box.
• Double click on the name box and type in the appropriate name, in this case - Design_Fee.
• Press enter and you have your named range.
You do the same for the other named ranges.
Note that: Named ranges must contain letters, numbers or underscore.
