MOS Excel 2019 | Module 6: SAM Project 1b Go to the Proposed Articles worksheet, which lists articles that have been proposed for publication in September. Jack suspects the ProposedArticles table has a duplicate record. Identify the duplicate as follows: a clear the filter from the ProposedArticles table to display all the records. b. In the range A2:A16, create a Conditional Formatting Highlight Cells Rule that displays cells with duplicate values using Light Red Fill with Dark Red Text. c. Delete the second instance of the duplicate record so that you can summarize the data accurately. Jack includes photos with all articles, but he asks a graphic artist to create additional illustrations such as charts and infographics for feature stories longer than 400 words. Add a column to the ProposedArticles table, and determine which articles meet the criteria as follows: a. In cell Hi, type Extra Art as the column heading. b. In cell H2, enter a formula using the AND function that includes structured references to display TRUE if an article has a [Number of Words] value >400 and an [Article Type) of "Feature". Fill the range H3:H15 with the formula in cell H2 if Excel does not do so automatically 10. Add a Total Row to the Proposed Articles table, which automatically counts the number of Extra Art values. Using the total row, display the sum of the payment amounts. Jack asks you to identify the articles that contain 500 words or more, those that contain 400 words or more, and those that contain less than 100 words. In the Number of Words column (range 02:015), create a new Icon Set Conditional Formatting rule using the 3 Traffic Lights (Rimmed) Icons b. Reverse the icon order. c. Display the red traffic light icon in cells with a Number type value greater than or equal to 500. d. Display the yellow traffic light icon in cells with a Number type value greater than or equal to 400. e. Display the green traffic light icon in cells with a Number type value less than 400. 12. Add alt text to the "Number of Words per Article" chart that reads as follows: A 2-D Clustered Bar Chart representing the number of words per blog article. 13. Jack has applied a conditional formatting rule to the range G2:15 using Blue Gradient Fill data bars to compare the funding amounts visually. He doesn't feel that the visual adds much to the presentation. Remove the conditional formatting from the range G2:15. 14. Wrap the text in cell K1 to display the complete contents of the cell. ere to search