Title: Excel Projects/practice

Contents

Each project/practice has instructions/questions/problems and solutions

Project 1

Create an excel spreadsheet about anything….must have at least four columns and fours rows of information…

Project 2

In the attached file, format the data as a table and sort by Date Due.  After you have sorted, remove the filter arrows.  Apply two instances of conditional formatting to the amount due and create a legend for your formatting at the bottom of the data…

Project 3

FrostiWear: Linda Young is a sales manager for FrostiWear, a successful new store based in Hillsboro, Oregon… 

Project 4

Kenai Fjords National Park: Maria Sanford is the chief of interpretation at Kenai Fjords National Park. Part of her job is to report on park usage at the visitor centers…

Practice: Chart Practice

1. Midwest Tornado Institute: Joyce Bishop is a meteorologist at the Midwest Tornado Institute in Decatur, Illinois…

2. Sightings History: Go to the Sightings History worksheet, and then insert orange data bars…