Rakesh handa
Rakesh_handa81@yahoo.co.in
Answer :-
Use named ranges to make formulas easier to understand.
And if you make the formula first and then decide to make the
worksheet easier to understand.
Follow the following steps:-
use Insert - Name - Apply to apply names to existing formulas, as shown below
Rakesh_handa81@yahoo.co.in
CREATE EASIER-TO-UNDERSTAND FORMULAS WITH NAMED
RANGES
As shown above , worksheet
contains several different formulas. It would be easier to
understand the results if each component of every formula were
named for what it represented and not just for the cell it came
from.
Answer :-
Use named ranges to make formulas easier to understand.
- Give cell B3 a name of Revenue.
- Select cell B3. In the Name box (the area to the left of the formula
- Give cell B4 a name of COGS. Select cell B4. Click in the name box, type COGS and hit Enter.
- Clear the formula in B6. Re-enter the formula and use the mouse to select the cells. Type an Equal sign. Using the mouse, touch B3. Type a Minus sign. Using the mouse, touch B4. This will enter the formula as =Revenue-COGS, as shown in Fig. below. This is easier to understand than a typical formula.
Follow the following steps:-
use Insert - Name - Apply to apply names to existing formulas, as shown below
