Microsoft Excel - 1/3

1. Complete a Project

Only editable by group admins

Last updated August 6, 2024 at 3:13 PM by byustl
Evidence visible to public

Create a project demonstrating your ability to use all of the tools listed below. Provide a brief explanation of your project and post a link to the file.

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