This worksheet is designed to help track sales for a small business. The first column of data lists the items for sale, the second column of data lists the price of each item, and the third column of data lists the number of items sold. We will use the fourth column of data to show the total sales for each item, which we will calculate by multiplying the values in the second and third columns. Obviously, a real business would have many more items for sale. However, even though this worksheet has only a small amount of data, its organizational structure could be used in a much larger worksheet.
There are four basic types of information that can be entered into cells: text, numbers, formulas, and functions. Let's look at these types of data in this worksheet.
Understanding Text Data
Text isentered into cells by typing characters, including letters, numbers, and/or punctuation. Names, street addresses, and cities are all examples of text data. Phone numbers, postal codes, and social security or ID numbers are also considered text, because they are not mathematically manipulated. Excel will also interpret any combination of numbers and other characters as text, since they cannot be used in arithmetic calculations.
It is important to realize that there may be a difference between the contents of a cell (the data which has been entered) and how those contents are displayed in the cell. The Formula bar will always display the true contents of the cell without displaying any special formatting.
We will examine some of the cells that contain text.
Step1. To see the contents of cell B2,
Click cell B2
Step2. To see the contents of cell B3,
Click cell B3
Suppose the contents of this cell were incorrect. This company is really selling Spades, which are a particular kind of shovel. We will change the contents of B3 from "Shovel" to "Spade."
Step1. To change the data in cell B3, type:
Step2. To view the contents of other cells in column B, press:
Down Arrow key multiple times
Understanding Numeric Data
Numbers are typically used to perform calculations. Excel also considers dates and times as specific types of numeric values. Numeric values within a cell can be formatted just like text. Other formatting, such as currency or percentages, can also be applied.
Next, we will examine cells with different formatting.
Step1. To look at a cell containing a number,
Click cell C3
Step2. Examine some of the other cells in column C.
Step3. Examine the cells with numbers in column E.