FINAL FALL 2017

WORD SKILLS

• • Use the Word Count

  • Find and Replace Text

  • Remove a hyperlink

  • correct a spelling or grammar mistake

  • Use the Thesaurus

  • Change the theme

  • Add a border to a picture

  • Insert a picture from a file

  • Resize an object

  • Align data in a table cell

  • Change the text wrapping

  • Insert a shape

  • Insert a header or footer

  • Change the margins

  • Apply bullets to paragraphs

  • Insert a table

  • Merge table cells

  • Set a tab stop

  • Insert a symbol from the Symbol gallery

  • Switch to Print Layout

  • Add a page border

  • Align a paragraph

  • Change the line spacing

  • Change teh paragraph spacing

  • Create a first line indent

  • Remove space before or after a paragraph

  • Apply a style

  • Apply a table style

  • Show/Hide formatting marks

  • Show the rulers

  • Insert a footnote

  • Clear formatting

  • Change the case

  • Apply a text effect

  • Insert a bibliography

  • Insert a citation using a new source

  • Insert a page break

  • Select a table row or column

EXCEL SKILLS

• • Scale a worksheet for printing

  • Insert a 3-D Pie chart

  • Select non-adjacent cells

  • Move a chart to a chart sheet

  • Create a New Conditional formatting rule

  • Add a border to cells

  • Apply the Currency number format

  • Apply the Date number format

  • Change the number of displayed decimal places

  • Use Flash Fill

  • Use the Fill handle to copy a formula

  • Print a section of a worksheet

  • Align cell contents horizontally

  • Apply the Comma number format

  • Apply the Percentage number format

  • Change the fill color of a cell

  • Create a formula using the AVERAGE function

  • Create a formula using the MAX function 

  • Create a formula using the SUM function

  • Merge and center cells contents

  • Rename a worksheet