Determine the completion time for each job

Assignment Help Other Subject
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.

694_figure.png

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.

2093_figure1.png

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

Reference no: EM132233936

Why theory you have chosen is best one to explain mystery

After summarizing at least two scholarly theories, identify one of the theories as the most plausible and provide at least two convincing reasons why the theory you have cho

Write a paper that examines assessment tools

Write a 1,050- to 1,400-word paper that examines assessment tools that evaluate physical measures, and how applying Watson's theory of human caring integrates the mind-body

What did you learn about your peers in the class

What did you learn about yourself through the process of learning about learning? What did you learn about your peers in the class through the process of learning about learni

Provide the reader with a review of most relevant literature

Review of the literature: Provide the reader with a review of most relevant literature, beginning with general information, and narrowing the focus to the specific issues un

Brainstorm about racism or discrimination

brainstorm about racism or discrimination i have immigrant discrimination, race discrimination, religion dis., sex and gender dis., sex orientation dis., culture,steriotype i

Determine which cpu of the two is faster and why

From the first e-Activity, identify the following CPUs: 1) the CPU that resides on a computer that you own or a computer that you would consider purchasing, and 2) the CPU o

Provide an example of your sales plan for coming year

Assume that you are a sales director who is responsible for the southeastern sales team for a large telecommunications company. Youare currently in the process of preparing th

Trait theories of leadership

Your company's HR director is a believer in trait theories of leadership. He believes that he can differentiate leaders from non-leaders by focusing on personal qualities and

Reviews

len2233936

2/13/2019 9:45:05 PM

Please note that values shown on examples might not match numbers in your finished result file. Also, not every step in your process will be explicit. You may have to explore, rationalize, and find the method or option that works consistently with the data given as well as different data sets with minimum or no end-user interaction. 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. Making information presentation meaningful, insightful, and professional.

Write a Review

 
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd