Graph Exercise//Excel Spreadsheet for Fund. of Data Management Course

Description

PLEASE DO NOT USE PIVOT TABLES FOR THIS EVEN IF YOU KNOW HOW! PIE CHARTS: Using the function COUNTIFS (not COUNTIF, but PLURAL: COUNTIFS!) and ABSOLUTE REFERENCES and REPLACES – and LOTS OF COPYING! LEAVE FORMULAE IN PLACE Build the PIE charts for UNDERGRADS for each SHSU College representing ethnicity Build the PIE charts for GRADUATES for each SHSU College representing ethnicity Build a PIE CHART (format to show percents), delete title and legend – for each of the 14 tables Create a nice, centrally located legend that all charts use STACKED BAR GRAPHS Using the function COUNTIFS (not COUNTIF, but PLURAL: COUNTIFS!) and ABSOLUTE REFERENCES and REPLACES – and LOTS OF COPYING! LEAVE FORMULAE IN PLACE Build the PIE charts for each SHSU College representing level, build freshmen on bottom – then so-jr-sr-pb-ma-dr (on top). Build individually or all at once Create a nice, centrally located legend that all charts use, if you decide to build these individually. QUESTIONS: Look at the Questions sheet, and answer in the yellow boxes.