what is use of name box and name value in ms excel?
Answers
Answered by
2
mark me brainliest answer plsss
A name is a meaningful shorthand that makes
it easier to understand the purpose of a cell
reference, constant, formula, or table, each of
which may be difficult to comprehend at first
glance. The following information shows
common examples of names and how they can
improve clarity and understanding.
Example
Type
Example with no
name
Example with a
name
Reference =SUM(C20:C30) =SUM
(FirstQuarterSales)
Constant =PRODUCT(A5,8.3) =PRODUCT
(Price,WASalesTax)
Formula =SUM(VLOOKUP
(A1,B1:F20,5,FALSE),
-G5)
=SUM
(Inventory_Level,-
Order_Amt)
Table C4:G36 =TopSales06
Types of names
There are several types of names that you can
create and use.
Defined name A name that represents a cell,
range of cells, formula, or constant value. You
can create your own defined name, and
Microsoft Office Excel sometimes creates a
defined name for you, such as when you set a
print area.
Table name A name for an Excel table,
which is a collection of data about a
particular subject that is stored in records
(rows) and fields (columns). Excel creates a
default Excel table name of Table1, Table2,
and so on, each time that you insert an Excel
table, but you can change a table's name to
make it more meaningful. For more
information about Excel tables,
A name is a meaningful shorthand that makes
it easier to understand the purpose of a cell
reference, constant, formula, or table, each of
which may be difficult to comprehend at first
glance. The following information shows
common examples of names and how they can
improve clarity and understanding.
Example
Type
Example with no
name
Example with a
name
Reference =SUM(C20:C30) =SUM
(FirstQuarterSales)
Constant =PRODUCT(A5,8.3) =PRODUCT
(Price,WASalesTax)
Formula =SUM(VLOOKUP
(A1,B1:F20,5,FALSE),
-G5)
=SUM
(Inventory_Level,-
Order_Amt)
Table C4:G36 =TopSales06
Types of names
There are several types of names that you can
create and use.
Defined name A name that represents a cell,
range of cells, formula, or constant value. You
can create your own defined name, and
Microsoft Office Excel sometimes creates a
defined name for you, such as when you set a
print area.
Table name A name for an Excel table,
which is a collection of data about a
particular subject that is stored in records
(rows) and fields (columns). Excel creates a
default Excel table name of Table1, Table2,
and so on, each time that you insert an Excel
table, but you can change a table's name to
make it more meaningful. For more
information about Excel tables,
Similar questions