1 / 36

CHAPTER 2

CHAPTER 2. Modifying a Worksheet. 2.1 Entering and Reviewing Data. AutoComplete AutoCalculate AutoSum. Excel provides three “Auto” features that may be used to enter repetitive data and perform calculations. 2.1.1 Selecting Cells and Ranges. Figure 2.1 Selecting the cell range A3:E3.

juan
Download Presentation

CHAPTER 2

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CHAPTER 2 Modifyinga Worksheet

  2. 2.1 Entering and Reviewing Data • AutoComplete • AutoCalculate • AutoSum Excel provides three “Auto” features that may be used to enter repetitive data and perform calculations

  3. 2.1.1 Selecting Cells and Ranges Figure 2.1 Selecting the cell range A3:E3 Notice that the column and row frame areas are highlighted for the selected cell range.

  4. 2.1.1 Selecting Cells and Ranges Figure 2.2 Selecting a cell range using the mouse Use the cross mouse pointer to select a cell range.

  5. 2.1.1 Selecting Cells and Ranges Figure 2.3 Selecting multiple cell ranges using The active cell is the top left-hand cell in the final cell range selected.

  6. 2.1.2 Entering Data Using AutoComplete Figure 2.4 The AutoComplete feature completes an entry for “Birthday”

  7. 2.1.2 Entering Data Using AutoComplete Figure 2.5 Entering data using the AutoComplete pick list Displaying the AutoComplete pick list

  8. 2.1.3 Using AutoCalculate and AutoSum Figure 2.6 Using the AutoCalculate feature The sum total of the selected cells appears in the Status bar.

  9. 2.1.3 Using AutoCalculate and AutoSum Figure 2.7 Displaying the right-click menu for the AutoCalculate feature Displaying the AutoCalculate right-click menu for choosing calculation methods.

  10. 2.1.3 Using AutoCalculate and AutoSum Figure 2.8 Using the AutoSum button ( ) to sum a cell range A dashed marquee surrounds the selected cell range. The SUM function is entered with the selected cell range.

  11. 2.1.4 Inserting and Deleting Cells Figure 2.9 Inserting a range of cells

  12. 2.1.4 Inserting and Deleting Cells Figure 2.10 Deleting a range of cells

  13. 2.2 Copying and Moving Data Windows Clipboard • Copy a single piece of data • Paste a single piece of data Office Clipboard • Copy up to 12 pieces of data • Paste single pieces of data into individual applications • Paste groups of data into a single application

  14. 2.2.1 Using the Windows Clipboard Figure 2.11 Opening the EX0220 workbook

  15. 2.2.1 Using the Windows Clipboard Figure 2.12 Entering totals using the AutoSum button ( )

  16. 2.2.1 Using the Windows Clipboard Figure 2.13 Selecting and copying a range to the Clipboard The dashed marquee or moving border is used to signify that the data has been placed onto the Clipboard.

  17. Original data copied to the Windows Clipboard First copy pasted using the Paste button( ) The Paste Options icon lets you select advanced formatting and paste options. Second copy pasted using +v 2.2.1 Using the Windows Clipboard Figure 2.14 Copying and pasting data in a worksheet

  18. 2.2.2 Using the Office Clipboard Figure 2.15 Displaying the Clipboard task pane The contents area of the Office Clipboard task pane is empty.

  19. Clears the collected items appearing in the list box. Fourth and last item collected. Pastes all of the items appearing in the list box vertically into the worksheet. Third item collected. Second item collected. First item collected. Provides options for customizing the display of the Office Clipboard. 2.2.2 Using the Office Clipboard Figure 2.16 Clipboard task pane after collecting items

  20. 2.2.2 Using the Office Clipboard Figure 2.17 Pasting multiple items into the worksheet Notice that the rows are ordered differently than the original cell range in rows 3 through 5.

  21. 2.2.3 Using Drag and Drop Figure 2.18 Using drag and drop to move cell data

  22. 2.2.3 Using Drag and Drop Figure 2.19 Completing the Sales Forecast worksheet

  23. 2.2.4 Creating a Series Using AutoFill Figure 2.20 Using a cell's fill handle Fill handle for cell A3 The mouse pointer changes shape when positioned over the cell’s fill handle.

  24. 2.2.4 Creating a Series Using AutoFill Figure 2.21 Using AutoFill to complete cell ranges

  25. 2.2.4 Creating a Series Using AutoFill Figure 2.22 Completing the My Series workbook

  26. 2.2.5 Extending a Cell's Contents Figure 2.23 Opening the EX0224 workbook

  27. 2.2.5 Extending a Cell's Contents Figure 2.24 Extending cells using the Edit, Fill, Right command The top left-hand cell in the cell range contains the data that you want extended to the other cells.

  28. 2.2.5 Extending a Cell's Contents Figure 2.25 Filling multiple ranges with formulas stored in the leftmost column

  29. 2.3 Modifying Rows and Columns • You can enhance the appearance of a spreadsheet for both viewing and printing by adjusting row heights and column widths, and by inserting and deleting rows and columns

  30. 2.3.1 Changing Column Widths Figure 2.26 Opening the EX0230 workbook

  31. 2.3.1 Changing Column Widths Figure 2.27 Changing a column’s width The mouse pointer changes shape when positioned properly on the column borderline.

  32. 2.3.2 Changing Row Heights Figure 2.28 Changing the row height of all cells in the worksheet

  33. 2.3.2 Changing Row Heights Figure 2.29 Using AutoFit to change a row’s height

  34. 2.3.3 Inserting and Deleting Rows and Columns Figure 2.30 Displaying the right-click menu for selected columns

  35. 2.3.3 Inserting and Deleting Rows and Columns Figure 2.31 Inserting and deleting rows in the Craft Fair workbook Newly inserted row with information entered.

  36. 2.3.4 Hiding and Unhiding Rows and Columns Figure 2.32 Hiding columns and rows Columns D and E are hidden temporarily from view. Rows 6 through 11 are hidden temporarily from view.

More Related