Final answer:
To use cell names in formulas instead of numbers, you can assign a name to a cell or a range of cells. This allows the spreadsheet to instantly update if any of the entries is changed.
Step-by-step explanation:
To use cell names in formulas instead of numbers in a spreadsheet, you can assign a name to a cell or a range of cells. By using these names in formulas, the spreadsheet will be instantly updated if any of the entries is changed. This can be helpful when working with large datasets or when the values in the cells may change frequently. For example, if you have a formula that multiplies the values in cells A1 and A2, you can assign the names 'Number1' to A1 and 'Number2' to A2. Then, you can use the names in the formula like this: =Number1 * Number2. If you later change the values in A1 or A2, the result of the formula will automatically update.