(Solved): Go to the Original Content worksheet, which lists movies and TV shows that VSS is developing itself ...

Go to the Original Content worksheet, which lists movies and TV shows that VSS is developing itself and indicates whether each project is approved for production. Bao wants to list the approved projects in a separate part of the worksheet. Use an advanced filter as follows to list these projects in a new range: In cell F26, type Yes as the value to filter on in the criteria range. Create an advanced filter using the Projects table (range A1:F23) as the List range. Use the range A25:F26 as the Criteria range. Copy the results to another location, starting in the range A28:F28. Insert a table using the range A28:F36 as the data and specifying that the table has a header row. Filter the new table to display only data for TV shows.

c. In the Power Query Editor window, choose to close and load to a location in the worksheet. [MAC Hint: Use Text Import Wizard to import data as tab delimited text.] d. Vlew the imported data as a table and insert the data in cell \( \mathbf{H 5} \) of the existing worksheet. [MAC Hint: Import data as text and update the table name from "Table_2" to "Support_EX365_2021_CS4_7a_Medla".] e. Apply Blue, Table Style Medium \( \mathbf{2} \) to the imported table to coordinate with the rest of the worksheet contents. [MAC Hint: Format as Table using Blue, Table Style Medlum 2.] 13. Bao decides that he might want to sort and filter the revenue data. Format the range A5:F12 as a table with headers. 14. Go to the Original Content worksheet, which lists movles and TV shows that VSS Is developing itself and indicates whether each project is approved for production. Bao wants to list the approved projects in a separate part of the worksheet.| Shelly Cashman Excel 365/2021 | Modules 47: SAM Capstone Project la Use an advanced filter as follows to list these projects in a new range: a. In cell F26, type Yes as the value to filter on in the criteria range. b. Create an advanced fliter using the Projects table (range \( \mathbf{A 1 : F 2 3} \) ) as the List range. c. Use the range \( \mathbf{A 2 5 : F 2 6} \) as the Criterla range. d. Copy the results to another location, starting in the range \( \mathbf{A 2 8 : F 2 8 .} \) e. Insert a table using the range A28:F36 as the data and specifying that the table has a header row. f. Filter the new table to display only data for TV shows. 15. VSS wants to delay the development of dramas that have not been approved because dramas have not been selling well. Bao asks you to identify these projects on the Original Content worksheet. Add a column to the Projects table and determine which projects meet the criterla as follows: a. Add a column to the right of the Approved? column. b. Type Delay? as the column heading. c. 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. 14 16. Bao asks you to identify the projects with budgets of \( \$ 25,000 \) or more, those with budgets of \( \$ 15,000 \) or more, and those with budgets less than \( \$ 15,000 \). a. In the Budget column (range E2:E23), create a new Icon Set Conditional Formatting rule using the \( \mathbf{3} \) Symbols (Circled) indicators. b. Display the green circled symbol in cells with a Number type value greater than or equal to 25000.