(a) Using the IF or IFS function, write a formula in F15 to determine the activity status. Use the As on Date value given in cell E11. Copy the formula to cells F16 to F23.Screenshots attachedthanks ABDF1 You are creating a simple project tracking template to help you understand the current project status on a given date.2 Table 2 has the project activities, the project is going as per the planned start and end date, and there is no deviation.3 Any activity has three statuses, viz. Completed, In-progress, and not started.4 An activity's status is (i) Completed if "As on Date" > End Date (ii) In-progress if Start Date <= "As on Date" and End Date >= "As on Date" (iii) "Not Started" if Start Date > "As on Date".56910(a) Using the IF or IFS function, write a formula in F15 to determine the activity status. Use the As on Date value given in cell E11. Copy the formula to cells F16 to F23.(b) Apply conditional formatting to the status column.(i) If the Status text is Completed, then apply "Highlight Cell Rules", "Text that contains" with "Green Fill with Dark Green Text".(ii) If the Status text is In-Progress, then apply "Highlight Cell Rules", "Text that contains" with "Yellow Fill with Dark Yellow Text".(iii) If the Status text is "Not started" then apply "Highlight Cell Rules", "Text that contains" with Custom format, Grey fill (it can be any grey color of your choice).You are analyzing the budget overrun for the activities; this analysis is not helpful for an activity that is not yet completed; hence you decide to assign "NA" for such activities.An activity has overshot the budget if (i) it is completed and (ii) Actual Amount spent on the activity > Budget Allocated.7An activity is within Budget if (i) it is completed and (ii) Actual Amount spent on the activity < Budget Allocated.8 (c) Using the IF or IFS function, write a formula in 115 to determine if the activity has overshot its budget. Copy the formula to cells 116 to 123.(d) Apply conditional formatting to the Budget status column.(i) If the Budget Status text is Overshot, then apply "Highlight Cell Rules", "Text that contains" with Custom format and fill with "Red Color" (Any red color of your choice).(ii) If the Budget Status text is Within Budget then apply "Highlight Cell Rules", "Text that contains" with Custom format and fill with "Green Color" (Any green color of your choice).1112GAs on DateH2/12/2021KLM 910111213ABDEFHJYou are analyzing the budget overrun for the activities; this analysis is not helpful for an activity that is not yet completed; hence you decide to assign "NA" for such activities.An activity has overshot the budget if (i) it is completed and (ii) Actual Amount spent on the activity > Budget Allocated.An activity is Within Budget if (i) it is completed and (ii) Actual Amount spent on the activity < Budget Allocated.78 (c) Using the IF or IFS function, write a formula in 115 to determine if the activity has overshot its budget. Copy the formula to cells 116 to 123.(d) Apply conditional formatting to the Budget status column.(i) If the Budget Status text is Overshot, then apply "Highlight Cell Rules", "Text that contains" with Custom format and fill with "Red Color" (Any red color of your choice).(ii) If the Budget Status text is Within Budget then apply "Highlight Cell Rules", "Text that contains" with Custom format and fill with "Green Color" (Any green color of your choice).1415161718192021222321As on DateActivity Activity descriptionABсDEFGHIDetermine user needsReview software and languagesPurchase softwareDesign format and style.Write programsReview outcome product with userMake revisionsSelect server siteInstall on server and test2/12/2021Table 2: Activity Status of the projectStart Date2/1/20212/1/20212/3/20212/4/20212/7/20212/12/20212/13/20212/13/20212/15/2021End Date2/3/20212/3/20212/4/20212/7/20212/12/20212/13/20212/15/20212/14/20212/17/2021StatusBudgetAllocated$$$$$ 1,000 $200 $250 $99 $250 $100 $200 $500 $200 $$$$$ActualAmountSpent1201504452501,100100-KBudget StatusL

Required Formula is: =IFS($D$11>E15, "Completed", AND(D15<=$D$11, E15>=$D$11),…

Answered: Using the IF or IFS function, write a…

Using the IF or IFS function, write a formula in F15 to determine the activity status. Use the As on Date value given in cell E11. Copy the formula to cells F16 to F23.

Database Systems: Design, Implementation, & Management

12th Edition

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Carlos Coronel, Steven Morris

Chapter9: Database Design

Section: Chapter Questions

Problem 6P

See similar textbooks

Similar questions

Complete a detailed activity "DIAGRAM" You will be using the Basic COCOMO Model for quick and rough estimates. The Basic COCOMO Model is broken into three different (organic, semi-detached, and embedded) categories. Boehm's definition of organic, semi- detached, and embedded systems is as follow: 1. Organic - A software project is said to be an organic type if the team size required is adequately small, the problem is well understood and has been solved in the past and also the team members have a nominal experience regarding the problem. 2. Semi-detached - A software project is said to be a Semi-detached type if the vital characteristics such as team-size, experience, knowledge of the various programming environments lie in between that of organic and Embedded. The projects classified as Semi-Detached are comparatively less familiar and difficult to develop compared to the organic ones and require more experience and better guidance and creativity. For instance, compilers or…
Assignment Choose one of the following system (ATM, pharmacy, food ordering system, or library) Each student should perform the following tasks in his/her project: 1- Identify the problem, objectives, and methodology to be used 2- Determine the functional and non- functional requirements. Also, determine the type of collecting the requirements 3- Select suitable Model 4- Draw use case and Sequence Diagram
A company has a number of employees. The attributes of FEMPLOYEE include Employee io (identifier), Name, Address, and Birthdate. The company also has several prolects. Attributes of (PROJECT include Project ID (identfier), Project Name, and Start Date. Each employee maybeassigned tp one or more projects or may not be assigned to a project. A project must have at least one emplovee assigned and may have any number of employees assigned. An employee's billing rate may vary by project, and the company wishes to record the applicable billing rate (Billing Rate) for each employee when assigned to a particular project. A). Draw ER Model For the companyB). Do the attribute names in this description follow the guidelines for naming attributes? If not, suggest better names.C). do you have any associative entities on your ERD? If so, what are the identifers for those associative entities?
A company has a number of employees. The attributes of FEMPLOYEE include Employee io (identifier), Name, Address, and Birthdate. The company also has several prolects. Attributes of (PROJECT include Project ID (identfier), Project Name, and Start Date. Each employee maybeassigned tp one or more projects or may not be assigned to a project. A project must have at least one emplovee assigned and may have any number of employees assigned. An employee's billing rate may vary by project, and the company wishes to record the applicable billing rate (Billing Rate) for each employee when assigned to a particular project. A. Draw ER Model For the company B. Do the attribute names in this description follow the guidelines for naming attributes? If not, suggest better names. C. to youhave any associative entities on your ERD? If so, what are the identifers for those associative entities?
SDLC - Requirement Analysis For your course project you will specify the requirements. In this assignment you will produce the first deliverable for your course project, the requirements specification. The purpose of this assignment is for you to learn how to write a complete and precise requirements specification, which is the first step in developing a large software system. The teaching assistant is your customer, and he would like you to build a text editing system with the following features: Text Editing System A software system is desired for creating, storing, retrieving and modifying files of text. The text editing system will be accessible through a full-screen interface for interactive editing. The system will support a variety of editing commands, including inserting and deleting lines, modifying text in existing lines, and searching for text. You as the supplier are responsible for building a software system that meets the needs of your customer. However, they…
Section C. Research scenarios. Read the following scenario describing a research project, and then write a short criticism of this project. You should clearly identify at least four aspects of the project which you believe are incorrect or poor. These may relate to the research question, the experimental design, the analysis and reporting, and/or any ethical or academic misconduct issues. For each criticism which you identify, clearly describe the problem and state how it should have been addressed to improve the quality of the research. Question 15. A company providing on-line teaching software claims that students who are on-line students achieve better results on learning programming languages than on campus students. The company has developed a hypothesis based on this claim. The company chose one university to conduct research to test this hypothesis. The company applied for research ethics clearance and was granted it. At the end of semester, both on-line and on campus students…
As a project manager of a Software project, you have received given data about the different type of Issues identified in the project: – Issue 1 – 85 occurrences; Issue 2 – 125 occurrences; Issue 3 – 28 occurrences; Issue 4 – 395 occurrences; Issue 5 – 185 occurrences; Issue 6 – 128 occurrences; Issue 7 – 85 occurrences; Issue 8 – 169 occurrences; Issue 9 – 148 occurrences; Issue 10 – 209 occurrences. Which diagram you will use to prioritize the Issues? Generate the diagram using any tool and paste it here.
Venn Diagram for "Ideating" Project. Indicate the Sustainable Development Goal on the right, the Technology(ies) on the left and the name of the Solution in the Center.
What is a SELECT and a PROJECT operation?
ERD Case: A Project ID identifies each project. Each project is also given a short title that may or may not be unique and may be given a longer description. A project manager must manage each project and may have many team members assigned to work on it. Some of the team members may work on more than one project. The project has a start date and scheduled completion date. The project also has a total estimated cost. Employee ID identifies people in the company, although the project manager needs to know the name, phone number and e-mail address assigned to each member of his/her team. The project manager also needs to know when an employee is officially assigned to a project and when is relieved from a project. An employee can be a full-time employee or a part-time employee. For a full-time employee, information on the medical benefit provided by the company to the employee is kept. For a part-time employee, information on the contact term and duration is kept. Each project consists…
with a suitable example explain the difference in how is a project different from a program. Using the selected example provide details on which will constitute a project and which one to a program?
GCS has many customers. Each customer has a customer ID, name, phone number, and region. GCS works by projects. A project is based on a contract between the customer and GCS to design, develop, and implement a computerized solution. Each project has specific characteristics such as the project ID, the customer to which the project belongs, a brief description, a project date (the date the contract was signed), an estimated project start date and end date, an estimated project budget, an actual start date, an actual end date, an actual cost, and one employee assigned as the manager of the project. The actual cost of the project is updated each Friday by adding that week’s cost to the actual cost. The week’s cost is computed by multiplying the hours each employee worked by the rate of pay for that skill. The employee who is the manager of the project must complete a project schedule, which effectively is a design and development plan. In the project schedule (or plan), the manager must…