(c) Using the IF or IFS function, write a formula in I15 to determine if the activity has overshot its budget. Copy the formula to cells I16 to I23.Thankyouzzz screenshots attached 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 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

If the the actual amount spent is more than the budget allocated then we can change the budget…

Answered: write a formula in I15 to determine if…

write a formula in I15 to determine if the activity has overshot its budget

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

Similar questions

Question 65
p.77, icon at Example 6 #5. Determine whether this argument is valid: Lynn works part time or full time. If Lynn does not play on the team, then she does not work part time. If Lynn plays on the team, she is busy. Lynn does not work full time. Therefore, Lynn is busy.
10. Using the INDEX function only, write a formula in cell H10 to find the state name having the minimum "Sum of Percentage". The formula should include the value(row number) that is calculated in G10. Thank you screenshot attached
Question (3): Draw a flowchart to calculate the average of 30 exam scores in computer science lab.
Create flow chart to print the result of 25 students in a class. Assume that each student has 4 grades. Find the average of the grades. If it is greater than or equal to 50 then display the student is passed otherwise student is failed. Print the result and average for 25 students.
What is the difference between algorithm and flow chart. Draw a flowchart for the algorithm to calculate the percetage marks obtained by the student in this examination and then to print it along with his/her roll number and na
Q3) Plot the following functions on the same figure for x values from -nt to n, (selecting spacing 0.01), with subdivide a figure window into three rows and one column. yl = sin (x) y2 = sin (2r) y3 = sin (3x)