Excel Lesson 2 Formatting and Editing Worksheets

Excel Lesson 2 Formatting and Editing Worksheets Microsoft Office 2010 Fundamentals 1 Story / Walls Objectives Excel Lesson 2

2 Create a new workbook. Format cells. Apply themes and styles and use conditional formatting. Adjust column widths and row heights. Insert and delete rows and columns. Find and replace data. Copy and move worksheet data. Check spelling. Story / Walls

MS Office 2010 Fundamentals Vocabulary Excel Lesson 2 3 fill cell style font Clipboard font conditional styles formatting paste copy point

cut size theme drag-and-drop method Story / Walls MS Office 2010 Fundamentals http://mjiang.com/mecps/tech/ office2010/Excel/ Excel Lesson 2 4 In this lesson, you will learn how to use Excels editing and formatting features to enhance the appearance of a worksheet.

You will also learn how to create a new workbook; how to format a workbook; and how to organize data to get the information you need. Story / Walls MS Office 2010 Fundamentals Creating a New Workbook Excel Lesson 2 5 Create a new workbook by clicking the File tab to display Backstage view, then clicking New. Click the Blank workbook icon in the center pane and then

click the Create button. Story / Walls MS Office 2010 Fundamentals Formatting Cells Excel Lesson 2 6 Click the dialog box launcher in the Font, Alignment, or Number groups on the Home tab to display the Format

Cells dialog box. Story / Walls MS Office 2010 Fundamentals Formatting Cells (continued) Setting Font Formats: The Font group on the Home tab on the Ribbon includes options for selecting fonts, font size, underline, and font color. Excel Lesson 2 7 Story / Walls

MS Office 2010 Fundamentals Formatting Cells (continued) Using the Format Painter: You can use the Format Painter to copy multiple formatting characteristics at once to other cells. Adding and Removing Cell Borders: Borders can be applied to any side of a cell using predefined styles or by creating custom borders. Changing Fill Color: To change a cells background color, use the Fill Color button in the Font group on the Home tab. Excel Lesson 2 8 Story / Walls

MS Office 2010 Fundamentals Formatting Cells (continued) Changing Cell Alignment: Use the buttons in the Alignment group on the Home tab. More options are located on the Alignment tab of the Format Cells dialog box. Clearing Cell Formats: Remove all the formatting from a cell or range by clicking the Clear button on the Home tab in the Editing group and then clicking Clear Formats. Excel Lesson 2 9 Story / Walls

MS Office 2010 Fundamentals Formatting Cells (continued) Applying Number Formats: To change a number format, use the buttons found on the Home tab in the Number group. Excel Lesson 2 10 Story / Walls MS Office 2010 Fundamentals Applying Themes and Styles Excel Lesson 2

11 Applying Themes: A theme is a set of predesigned formatting elementsincluding colors, fonts, and effects. Use the commands in the Themes group on the Page Layout tab. Story / Walls MS Office 2010 Fundamentals Applying Themes and Styles (continued) Excel Lesson 2

12 Working with Table Styles: Click the Format as Table button in the Styles group on the Home tab to display a gallery of table styles. Story / Walls MS Office 2010 Fundamentals Applying Themes and Styles (continued)

Excel Lesson 2 13 Applying Cell Styles: A defined combination of formatting characteristicssuch as number, alignment, font, border, and fillis called a cell style. Click the Cell Styles button in the Styles group on the Home tab to display a gallery of cell styles. Story / Walls MS Office 2010 Fundamentals Using Conditional Formatting Excel Lesson 2

14 Click the Conditional Formatting button on the Home tab in the Styles group. Story / Walls MS Office 2010 Fundamentals Working with Rows and Columns Excel Lesson 2 15 The

commands for inserting, deleting, and resizing rows and columns are located in the Cells group on the Home tab. Story / Walls MS Office 2010 Fundamentals Working with Rows and Columns (continued) Excel Lesson 2 16 Adjusting

Column Width: Use the mouse to drag the right border of the column heading to the width you want. Or specify an exact width in the Column Width dialog box by clicking the Format button in the cells group on the Home tab. Story / Walls MS Office 2010 Fundamentals Working with Rows and Columns (continued) Excel Lesson 2 17 Adjusting

Row Height: Excel changes the row height automatically to accommodate the data and font size. When necessary, you can click the row heading border and drag up or down to a new height. Story / Walls MS Office 2010 Fundamentals Working with Rows and Columns (continued) Excel Lesson 2 18 Inserting

a Row or Column: Click the Insert button arrow in the Cells group on the Home tab to display a menu with options for inserting a row or a column. Deleting a Row or Column: Click the Delete button arrow in the Cells group on the Home tab to display a menu with options for deleting rows or columns. Story / Walls MS Office 2010 Fundamentals Finding and Replacing Data Excel Lesson 2 19 Click

the Find & Select button in the Editing group on the Home tab to access the Find and Replace commands. Story / Walls MS Office 2010 Fundamentals Copying and Moving Worksheet Data Excel Lesson 2 20 To move or copy data, you can use the Clipboard or the drag-and-drop method.

Cutting, Copying, and Pasting to the Clipboard: The Cut, Copy, and Paste buttons are located in the Clipboard group on the Home tab. Story / Walls MS Office 2010 Fundamentals Copying and Moving Worksheet Data (continued) Excel Lesson 2 21 Using the Drag-and-Drop Method: Use the mouse to click a selected cell or

range, drag it to a new location, and drop it. Story / Walls MS Office 2010 Fundamentals Checking Spelling Excel Lesson 2 22 Click the Spelling button in the Proofing group on the Review tab to open the Spelling dialog box. Story / Walls

MS Office 2010 Fundamentals Summary Excel Lesson 2 23 In this lesson, you learned: How to create new workbooks. Various ways to format cells. How to apply themes and styles. Conditional formatting can help highlight and interpret data. Story / Walls MS Office 2010 Fundamentals Summary (continued)

Excel Lesson 2 24 The processes for adjusting column widths and row heights. Methods of inserting and deleting rows and columns. How to find, replace, copy, and move worksheet data. It is a good idea to check spelling. Story / Walls MS Office 2010 Fundamentals

Recently Viewed Presentations

  • Pre-Approval

    Pre-Approval

    Use age appropriate language and explanations. Post trauma reactions differ in length of time, be realistic . Trauma informed care giving. Sacramento County DHHS/CPS/RFA Program. Provide consistent, predictable pattern/routine for the child's day (this will help them feel safe)
  • PowerPoint Presentation

    PowerPoint Presentation

    Whitley Abbey Primary School Presentation to Parents Information and Guidance on the Changes and Expectations for 2015/16 In 2014/15 a new national curriculum framework was introduced by the government for Years 1, 3, 4 and 5. However, Years 2 and...
  • The Spanish Tragedy - University of Warwick

    The Spanish Tragedy - University of Warwick

    The Spanish Tragedy . was written at a key moment in European theatre history, when the communal and religious drama of the Middle Ages was giving way to a new commercial theatre industry. Michael Bristol: 'Theatre occupies a marginal space...
  • Honeynet - apan.net

    Honeynet - apan.net

    Honeynet Introduction Tang Chin Hooi APAN Secretariat
  • Ciklus znanstveno-popularnih predavanja NOBEL NA IRB-u Nobelova nagrada

    Ciklus znanstveno-popularnih predavanja NOBEL NA IRB-u Nobelova nagrada

    Medicinski važni nametnici * * * * * * * * * Laureati 2015 za fiziologiju i medicinu Udio žena dobitnica Nobelove nagrade Distribucija dobitnika Nobelove nagrade prema državljanstvu William C. Campbell Satoshi Omura Youyou Tu Antimikrobni lijekovi i cjepiva:...
  • Food Advisory Board - University of Waterloo

    Food Advisory Board - University of Waterloo

    Was the order taker in a friendly and knowledgeable? Yes. Did the servers know where to direct you to find the nutritional information? No. Server simply stated "I don't know". Was a reusable container offered? Not applicable at this location.
  • Classic vs. Functional Movement Approach in Physical Therapy ...

    Classic vs. Functional Movement Approach in Physical Therapy ...

    probably not so good for facet joint pain or the patient who has very limited capsular mobility into hip extension. remember the body moves in the path of least resistance, they could become hypermobile in lumbar spine. William's Flexion Exercises:...
  • 3-D Image Modeling Based on Data Dependent Tetrahedrization

    3-D Image Modeling Based on Data Dependent Tetrahedrization

    New PARCS Cross Section Model School of Nuclear Engineering Purdue University September 2002 Original XS Model in PARCS (1997) Example of Original Model Applications of Original Model: Static and Spatial Kinetics Problems Depletion Capability Added (2000) Nuclide depletion equation (Bateman)...