Question
Please help me with my excel. EX16_XL_CH07_GRADER_CAP_HW - Apartment Complex 1.9 What are the solutions for questions 7-10? 7 In the Database sheet, enter conditions
Please help me with my excel.
EX16_XL_CH07_GRADER_CAP_HW - Apartment Complex 1.9
What are the solutions for questions 7-10?
| 7 | 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. |
| 8 | Apply an advanced filter based on the criteria range (A2:H4). Filter the existing database (range A15:H65) in place. Nine apartments meet the advanced filter conditions. |
| 9 | In cell C8, use the DCOUNTA database function to calculate the number of apartments that need to be remodeled based on the advanced filter you created. |
| 10 | In cell C9, enter a database function to calculate the total value of monthly rent lost for the apartments that need to be remodeled based on the advanced filter you created. |
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
SQL Server 2019 Administrator S Guide A Definitive Guide For DBAs To Implement Monitor And Maintain Enterprise Database Solutions
Authors: Marek Chmel ,Vladimir Muzny
2nd Edition
1789954320, 978-1789954326
