Use Microsoft Excel and the EduToys Database Access file to complete the tasks that follow. (You do not need Microsoft Access to complete this problem.) The solution should include a separate worksheet for each question. Please answer each question by applying formulas, functions, tables, and/or PivotTables as appropriate.
1) How do EduToys’s past customers break down by age and gender?
2) Which of EduToys’s past customers have spend amounts that fall in the top 20% of all transactions (as measured in dollars)? Report the first name, last name, street address, city, state, and zip code for each of these customers.
3) Which products have generated sales revenues (in dollars) that fall in the top 25% of all such revenue contributions? Report the current inventory level, quantity on order, and supplier of each of these best-selling products.
4) How do the given 1998 sales (in dollars) break down by product type and product age group?
5) What proportion of all given transactions were conducted through the use of each type of
credit card (including American Express, Discover, MasterCard, and Visa)?
6) What changes or additions would you recommend making to the present database? Provide
the reasoning behind each of your recommendations.
For each item, include one or more comments that summarize the findings. Please
submit the solution in one or more neatly organized and clearly labeled spreadsheets.