Question

In the Database sheet, enter conditions in the criteria range for unoccupied two- and three-bedroom apartments that need to be remodeled. Enter criteria as text only, without use of quotation marks. Be sure to enter the criteria separately in rows 3 and 4.

Answer 1

To specify conditions for unoccupied two- and three-bedroom apartments needing remodeling in a Database sheet, enter criteria textually, such as the number of bedrooms, occupancy status, and remodeling needs, in separate rows for two- and three-bedroom options, without using quotation marks.

Step-by-step explanation:

To enter conditions in the criteria range for unoccupied two- and three-bedroom apartments that need to be remodeled, you would create a set of criteria in the Database sheet of your spreadsheet software. This would involve entering criteria in separate rows to represent each set of conditions you're looking for.

For unoccupied two-bedroom apartments that need remodeling, your criteria might look something like this:

Bedrooms: 2

Status: Unoccupied

Needs Remodeling: Yes

Then, for unoccupied three-bedroom apartments that need remodeling, the criteria would be entered on the subsequent row:

Bedrooms: 3

Status: Unoccupied

Needs Remodeling: Yes

Remember to enter the criteria as text only, without the use of quotation marks, and to place each condition on separate rows as instructed.

Answer 2

See attachment fir procedures to get answers.

Step-by-step explanation:

Given that;

In the Database sheet, enter conditions in the criteria range for unoccupied two- and three-bedroom apartments that need to be remodeled. Enter criteria as text only, without use of quotation marks. Be sure to enter the criteria separately in rows 3 and 4.

See attachment