Reference no: EM132233936

Lab Assignment -

Conditional Formatting Assignment - Part 1

The extensive list of numbers shown really do not give us a good picture of how our improvement methods for the given assessment are working. We need get a better picture by adding some conditional formatting.

Objective: Format the list of data measurements for easier reading and presentation.

Improvement in results is measured by subtracting the Baseline Assessment (first score) from the Final Test (last score). You also need to find the percentage improvement based upon a similar formula. So you need to display the improvement score and add data bars to each improvement score. In order to avoid clutter and make the improvement and percentage data bars more readable, remember these two conditions: Data bars must not display negative values, and Data bars should be displayed in a separate columns than values. Retain the data in the original order provided. An example file is available.

Also, highlight the bottom 6 percent of the Baseline Assessment, and highlight the top 6% of the Final Test.

Make sure that all data (text, dates, times, and amounts, etc.) are displayed in the proper formats. Make sure that all worksheet tabs have informative labels. Information that is not labelled in not meaningful or professional.

Assignments and Quizzes -

Problem 1 - Start your own workbook. Use the Today function to determine the day that occurs 74 days after today's date, 74 workdays after today's date, and 74 workdays after today's date (including holidays). List the dates of the holidays off to the side.

Problem 2 - Create your own worksheet. Include a small image of a 2005 calendar, list holidays, calculate workdays between dates, and count dates in bought column. Use workday, networkdays, and count functions. See image below.

Problem 3 - Use a blank worksheet and format as below with the ability to put any date in the date cell and have Day show the weekday of the first day of the month of that date. You may wish to display the actual weekday first, then find the weekday of the first day of the month.

1. Write a formula that will return a time 18 hours after the current time.

2. The Marathon.xlsx file gives marathon race times for four runners. Problems (a) through (c) refer to this data. Compute the average time of the runners.

a. How much faster was John than Jill?

b. How many total minutes did each runner take?

c. How many total seconds did each runner take?

3. The Jobshop.xlsx file gives the start time and date for several jobs and the time required to complete each job. Determine the completion time for each job.

You may combine these into one workbook if you wish.

Attachment:- Assignment Files.rar