Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

In the Problem 4 tab there is a table with a list of tasks and due dates for a project. You will need to apply

image text in transcribed

In the "Problem 4" tab there is a table with a list of tasks and due dates for a project. You will need to apply the following to the table to make it a formal project management tool. 1. Include appropriate boarders and shading for the table. There is no RIGHT way to format the table but it should be professional and easy to read. 9. In the progress column add a drop-down box. The box should allow users to select from 4 options: a. Not started b. On Track c. Late d. Complete 3. In the Assigned Engineer column add a drop-drown box which allows users to select the engineer in charge of that task. You can make up 4 names for the list of engineers. Difference in Projected - There should be a formula to calculate the difference in the approx. and actual costs. a. Using conditional formatting i. If the task actually costs more than $250 of the approximate cost the cell should be highlighted red with red text. ii. If the tasks was more than $2.50 cheaper than the approximated cost the cell should be highlighted green with green text. 5. Add a Total Project Cost and Total Difference in Project Costs cell. In the "Problem 4" tab there is a table with a list of tasks and due dates for a project. You will need to apply the following to the table to make it a formal project management tool. 1. Include appropriate boarders and shading for the table. There is no RIGHT way to format the table but it should be professional and easy to read. 9. In the progress column add a drop-down box. The box should allow users to select from 4 options: a. Not started b. On Track c. Late d. Complete 3. In the Assigned Engineer column add a drop-drown box which allows users to select the engineer in charge of that task. You can make up 4 names for the list of engineers. Difference in Projected - There should be a formula to calculate the difference in the approx. and actual costs. a. Using conditional formatting i. If the task actually costs more than $250 of the approximate cost the cell should be highlighted red with red text. ii. If the tasks was more than $2.50 cheaper than the approximated cost the cell should be highlighted green with green text. 5. Add a Total Project Cost and Total Difference in Project Costs cell

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Integrated Audit Practice Case

Authors: David S. Kerr, Randal J. Elder, Alvin A. Arena

6th Edition

ISBN: 0912503564, 9780912503561

Students also viewed these Accounting questions

Question

4. Identify cultural variations in communication style.

Answered: 1 week ago

Question

9. Understand the phenomenon of code switching and interlanguage.

Answered: 1 week ago

Question

8. Explain the difference between translation and interpretation.

Answered: 1 week ago