1 / 50

SECTION 2 SKILLS Editing and Formatting Worksheets

SECTION 2 SKILLS Editing and Formatting Worksheets. 2.1 Edit and Clear Cells and Cell Formats 2.1 Use Proofing Tools 2.2 Insert and Delete Columns and Rows 2.3 Move and Copy Cells 2.3 Use Paste Options 2.4 Adjust Column Width and Row Height 2.4 Use AutoFit CHECKPOINT 1

marc
Download Presentation

SECTION 2 SKILLS Editing and Formatting Worksheets

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. SECTION 2 SKILLSEditing and Formatting Worksheets 2.1 Edit and Clear Cells and Cell Formats 2.1 Use Proofing Tools 2.2 Insert and Delete Columns and Rows 2.3 Move and Copy Cells 2.3 Use Paste Options 2.4 Adjust Column Width and Row Height 2.4 Use AutoFit CHECKPOINT 1 2.5 Change the Font, Size, Style, and Color 2.6 Format Numeric Cells 2.6 Adjust Decimal Places 2.6 Use Undo and Redo 2.7 Change Cell Alignment and Indentation 2.7 Use Repeat 2.8 Add Borders and Shading 2.8 Copy Formats with Format Painter CHECKPOINT 2 2.9 Use Cell Styles and Themes 2.10 Use Find and Replace 2.11 Freeze and Unfreeze Panes 2.11 Change the Zoom 2.12 Insert, Move, Resize Pictures and ClipArt CHECKPOINT 3

  2. Edit and Clear Cells and Cell Formats To edit a cell: • Double-click the cell. • Press the Right or Left Arrow key to move the insertion point to the desired location. • Delete or Backspace as required. To edit a cell in the Formula bar: • Click the cell to be edited. • Click in the Formula bar at the desired location. • Delete or Backspace as required. insertion point Formula bar

  3. Edit and Clear Cells and Cell Formats…continued To clear cells and cell formats: • Select the desired range. • Click the Clear button in the Editing group in the Home tab. • Click Clear All in the drop-down list. Clear button

  4. Use Proofing Tools To check the spelling: • Click the Review tab. • Click the Spelling button in the Proofing group. • Click the appropriate option at the Spelling dialog box. Spelling dialog box

  5. Use Proofing Tools…continued To use the Thesaurus: • Click the Review tab. • Click the Thesaurus button in the Proofing group. • Point to the desired word in the Research task pane. • Click the down-pointing arrow. • Click Insert at the drop-down list. Research task pane

  6. Insert and Delete Columns and Rows To insert columns or rows: • Select the required number of columns or rows. • Click the Insert button arrow in the Cells group. • Click Insert Sheet Columns or Insert Sheet Rows. Insert button arrow

  7. Insert and Delete Columns and Rows…continued To delete columns or rows: • Select the columns or rows to be deleted. • Click the Delete button arrow in the Cells group. • Click Delete Sheet Columns or Delete Sheet Rows. OR • Position the cell pointer over a column indicator. • Right-click the mouse. • Click Delete at the shortcut menu. Delete button arrow shortcut menu

  8. Insert and Delete Columns and Rows…continued To insert cells: • Select the range of cells you need to add. • Click the Insert button in the Cells group. • Select the desired option in the Insert dialog box. To delete cells: • Select the range of cells you need to delete. • Click the Delete button in the Cells group. • Select the desired option in the Delete dialog box. Insert dialog box Delete dialog box

  9. Move and Copy Cells To move or copy cells: • Select the source cells. • Click the Cut or Copy button in the Clipboard group. • Select the starting destination cell. • Click the Paste button in the Clipboard group. Paste button

  10. Move and Copy Cells…continued To move a range of cells using drag and drop: • Select the range. • Point at any one of the four borders surrounding the selected range. • Hold down the left mouse button. • Drag the top left corner of the range to the destination. • Release the mouse button. four-headed arrow destination range

  11. Use Paste Options To copy and link cells: • Select the source cells. • Click the Copy button in the Clipboard group. • Select the destination cell. • Click the Paste button arrow in the Clipboard group. • Click the Paste Link button. Paste Link button

  12. Use Paste Options…continued • The Paste Options gallery appears in three places: • the Paste button arrow in the Clipboard group • the Paste Options button that appears after an entry has been pasted into a cell • the right-click shortcut menu • The gallery is divided into three sections: • Paste • Paste Values • Other Paste Options • Within each section buttons are included for various paste options. Paste Options gallery

  13. Adjust Column Width and Row Height To increase or decrease the column width: • Select the column(s). • Click the Format button in the Cells group. • Click the Column Width option. • Type the desired width in the Column Width dialog box. • Click OK. Format button Column Width dialog box

  14. Adjust Column Width and Row Height…continued To adjust the column width using the mouse: • Position the mouse pointer on the boundary line to the right of a column indicator until the pointer changes to a vertical line with a left- and right-pointing arrow. • Hold down the left mouse button. • Drag the boundary line to the right of the column. • Release the mouse button. boundary line

  15. Adjust Column Width and Row Height…continued To adjust the width of multiple columns: • Select the desired columns. • Position the mouse pointer on the right boundary line for a column within the selected range until the pointer changes to a vertical line with a left- and right-pointing arrow. • Drag the boundary line. • Release the mouse button. boundary line

  16. Adjust Column Width and Row Height…continued To increase or decrease the row height: • Select the row(s). • Click the Format button in the Cells group. • Click the Row Height option. • Type the desired height in the Row Height dialog box. • Click OK. Format button Row Height dialog box

  17. Adjust Column Width and Row Height…continued To adjust the row height using the mouse: • Position the mouse pointer on the boundary line below the desired row until the pointer changes to a horizontal line with a up- and down-pointing arrow. • Hold down the left mouse button. • Drag the boundary line down until the desired height displays. • Release the mouse button. boundary line

  18. Use AutoFit To use AutoFit: • Click the desired cell. • Click the Format button in the Cells group. • Click AutoFit Column Width at the drop-down list. Format button

  19. CHECKPOINT 1 • The contents of a cell can be edited directly within the cell or in this. • row indicator • column indicator • Clipboard • Formula bar • This is the default column width measurement in characters. • 4.38 • 4.83 • 8.43 • 8.34 Answer Answer Next Question Next Question • This is the name of the selected cells being cut or copied. • source • destination • target • zone • This feature enables you to double-click the boundary line to set the width to fit the length of the longest entry within a column. • AutoColumn • AutoFit • AutoWidth • AutoEntry Answer Answer Next Question Next Slide

  20. Change the Font, Size, Style, and Color To change the font: • Select the cells. • Click the Font button arrow in the Font group of the Home tab. • Click the desired font. • Deselect the cells. Font button arrow

  21. Change the Font, Size, Style, and Color…continued To change the font size: • Select the cells. • Click the Font Size button arrow in the Font group of the Home tab. • Click the desired size. • Deselect the cells. Font Size button arrow

  22. Change the Font, Size, Style, and Color…continued To change the font color: • Select the cells. • Click the Font Color button arrow in the Font group of the Home tab. • Click the desired color. • Deselect the cells. Font Color button arrow

  23. Change the Font, Size, Style, and Color…continued To change the fill color: • Select the cells. • Click the Fill Color button arrow in the Font group of the Home tab. • Click the desired color. • Deselect the cells. Fill Color button arrow

  24. Change the Font, Size, Style, and Color…continued To use the Format Cells dialog box: • Select the cells. • Click the Font group dialog box launcher in the Font group of the Home tab. • Click the desired color in the Format Cells dialog box. • Deselect the cells. Format Cells dialog box

  25. Format Numeric Cells To change the numeric format: • Select the cells. • Click the desired format style button in the Number group in the Home tab. • Deselect the cells. Number group

  26. Format Numeric Cells…continued To use additional number format options: • Click the Number Format button arrow in the Number group of the Home tab. • Click an option from the drop-down list. Number Format button arrow

  27. Adjust Decimal Places To adjust decimal places: • Select the cells. • Click either the Increase Decimal button or the Decrease Decimal button in the Number group in the Home tab. • Deselect the cells. Increase Decimal button Decrease Decimal button

  28. Use Undo and Redo To use Undo: • Click the Undo button on the Quick Access toolbar or use the Ctrl + Z keyboard shortcut. To use Redo: • Click the Redo button on the Quick Access toolbar or use the Ctrl + Y keyboard shortcut. Undo button Redo button

  29. Change Cell Alignment and Indentation To change the horizontal or vertical alignment of cells: • Select the cells. • Click the desired alignment button in the Alignment group of the Home tab. • Deselect the cells. alignment buttons

  30. Change Cell Alignment and Indentation…continued To wrap text within a cell: • Select the cells. • Click the Wrap Text button in the Alignment group of the Home tab. • Deselect the cells. original cells cells with Wrap Text applied

  31. Change Cell Alignment and Indentation…continued To indent text within cells: • Select the cells. • Click the Increase Indent button in the Alignment group of the Home tab. • Deselect the cells. Increase Indent button

  32. Use Repeat To repeat a command: • Press Ctrl + Y. To add the Repeat button to the Quick Access toolbar: • Click the Customize Quick Access Toolbar button. • Click More Commands. • At the Excel Options dialog box with Quick Access Toolbar selected in the left pane, scroll down the left list box. • Click Repeat. • Click the Add button. • Click OK. Excel Options dialog box

  33. Add Borders and Shading To add borders: • Select the cells. • Click the Borders button arrow in the Font group of the Home tab. • Click the desired border style. • Deselect the cells. Borders button arrow

  34. Add Borders and Shading…continued To display more borders: • Select the cells. • Click the Borders button arrow in the Font group of the Home tab. • Click the More Borders option at the bottom of the Borders list to display the Format Cells dialog box with the Border tab selected. Format Cells dialog box

  35. Copy Formats with Format Painter To copy formats with Format Painter: • Make the cell containing the source formats is active. • Single-click or double-click the Format Painter button in the Clipboard group of the Home tab. • Click the destination cell(s). • If necessary, click the Format Painter button to turn the feature off. marquee

  36. CHECKPOINT 2 • This is the default font size used by Excel. • 9 point • 10 point • 11 point • 12 point • Use these to underscore headings or totals or to emphasize other cells. • borders • shading • bold • italics Answer Answer Next Question Next Question • By default, cells are initially set to this format. • Normal • Standard • Default • General • This feature copies formats from a selected cell to another cell. • Cut and Paste • Copy and Paste • Format Painter • Format Copier Answer Answer Next Question Next Slide

  37. Use Cell Styles and Themes To apply cell styles: • Select the cells. • Click the Cell Styles button in the Styles group in the Home tab. • Click the desired style in the drop-down gallery. Cell Styles button

  38. Use Cell Styles and Themes…continued To create a new style: • Select a cell. • Apply all formatting to the cell that you want saved in the style. • Click the Cell Styles button in the Styles group in the Home tab. • Click New Cell Style at the drop-down gallery. • At the Style dialog box, type a name for the style in the Style name text box. • Click OK. Style dialog box

  39. Use Cell Styles and Themes…continued To apply a theme: • Click the Page Layout tab. • Click the Themes button in the Themes group. • Click the desired theme in the drop-down gallery. Themes button

  40. Use Find and Replace To find a label or a value: • Click the Find & Select button in the Editing group in the Home tab. • Click Find. • Type a label or value in the Find what text box. • Click Find Next. Find and Replace dialog box

  41. Use Find and Replace…continued To replace a label or a value: • Click the Find & Select button in the Editing group in the Home tab. • Click Replace. • Type a label or value in the Find what text box. • Type the replacement label or value in the Replace with text box. • Click Find Next or Replace All. Find and Replace dialog box

  42. Use Find and Replace…continued To replace formats: • Click the Find & Select button in the Editing group in the Home tab. • Click Replace. • Click the Options button. • Use the Format buttons to the right of the Find what and Replace with text boxes to specify the required format options. Format buttons

  43. Freeze and Unfreeze Panes To freeze panes: • Make the cell active below and to the right of the row or column headings you want to freeze. • Click the View tab. • Click the Freeze Panes button in the Window group. • Click Freeze Panes. Freeze Panes button

  44. Freeze and Unfreeze Panes…continued To unfreeze panes: • Click the View tab. • Click the Freeze Panes button in the Window group. • Click Unfreeze Panes. Freeze Panes button

  45. Change the Zoom To change the Zoom setting: • Drag the Zoom slider bar. OR • Click the Zoom In or Zoom Out buttons. OR • Click the zoom percentage value. • Choose the magnification option at the Zoom dialog box. Zoom Out button Zoom In button Zoom slider bar Zoom dialog box

  46. Change the Zoom…continued To zoom to a selection: • Click the View tab. • Click the Zoom button in the Zoom group to open the Zoom dialog box. Zoom button

  47. Insert, Move, Resize Pictures and ClipArt To insert Clip Art: • Click the Insert tab. • Click the Clip Art button in the Illustrations group in the Home tab. • Search for the image by typing a keyword in the Search by text box. • Click the desired image in the Results section. • Move and/or resize as required. • Close the Clip Art task pane. Clip Art task pane

  48. Insert, Move, Resize Pictures and ClipArt…continued To insert a picture: • Click the Insert tab. • Click the Picture button in the Illustrations group in the Home tab. • Navigate to the drive and/or folder in the Insert Picture dialog box. • Double-click the desired file containing the picture. • Move and/or resize as required. Insert Picture dialog box

  49. CHECKPOINT 3 • How many sections are predefined cell styles grouped into? • 2 • 3 • 4 • 5 • This option causes rows and columns to remain fixed when scrolling. • Freeze Panes • Unfreeze Panes • Lock Panes • Unlock Panes Answer Answer Next Question Next Question • Changing this will cause the fonts, colors, and effects to change for the cells. • theme • font • border • shading • ClipArt and pictures can be inserted using buttons on which tab? • Home • Insert • Page Layout • Data Answer Answer Next Question Next Slide

More Related