Database System Concepts
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
Bartleby Related Questions Icon

Related questions

Q: Explain the purpose (and/or how to use) an "added variable
A: Explain the purpose (and/or how to use) an "added variable plot".
Q: 9 10 11 12 13 A B D E F H J You are analyzing the budget overrun for the activities; this analysis…
A: Let's see the answer:
Q: (e) In cell E37, write a formula to compute Total Actual Visitors, copy the formula to cell E38.…
A: e) Formula to be written in E37:  =SUM(C37,D37) Explanation:  Total Actual Visitors = Actual mobile…
Q: (e) In cell E37, write a formula to compute Total Actual Visitors, copy the formula to cell E38.…
A: (e) Formula to enter the cell E37: =SUM(C37,D37) Explanation: The formula does the sum of the mobile…
Q: Ineed help to create a nested formula in cell B17 with the IF and SUM functions that check if the…
A: For the solution of this inquiry let us take an example of relevant datasheet as below : Suppose…
Q: Using a regular expression function, find the first names of students that start with 'B' or 'S' and…
A: Note : Answering the question in python as no programming language is mentioned. Input : Input…
Q: eglecting air friction) is     Gravity on Mars is, g = 3.711 m/sec2.   Create a table of time…
A: g=3.711; d=@(t).5*g*t.^2; %% a t1=(0:10:120)'; dist1=d(t1);…
Q: . Which INT 10h function sets the cursor size?
A: The INT 10h function AH = 01h is used for setting the cursor size.
Q: Create a truth table for each statement. 1. AA ~B 2. ~(~A V B) 3. (A A B) → C 4. (A V B)→ ~C 5.…
A: Introduction to the truth table Logic operations are carried out using truth tables. Boolean algebra…
Q: The following systems flowchart segment depicts a data entry clerk keying data from a source…
A: Answer:The given flowchart is as follows,
Q: You have an equation r = 3*x^2 - 7*x+ 14. Write the MATLAB code to create a symbolic plot of x on…
A: Input : Range of values from -10 to 10. Output : Plot of equation r = 3*x^2 - 7*x + 14 over the…
Q: Purpose: One of the most commonly made decisions is based on comparing the means of multiple…
A: I attached your answer below.
Q: Include a formula in the last column on the third row to calculate 75% of the Cost. The formula is…
A: As you have mentioned that you required for third and fourth column but as I am not having the data…
Question

(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.

Thank

you

z

z

z screenshots attached

9 10 11 12 13 A B D E F H J 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. An activity is Within Budget if (i) it is completed and (ii) Actual Amount spent on the activity < Budget Allocated. 7 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). 14 15 16 17 18 19 20 21 22 23 21 As on Date Activity Activity description A B с D E F G H I Determine user needs Review software and languages Purchase software Design format and style. Write programs Review outcome product with user Make revisions Select server site Install on server and test 2/12/2021 Table 2: Activity Status of the project Start Date 2/1/2021 2/1/2021 2/3/2021 2/4/2021 2/7/2021 2/12/2021 2/13/2021 2/13/2021 2/15/2021 End Date 2/3/2021 2/3/2021 2/4/2021 2/7/2021 2/12/2021 2/13/2021 2/15/2021 2/14/2021 2/17/2021 Status Budget Allocated $ $ $ $ $ 1,000 $ 200 $ 250 $ 99 $ 250 $ 100 $ 200 $ 500 $ 200 $ $ $ $ $ Actual Amount Spent 120 150 445 250 1,100 100 - K Budget Status L
expand button
Transcribed Image Text:9 10 11 12 13 A B D E F H J 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. An activity is Within Budget if (i) it is completed and (ii) Actual Amount spent on the activity < Budget Allocated. 7 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). 14 15 16 17 18 19 20 21 22 23 21 As on Date Activity Activity description A B с D E F G H I Determine user needs Review software and languages Purchase software Design format and style. Write programs Review outcome product with user Make revisions Select server site Install on server and test 2/12/2021 Table 2: Activity Status of the project Start Date 2/1/2021 2/1/2021 2/3/2021 2/4/2021 2/7/2021 2/12/2021 2/13/2021 2/13/2021 2/15/2021 End Date 2/3/2021 2/3/2021 2/4/2021 2/7/2021 2/12/2021 2/13/2021 2/15/2021 2/14/2021 2/17/2021 Status Budget Allocated $ $ $ $ $ 1,000 $ 200 $ 250 $ 99 $ 250 $ 100 $ 200 $ 500 $ 200 $ $ $ $ $ Actual Amount Spent 120 150 445 250 1,100 100 - K Budget Status L
A B D F 1 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". 5 6 9 10 (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. 7 An 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). 11 12 G As on Date H 2/12/2021 K L M
expand button
Transcribed Image Text:A B D F 1 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". 5 6 9 10 (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. 7 An 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). 11 12 G As on Date H 2/12/2021 K L M
Expert Solution
Check Mark
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
See solutionCheck out a sample Q&A here
Comparing the budget allocated with the Actual amount spent
VIEW
Applying the formula
VIEW
bartleby

Step by stepSolved in 2 steps

See solution
Check out a sample Q&A here
Blurred answer
Knowledge Booster
Background pattern image
Computer Science
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education
SEE MORE TEXTBOOKS