Entering Numbers and Dates - Exercise

Contact Us or call 1-877-932-8228
Entering Numbers and Dates - Exercise

Entering Numbers and Dates

Duration: 5 to 10 minutes.

In this exercise, you will enter the four quarters of the year at the top of your worksheet and will enter projected quarterly numbers for the two income categories.

  1. Open or go to Dave's Lemonade Stand.xlsx, which you created in the previous exercise.
  2. Follow the instructions below to add data to rows 1, 3, and 4 such that your worksheet looks like the following:Worksheet with Data
    1. Enter dates and numbers in columns B and C
    2. Use Autofill to add dates and numbers to D and E
  3. Edit cells A7:A9 by replacing "Some Expense" with "Payroll", "Marketing" and "Supplies", as shown in the above image.
  4. Save the workbook.

Solution:

  1. Open or go to Dave's Lemonade Stand.xlsx.
  2. Enter "3/31/13" in cell B1.
  3. Enter "6/30/13" in cell C1.
  4. Enter "3000" in cell B3.
  5. Enter "3100" in cell C3.
  6. Enter "2000" in cell B4.
  7. Enter "2200" in cell C4.
  8. Select cells B1:C1, click Autofill and drag to column E.
  9. Select cells B3:C3, click Autofill and drag to column E.
  10. Select cells B4:C4, click Autofill and drag to column E.
  11. Edit cells A7:A9 by replacing "Some Expense" with "Payroll", "Marketing" and "Supplies".
  12. Save the workbook.
Next