PDF Application of Skills: Microsoft Excel 2013 Tutorial

Application of Skills: Microsoft Excel 2013 Tutorial

Throughout this module, you will progress through a series of steps to create a spreadsheet for sales of a club or organization. You will continue to add to this spreadsheet in each of the steps. You should keep a digital and printed copy of the completed spreadsheet for your own records, then submit the digital document for review in STAR-Online.

? The use of bullets indicate the exact actions you need to perform to complete the module.

Red bolded words indicate specific parts of the program you will use to complete the step.

Green italicized words indicate exact text or numbers you will type in the document.

Green Underlined, italicized words are prompts for you to type individual information in the document.

Step 1

Open Excel.

? Click the Start button in the lower left hand corner of screen. Select All Programs > Microsoft Office > Excel 2013

1

Open new workbook.

? When Excel is opened, the main Microsoft Excel window is displayed as the Landing Page, with different templates displayed.

? You can also click the File tab used templates.

and select New from the list of commonly

2

Step 2

Select cells within the worksheet.

? Select the entire first column (Column A) by clicking in the gray area containing the letter A at the top of the first column.

? Select the entire first row (Row 1) by clicking in the gray area containing the number 1 on the left hand side of the worksheet.

? Click on Cell A1 (a cell is where a column and row intersect) o A line will highlight each side of this cell, making it the Active Cell o Confirm you are in the correct cell by looking in the Name Box

? Press the Enter key on the keyboard to move the cursor down one row. Your Active Cell is now Cell A2

? Press the Tab key on the keyboard to move the cursor over one column. Your Active Cell is now Cell B2

? Press the arrow keys to move left, right, up, or down from the Active Cell ? Click your cursor on any cell to make it the Active Cell ? Click the down arrow located in the Name box above Columns A and B ? Type B10 in the field

? Press the Enter key on your keyboard. Your Active Cell is now Cell B10 3

Step 3

Enter labels (text) and values (numbers) in the cells.

You can enter text, numbers, and dates in the cells. In Excel, numbers and dates are called values, and text is referred to as a label.

By default, numerical values align to the right of the cell and text labels align to the left side.

Type Labels

? Click on Cell B1 ? Type the label 1st Quarter Sales

Formula Bar

Cell B1

Notice that as you type in the cell, the information also appears in the Formula Bar.

? Press the Tab key and the label will appear in the cell ? The cursor will move over to Cell C1

4

To edit information entered in a cell, select the cell, highlight the information, and retype the data. Press the Enter key on the keyboard to apply your changes to the cell.

You can also retype information in the Formula Bar at the top of the page. When you place the cursor into the formula bar, it changes to the shape of an "I". Highlight the text you want to change, retype it, and press the Enter key on the keyboard.

? In Cell C1 type the label 2nd Quarter Sales ? Press the Tab key and the label will appear in the cell

The entire label for Cell B1 may not appear now. You will learn to adjust column width and format cells in a later section of this lesson.

? The cursor will move over to Cell D1 ? In Cell D1 type the label 3rd Quarter Sales ? Press the Tab key ? In Cell E1 type the label 4th Quarter Sales ? Press the Enter key

Type Values

? Click on Cell B2 ? Type the value 300 ? Press the Tab key ? In Cell C2 type the value 525 ? Press the Tab key ? In Cell D2 type the value 450 ? Press the Tab key ? In Cell E2 type the value 550 ? Press the Enter key

5

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download