1. Complete a Project

Demonstrate skill with:

• Create new worksheets and name them.
• Enter in data in cells in different ways.
• SUM function
• AVERAGE function
• IF function
• MIN function
• MAX function
• Add, subtract, multiply, and divide formulas
• How to use the fill handle and demonstrate the different methods of the fill handle (click and drag method, double click method).
• Understand the different formatting options for cells. (Phone number, $$, time)
• Know and explain how the absolute reference works. Know the shortcut key for both Windows and Mac.
• Data cleaning
• Format painter
• Remove duplicates
• Text to columns