Answered step by step
Verified Expert Solution
Question
1 Approved Answer
display TRUE if a project is a drama and it has not been approved. Fill the formula to the rest of the column, if necessary.
display TRUE if a project is a drama and it has not been approved. Fill the formula to the rest of the column, if necessary.
Bao asks you to identify the projects with budgets of $ or more, those with budgets of $ or more, and those with budgets less than $
In the Budget column, create a new conditional formatting rule using the Symbols Circled icon set. Display the green circled symbol for cells with a number value greater than or equal to the yellow circled symbol in cells with a number value greater than or equal to and the red circled symbol in cells with a number value less than
The Project Information section lists project details, including the ID code that VSS producers use to refer to the projects. Bao wants to find a simple way to look up a project name based on its ID
In the appropriate cell, use a function that looks up the listed project ID in the Projects table, and then returns the corresponding project name as an exact match.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started