Using Data Types to Populate a Worksheet LESSON ITEM #8: Enter Labels and Use AutoComplete Action: Open a new workbook. In cell A1 type Workforce Centers, and press Enter. Type Monthly Traffic and press Enter. cell A4 and type Workforce Professional and press Tab. In cell B4 type Date and press Tab. In cell C4, type January Costs and press Enter. In cell A5, type Randy Bloom, and press Enter. In cell A6, type Daniel Overland, and press Enter. In cell A7, type Kathy Aims and press Enter. Type Drew and press Enter. Click cell A9 and type the letter ‘R’. Notice the AutoComplete displays the entry for Randy Bloom. Type the letter ‘Y’. Notice the AutoComplete disappears. Finish typing the entry for Rylie Calms and press Enter. Type the letter ‘R’. Notice no AutoComplete appears. Type the letter and notice that the AutoComplete appears for Randy Bloom. ‘A’ Press Esc key to undo the entry. Increase the column widths to show column A. Enter Numeric Values Action: cell C5, type $3,235, and press Enter. Click cell C6, type 1,356, and press Enter. Type 2536 and Enter. Type 5632 and Enter. Type 1462 and press Enter. Enter Dates Action: Click cell B5, type 1/3/2016, and press Enter. cell B6, type 1/20/2016, and press Enter. Type 1/21 and press Enter. In cell B8, type 1/27/16 and press Enter. Type January 29, 2016 and press Enter. Cutting, Copying, and Pasting Data LESSON ITEM #9: Copy, Cut and Paste Data Action: Navigate to Understanding Excel Practice.
LESSON ITEM #8: Using Data Types to Populate a Worksheet Enter Labels and Use AutoComplete Action: Open a new workbook. In cell A1 type Workforce Centers, and press Enter. Type Monthly Traffic and press Enter. cell A4 and type Workforce Professional and press Tab. In cell B4 type Date and press Tab. In cell C4, type January Costs and press Enter. In cell A5, type Randy Bloom, and press Enter. In cell A6, type Daniel Overland, and press Enter. In cell A7, type Kathy Aims and press Enter. Type Drew and press Enter. Click cell A9 and type the letter ‘R’. Notice the AutoComplete displays the entry for Randy Bloom. Type the letter ‘Y’. Notice the AutoComplete disappears. Finish typing the entry for Rylie Calms and press Enter. Type the letter ‘R’. Notice no AutoComplete appears. Type the letter ‘A’ and notice that the AutoComplete appears for Randy Bloom. Press Esc key to undo the entry. Increase the column widths to show column A. Enter Numeric Values Action: cell C5, type $3,235, and press Enter. Click cell C6, type 1,356, and press Enter. Type 2536 and Enter. Type 5632 and Enter. Type 1462 and press Enter. Enter Dates Action: Click cell B5, type 1/3/2016, and press Enter. cell B6, type 1/20/2016, and press Enter. Type 1/21 and press Enter. In cell B8, type 1/27/16 and press Enter. Type January 29, 2016 and press Enter. LESSON ITEM #9: Cutting, Copying, and Pasting Data Copy, Cut and Paste Data Action: Navigate to Understanding Excel Practice.
Introduction-to-Microsoft-Excel-2013-1.docx