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 [Approved?] value of "No". Fill the range G3:G23 with the formula in cell G2 Excel does not do so automatically.

Answer 1

Answer:

=AND([***at symbol***[Project Type]]="Drama",[***at symbol***[Approved?]]= "No")

Explanation:

This function tests the TRUE/FALSE values returned from;

[Project Type] = "Drama" and [Approved?] = "No"

Only if both values are TRUE, as desired, then TRUE is displayed in the [Delay?] column, otherwise FALSE is displayed

***The (at symbol) is not an allowed character on this website, apologies for any confusion caused***

Answer 2

In this exercise we have to use the knowledge of excel to assemble a formula for the cell, like this:

=AND([***at symbol***[Project Type]]="Drama",[***at symbol***[Approved?]]= "No")

What is Excel formulas?

Excel formulas are functions that can help users of this software to extract as much information from a spreadsheet as possible. This information can be anything from a check of an item, if it is larger than another cell, or a simple average between columns of a spreadsheet.

In this way, we have to write the formula as:

=AND([***at symbol***[Project Type]]="Drama",[***at symbol***[Approved?]]= "No")

See more about excel at brainly.com/question/12788694