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

Format painter
Remove duplicates
Text to columns

All posted evidence

A spreadsheet of my digital library

Microsoftonline

Excel 1

Box

gracea03 Over 3 years ago

Basketball analytics project absolute reference is F4 (use Fn key on Mac)

Box

jed-roundy Over 3 years ago

Made a collection tracker for a series of collectibles I've been hunting down since 2003, and page 2 is a my 2020 Lego spending/earning

Box

tyler-romney Over 3 years ago

USE THIS ONE

Box

Brigham Young University uses your network credentials to login to Box. Continue to login to Box through your network. If you are not a part of Brigham Young University, continue to log in with your Box.com account.