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

Excel sheets showcasing the skills for Badge 1

Box

Excel 1.xlsx | Powered by Box

lilyskinner1 Over 1 year ago

Past job's timesheet (excel 1 project)

Box

Excel Badge 1.xlsx | Powered by Box

angela-hsiung Almost 2 years ago

Excel 1!!!!

Box

Box

lizzieharris About 2 years ago

Here is my project

Box

Box | Login

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.
brennanmann1 About 2 years ago

Here's my Excel 1 Project!

Box

Box | Login

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.
rya2004 About 2 years ago

Here's my Excel 1 project!

Box

Box | Login

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.
teilanialicia Over 2 years ago

A spreadsheet of my digital library

Microsoftonline

Sign in to your account

ncimbler Over 2 years ago

Excel 1

Box

Box

gracea03 Over 2 years ago

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

Box

Box

jed-roundy Over 2 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

Box

tyler-romney Over 2 years ago

USE THIS ONE

Box

Box | Login

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.
elistaggs00 About 3 years ago

Worksheet that I used in IS 110

Box

Box | Login

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.
elistaggs00 About 3 years ago