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

Box

Box

garrett-johns Over 4 years ago

excel 1 project

Box

Box

addiehop Almost 5 years ago

PMG Attribute Activity on Excel, plus another worksheet with stuff I couldn't show

Box

Box

savfill Almost 5 years ago

Excel One

Microsoftonline

Sign in to your account

lilliv About 5 years ago

My Budget

Box

Box

hsorensen138 About 5 years ago

Excel 1 Project!

Box

Box

katem88 About 5 years ago

Lil project using all the bullet points

peter-giles Over 5 years ago

I included everything in a very unorganized way. But it's all there which is what counts!

Box

Box

kimbyj Over 5 years ago

A chart I made.

Box

Box | Login

Brigham Young University uses your network username and password to login to Box. Continue to login to Box through your network.
adam3norton Over 5 years ago

box link to excel 1 project

Box

Box | Login

Brigham Young University uses your network username and password to login to Box. Continue to login to Box through your network.
brooketti About 6 years ago

I took the excel class for 4 days so here is my first project!

Box

Box | Login

Brigham Young University uses your network username and password to login to Box. Continue to login to Box through your network.
derek5h Over 6 years ago

I made an excel spreadsheet using the fill handle and formulas.

Box

Box | Login

Brigham Young University uses your network username and password to login to Box. Continue to login to Box through your network.
cmoose Over 6 years ago