Explain the types of data you may enter in Excel, under the following headings:
(a) Numbers
(b) Formulae
(c) text
Answers
Answer:
You will begin building the workbook shown in Figure 1.1 by manually entering data into the worksheet. The following steps explain how the column headings in Row 2 are typed into the worksheet:
Click cell location A2 on the worksheet.
Type the word Month.
Press the RIGHT ARROW key. This will enter the word into cell A2 and activate the next cell to the right.
Type Unit Sales and press the RIGHT ARROW key.
Repeat step 4 for the words Average Price and then again for Sales Dollars.
Figure 1.15 shows how your worksheet should appear after you have typed the column headings into Row 2. Notice that the word Price in cell location C2 is not visible. This is because the column is too narrow to fit the entry you typed. We will examine formatting techniques to correct this problem in the next section.