![]() Similarly, for Sales Rep and Sales, you will have to use B2:B11 and C2:C11. In this data set, if you have to refer to the range that has the Date, you will have to use A2:A11 in formulas. ![]() Now, instead of using the cell reference (such as A1 or A1:A10), you can simply use the name that you assigned to it.įor example, suppose you have a data set as shown below: Similarly, in Excel, you can give a name to a cell or a range of cells. If someone has to call me or refer to me, they will use my name (instead of saying a male is staying in so and so place with so and so height and weight).
0 Comments
Leave a Reply. |