Excel Assignment 3 PDF

Preview

Summary

excel...

Description

ACC 356 Excel Problem #3 Download the article “Vigilant Spreadsheet” AND Excel File Lab 3 from EMU Online Excel Skills: Sorting, SUMIF, COUNTIF, and Conditional Formatting 1. Add the conditional formatting (on the home tab) to the information in the Part 1 tab: a. Column D – Population – all population greater than 10 b. Column G – Percent not covered by health insurance- between 5 and 10. Choose a different formatting than “a” above. c. Column J – Percent of Population over 65 – choose those states above average and use “top/bottom rules” 2. In cell G53 use the COUNTIF function to count the number of states that have 10 percent or less not covered by health insurance. 3. In cell H53, use the SUMIF function to sum the total number of institutions of higher education (column h) if a state has greater than 50 institutions in it. 4. In cell H54, use the SUMIF function to sum the number of institutions of higher education (column h) if the state is in the Northwest region. 5. Go to the Part 2 tab and sort this spreadsheet once. Using the custom sort, the first sort should be ascending order by Institutions of Higher Education (Column H) with the second sort should be Percent not Covered by Health Insurance (Column G) in descending order. 6. Save your spreadsheet and call it “yourlastnameExcel3” 7. Upload your completed spreadsheet into EMU Online by 10 minutes prior to the start of class: 8. The 15 points for this assignment will be allocated as follows: a. Conditional Formatting Column D 2 b. Conditional Formatting Column G 2 c. Conditional Formatting Column J 2 d. COUNTIF in cell G53 2 e. SUMIF in Cell H53 2 f. SUMIF in Cell H54 2 g. Sorting in Tab 2 Properly 2 h. Name the worksheet properly 1

Excel Assignment 3 Grading Form

Total Possible Points Conditional Formatting Column D correct Conditional Formatting Column G correct and different color Conditional Formatting Column J correct and custom formatting COUNTIF in cell G53 correct answer SUMIF in Cell H53 correct answer SUMIF in Cell H54 correct answer Sorting in Tab 2 Proper Spreadsheet named with students last name Total Points 15

Your Points 2 2 2 2 2 2 2 1...