Entering Text and Using AutoComplete - Exercise

Contact Us or call 1-877-932-8228
Entering Text and Using AutoComplete - Exercise

Entering Text and Using AutoComplete

Duration: 5 to 10 minutes.

Before the end of this course we will build a spreadsheet showing the quarterly profit & loss statement for a fictitious company called Dave's Lemonade Stand. This is the first of these exercises. The spreadsheet will ultimately look like the below:

In this exercise, you will enter income and expense categories in column A of a new worksheet.

  1. Open a new workbook and enter text, using AutoComplete whenever possible, in column A so that your worksheet looks like the following:
  2. Save the workbook as Dave's Lemonade Stand.xlsx in your Excel2013.1/Exercises folder.

Solution:

  1. Open a new workbook.
  2. Select cell A2, type "Income", and press Enter.
  3. Enter the required text in cells A3:A7.
  4. In cells A8 and A9, type "S" and press Enter.
  5. Enter the required text in cells A10 and A11.
  6. Save the workbook in your Excel2013.1/Exercises folder.
Next