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

Lil project using all the bullet points

Google Docs

PeterExcelFile.xlsx

peter-giles Over 4 years ago

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

Box

Box

kimbyj Over 4 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 4 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 5 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 5 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 5 years ago

From a template and adjusted format, added totals, recreated data

Google Docs

Project tracker1.xlsx

anjac Over 5 years ago

Analyzed a data set and created charts to visualize the data.

Box

Box | Login

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

boom baby

Box

Box

mckayfritz Over 5 years ago

I tested out all the functions, absolute references, etc. I learned to copy cells, write functions, and more. This was done on 09/16/19

Google Docs

ExcelLearning1.xlsx

jalen-morgan Over 5 years ago

Does it check all the boxes? yes. Is it good? absolutely not.

Google Docs

RK Excel 1 Project 1.xlsx

rkitchen2 Over 5 years ago

learned all the skills for level 1

Google Docs

julia's excel.xlsx

juliacstark Almost 6 years ago