Solved: Excel Assignment 2 Download the article “Vigilant Spreadsheet” AND Exc

Question

Excel Assignment 2 Download the article “Vigilant Spreadsheet” AND Excel Assignment Summer 2024 file from EMU Canvas Excel Skills: Sorting, SUMIF, COUNTIF, and Conditional Formatting Add the conditional formatting (on the home tab) to the information in the Part 1 tab: Column C – Area in sq miles – less than 10,000 Column E – Males per 100 females - between 95 and 99. Choose a different formatting than “1a” above. Column G – Percent not covered by health insurance –top 10% using the “top/bottom rules”. Choose a different format than 1a and 1b. In cell J53 use the COUNTIF function to count the number of states that have “Percent of Population over 65” (column J) less than or equal to 12 percent. Format with no decimal places. In cell L53, use the SUMIF function to sum the total number of births (column L) if a state has greater than or equal to 200,000. Format with “,” and no decimal places. In cell M53, use the SUMIF function to sum the number of marriages (column M) if the state is in the Midwest region. Go to the Part 2 tab and sort this spreadsheet once. Using the custom sort, the first sort should be descending order by Region (Column B) with the second sort should be State (Column A) in ascending order. Save your spreadsheet and call it “yourlastnameExcel2” Upload your completed spreadsheet into Canvas.