In cell G2, enter a formula using the AND function that includes structured references to display TRUE if a project has a [Project Type] of "Drama" and an [Approved?] value of "No". Fill the range G3:G23 with the formula in cell G2 if Excel does not do so automatically.
In cell G2, enter a formula using the AND function that includes structured references to display TRUE if a project has a [Project Type] of "Drama" and an [Approved?] value of "No". Fill the range G3:G23 with the formula in cell G2 if Excel does not do so automatically.
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question
- In cell G2, enter a formula using the AND function that includes structured references to display TRUE if a project has a [Project Type] of "Drama" and an [Approved?] value of "No". Fill the range G3:G23 with the formula in cell G2 if Excel does not do so automatically.
![AutoSave
SC EX19_CS4-7a_AlexisDonald_2 -
Search
困
Off
Alexis Donald AD
File
Home
Insert
Page Layout
Formulas
Data
Review
View
Help
Team
Table Design
A Share
P Comments
X Cut
- 11 - A A
2 Wrap Text
Project He.. Stude... Submission
E AutoSum v
Trebuchet MS
Accounting
Percent 2
B Copy
Fill v
Conditional Format as Table Amo... Normal
Formatting
Paste
BIU - R -
= E E Merge & Center v
$ - % , 58 9
Bad
Good
Insert Delete Format
Sort & Find 8&
Analyze
S Format Painter
Table v
O Clear
Filter v Select v
Data
Clipboard
Font
Alignment
Number
Styles
Cells
Editing
Analysis
G2
fe
A
B
D
G
H
J
K
L
M
P
Q
R
ID
Project Name
Project Type
Start Date
Budget
Approved?
Delay?
Project Information
1
2 AC533 Just Spirits
Action movie
6/22
$45,500
Yes
Project ID
TV245
AC210 Tension Sunrise
Action movie
6/22
$12,000
No
Project Name
4
TV453 Against the Wall
TV show
7/22
$22,500
No
Start Date
TV697 Bayridge
TV show
7/22
$28,500
Yes
6 AC328 The Castle Behind Me
Action movie
9/22
$23,010
No
Budget
> 15000
Number of Projects
7 CO720 Mack and Mack
Comedy
9/22
$18,555
No
8 CO789 Space Plum
Comedy
10/22
$25,000
No
9 CO329 Karate Night
Comedy
10/22
$20,000
Yes
10 DR887 Never in Common
Drama
11/22
$19,700
No
11 DR543 All My Friends
Drama
11/22
$12,200
No
Project Type
12 DR521 A Great Getaway
Drama
1/23
$31,500
Yes
Comedy
13 CO325 Teenage Miracle Mile
Comedy
1/23
$24,000
No
Average Budget
14 DR512 The Great Grasshopper Drama
2/23
$12,500
No
15 DR622 Downtown Bike Path
Drama
2/23
$15,000
Yes
Project Type
Number
Total Budget Average Budget
16 TV482 Because of Winston
TV show
3/23
$24,500
No
Action movie
17 AC736 Mad Music
Action movie
3/23
$10,000
No
Comedy
18 AC447 A Slight Case of Spring Action movie
3/23
$15,000
No
Drama
19 TV245 Paradise Moon
TV show
3/23
$14,000
Yes
TV show
20 TV598 Good Gold Bad Blue
TV show
3/23
$22,500
No
21 CO305 Shark Myths
Comedy
4/23
$19,500
Yes
22 CO220 This Guy Laughed
Comedy
4/23
$16,000
No
23 TV552 Celeste and Cecilia
TV show
4/23
$50,000
Yes
24
Approved Projects
25
ID
Project Name
Project Type
Approval Date
Budget
Approved?
26
Yes
27
Project Type
ID -
30 TV697 Bayridge
28
Project Name -
Start Date -
Budget - Approved?
TV show
7/22
$28,500
Yes
34 TV245 Paradise Moon
TV show
3/23
$14,000
Yes
36 TV552 Colecte and Cecilia
TV chow
A123
C50 000
Vor
Documentation
U.S.
Canada
U.K.
All Locations
Original Content
Subtotals
Expansion Funding
Ready
田
100%
3:50 PM
O Type here to search
77°F Cloudy
A G 4)
18
11/1/2021
尔](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F1e53481b-ff63-4ca9-9f12-e0aea550cbeb%2F4dbc7a92-e1c3-4bd9-8b55-901ec6b461d6%2F64l4itn_processed.png&w=3840&q=75)
Transcribed Image Text:AutoSave
SC EX19_CS4-7a_AlexisDonald_2 -
Search
困
Off
Alexis Donald AD
File
Home
Insert
Page Layout
Formulas
Data
Review
View
Help
Team
Table Design
A Share
P Comments
X Cut
- 11 - A A
2 Wrap Text
Project He.. Stude... Submission
E AutoSum v
Trebuchet MS
Accounting
Percent 2
B Copy
Fill v
Conditional Format as Table Amo... Normal
Formatting
Paste
BIU - R -
= E E Merge & Center v
$ - % , 58 9
Bad
Good
Insert Delete Format
Sort & Find 8&
Analyze
S Format Painter
Table v
O Clear
Filter v Select v
Data
Clipboard
Font
Alignment
Number
Styles
Cells
Editing
Analysis
G2
fe
A
B
D
G
H
J
K
L
M
P
Q
R
ID
Project Name
Project Type
Start Date
Budget
Approved?
Delay?
Project Information
1
2 AC533 Just Spirits
Action movie
6/22
$45,500
Yes
Project ID
TV245
AC210 Tension Sunrise
Action movie
6/22
$12,000
No
Project Name
4
TV453 Against the Wall
TV show
7/22
$22,500
No
Start Date
TV697 Bayridge
TV show
7/22
$28,500
Yes
6 AC328 The Castle Behind Me
Action movie
9/22
$23,010
No
Budget
> 15000
Number of Projects
7 CO720 Mack and Mack
Comedy
9/22
$18,555
No
8 CO789 Space Plum
Comedy
10/22
$25,000
No
9 CO329 Karate Night
Comedy
10/22
$20,000
Yes
10 DR887 Never in Common
Drama
11/22
$19,700
No
11 DR543 All My Friends
Drama
11/22
$12,200
No
Project Type
12 DR521 A Great Getaway
Drama
1/23
$31,500
Yes
Comedy
13 CO325 Teenage Miracle Mile
Comedy
1/23
$24,000
No
Average Budget
14 DR512 The Great Grasshopper Drama
2/23
$12,500
No
15 DR622 Downtown Bike Path
Drama
2/23
$15,000
Yes
Project Type
Number
Total Budget Average Budget
16 TV482 Because of Winston
TV show
3/23
$24,500
No
Action movie
17 AC736 Mad Music
Action movie
3/23
$10,000
No
Comedy
18 AC447 A Slight Case of Spring Action movie
3/23
$15,000
No
Drama
19 TV245 Paradise Moon
TV show
3/23
$14,000
Yes
TV show
20 TV598 Good Gold Bad Blue
TV show
3/23
$22,500
No
21 CO305 Shark Myths
Comedy
4/23
$19,500
Yes
22 CO220 This Guy Laughed
Comedy
4/23
$16,000
No
23 TV552 Celeste and Cecilia
TV show
4/23
$50,000
Yes
24
Approved Projects
25
ID
Project Name
Project Type
Approval Date
Budget
Approved?
26
Yes
27
Project Type
ID -
30 TV697 Bayridge
28
Project Name -
Start Date -
Budget - Approved?
TV show
7/22
$28,500
Yes
34 TV245 Paradise Moon
TV show
3/23
$14,000
Yes
36 TV552 Colecte and Cecilia
TV chow
A123
C50 000
Vor
Documentation
U.S.
Canada
U.K.
All Locations
Original Content
Subtotals
Expansion Funding
Ready
田
100%
3:50 PM
O Type here to search
77°F Cloudy
A G 4)
18
11/1/2021
尔
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question
It says that it does not work and I still get an error
Solution
Recommended textbooks for you
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
![Concepts of Database Management](https://www.bartleby.com/isbn_cover_images/9781337093422/9781337093422_smallCoverImage.gif)
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
![Prelude to Programming](https://www.bartleby.com/isbn_cover_images/9780133750423/9780133750423_smallCoverImage.jpg)
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
![Sc Business Data Communications and Networking, T…](https://www.bartleby.com/isbn_cover_images/9781119368830/9781119368830_smallCoverImage.gif)
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY