Excel 2013 Level 1 Unit 1 Preparing and Formatting a Worksheet

2. Excel 2013Level 1 Unit 1 Preparing and Formatting a Worksheet Chapter 1Preparing an Excel Workbook

3. Preparing an Excel Workbook Quick Links to Presentation Contents • Create a Worksheet • Save a Workbook • Edit Data in a Cell • Print a Workbook • Close a Workbook and Close Excel • CHECKPOINT 1 • Use Automatic Entering Features • Open a Workbook • Insert a Formula • Select Cells • Apply Basic Formatting • Use Help • CHECKPOINT 2

4. Create a Worksheet To open Microsoft Excel 2013: • At Windows 8 Start screen, click Word 2013 tile. Excel 2013 tile

5. Create a Worksheet - continued tabs Title bar Quick Access toolbar ribbon File tab Name box Collapse the Ribbon button Formula bar active cell cell pointer worksheet area vertical scroll bar sheet tabs New sheet button Status bar horizontal scroll bar

6. Create a Worksheet - continued continues on next slide…

7. Create a Worksheet - continued continues on next slide…

8. Create a Worksheet - continued

9. Create a Worksheet - continued Name box Formula bar Select All button column header fill handle active cell cell pointer row header

10. Create a Worksheet - continued

11. Create a Worksheet - continued • When you are ready to type data into the active cell, check the Status bar. The word READY should display at the left side. As you type data, the word READY changes to ENTER. • If the data you type is longer than the cell can accommodate, the data overlaps the next cell to the right. • If, however, you enter a number in a cell, specify it as a number (rather than text). If the number is too long to fit in the cell, Excel changes the display of the number to number symbols (###).

12. Save a Workbook To save a workbook: • Click Save button. • At Save As backstage area, click desired folder. • Type workbook name in File name text box. • Press Enter. File name text box

13. Save a Workbook - continued • A workbook file name can contain up to 255 characters, including drive letter and any folder names, and can include spaces. • Some symbols cannot be used in a file name, such as: forward slash (/) question mark (?) backslash (\) quotation mark (“) greater than sign (>) colon (:) less than sign (<) semicolon (;) asterisk (*) pipe symbol (|)

14. Edit Data in a Cell • Edit data being typed in a cell by pressing the Backspace key to delete the character to the left of the insertion point or by pressing the Delete key to delete the character to the right of the insertion point. • To change the data in a cell, click the cell once to make it active and then type the new data. • When a cell containing data is active, anything typed will take the place of the existing data.

15. Edit Data in a Cell - continued • If the active cell does not contain data, the Formula bar displays only the cell reference (by column letter and row number). • As you type data, the two buttons shown below display on the Formula bar to the right of the Name box. Enter Cancel

16. Print a Workbook Click the FILE tab to display the backstage area. Information about the worksheet displays in this area of the Info backstage area. Backstage area options

17. Print a Workbook - continued Click the Print button to send the workbook to the specified printer. Worksheet Preview Print option navigation buttons

18. Close a Workbook and Close Excel To close a workbook: • Click FILE tab. • Click Close option. To close Excel: • Click Close button. Close button

19. CHECKPOINT 1 • A file created in Excel is referred to as this. • document • workbook • worksheet area • template • Press these keys to move to the previous cell. • Ctrl + Alt + Tab • Alt + Tab • Ctrl + Tab • Shift + Tab Answer Answer Next Question Next Question • The area containing the gridlines in the Excel window is called this. • document • workbook • worksheet area • template • A workbook file name can contain up to how many characters? • 55 • 155 • 255 • 355 Answer Answer Next Question Next Slide

20. Use Automatic Entering Features • Excel contains several features that help you enter data into cells quickly and efficiently. • These features include AutoComplete, which automatically inserts data in a cell that begins the same as a previous entry; AutoCorrect, which automatically corrects many common typographical errors; and AutoFill, which automatically inserts words, numbers, or formulas in a series.

21. Use Automatic Entering Features - continued When you type the text displayed in the first column of this list box in a worksheet and then press the spacebar, the text is replaced by the text in the second column of this list box.

22. Use Automatic Entering Features - continued • When a cell is active, a thick, green border surrounds it and a small, green square displays in the bottom right corner of the border. This black square is called the AutoFill fill handle. • With the fill handle, you can quickly fill a range of cells with the same data or with consecutive data. • You can also use the fill handle to insert a series in a row or column of cells.

23. Use Automatic Entering Features - continued

24. Open a Workbook Openoption To open a workbook: • Click FILE tab. • Click Openoption. • Click desired location (SkyDrive or Computer). • Click Browse button. • Display desired folder. • Double-click desired workbook name.

25. Insert Formulas • Excel is a powerful decision-making tool you can use to manipulate data to answer questions in “What if?” situations. • Insert a formulain a worksheet to perform calculations on values. • A formula contains a mathematical operator, value, cell reference, cell range, and function. • Formulas can be written to add, subtract, multiply, and/or divide values. • Formulas can also be written to calculate averages, percentages, minimum and maximum values, and much more.

26. Insert Formulas - continued To insert a formula using the AutoSum button: • Click in desired cell. • Click AutoSum button. • Check range identified and make changes if necessary. • Press Enter. AutoSum button

27. Insert Formulas - continued To insert an Average formula using the AutoSum button: • Click in desired cell. • Click AutoSum button. • Check range identified and make changes if necessary. • Press Enter. Average option

28. Insert Formulas - continued To copy a formula using the fill handle: • Insert formula in cell. • Make active the cell containing formula. • Using fill handle, drag through cells to contain formula. fill handle

29. Select Cells

30. Select Cells - continued

31. Apply Basic Formatting To change the column width: Drag column boundary line OR Double-click column boundary column boundary line

32. Apply Basic Formatting - continued To merge and center cells: • Select cells. • Click Merge & Center button. Merge & Center button

33. Apply Basic Formatting - continued

34. Use Help To use the Help feature: • Click Microsoft Excel Help button. • Type topic or feature. • Press Enter. • Click desired topic. Microsoft Excel Help button

35. Use Help - continued Home Keep Help on Top Back Use Large Text Forward Print

36. Use Help - continued • Some button ScreenTips, dialog boxes, and backstage areas contain a Help icon or button you can click to display a help window with specific information about the button feature, dialog box, or backstage area. ScreenTip help hyperlink

37. CHECKPOINT 2 • This feature automatically corrects many common typing errors. • AutoComplete • AutoCorrect • AutoFill • AutoFix • Press these keys to select an entire worksheet. • Ctrl + S • Ctrl + W • Ctrl + E • Ctrl + A Answer Answer Next Question Next Question • You can use this button in the Editing group in the Home tab to insert a formula. • AutoTotal • AutoCalculate • AutoSum • AutoAdd • How are numbers in a cell aligned by default? • right • left • center • justify Answer Answer Next Question Next Slide

38. Preparing an Excel Workbook Summary of Presentation Concepts • Identify the various elements of an Excel workbook • Create, save, and print a workbook • Enter data in a workbook • Edit data in a workbook • Insert a formula using the AutoSum button • Apply basic formatting to cells in a workbook • Use the Help feature