FINAL FALL 2017
Your final will consist of about 60 skills from Word and Excel.
There is a practice set on SAM - FINAL Review Practice.
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