Making Label Entries

There are three basic types of cell entries: labels, values, and formulas. A label is text in a cell that identifies the data on the worksheet so readers can interpret the information. Excel does not use labels in its calculations. For example, the label price is used as a column header to identify the price of each item in the column. A value is a number you enter in a cell. Excel knows to include values in its calculations. To quickly and easily enter values, you can format a cell, a range of cells, or a column with a specific number-related format. Then, as you type, the cells are automatically formatted.

To perform a calculation in a worksheet, you enter a formula in a cell. A formula is a calculation that contains cell ...

Get Excel® 2013 On Demand now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.