Excel



General Description

Scheduling is a common use of Excel - especially when you are managing a space with multiple rooms and multiple activities. This assignment will require you to take a very basic schedule in Excel and make it easier to read using some basic functions in Excel. You will use this Excel file.

Instructions

This Excel file has TWO tabs and you will have activities to complete in each of the tabs. The first tab is a schedule you will need to revise to make look nicer, the second tab (you will add this tab) will be a mock schedule you will build for the NEXT week (you can invent and create any events you choose), the third tab is employee and volunteer hours that will require specific tasks. Using this Excel file, make the schedule easier to read by doing the following:

Tab ONE

  1. The text currently has overlapping text because the cells are all the same size. Adjust the size of the cells so the text is easier to read and one does not have to click on the cell to read the contents - they should be immediately readable.
  2. Make the font easier to read.
  3. Add borders and colors to help the readability of the schedule content.

Tab TWO

  1. You will CREATE this tab - it's not in the sheet
  2. Name the tab appropriately - actually name the tab - not the top of the sheet
  3. Make the text, colors, borders similar to the information in tab one
  4. Do NOT copy and past the information from tab one to make tab two - create a new schedule (make up the information and keep it consistent with what would happen at a recreation center).

Tab THREE

  1. Adjust the cells to make the text within them visible.
  2. Add yourself in as either a volunteer or employee.
  3. Sort the data so the employee hours are listed before the volunteer hours
  4. Alphabetize the employees by last name.
  5. Using the sum function in Excel, add up each employee's and volunteer's hours.
  6. Add up the total volunteer hours and total employee hours using the sum function.
  7. Add borders for each row and make Row 2 and Column A bold
  8. Add in some color to distinguish the volunteers from the employees.

Output

The revised Excel file submitted on Sakai.