Excel worksheets W$1$Q$3\_$A and W$1$Q$3\_$B contain two databases for a local department store. The first is a set of loyal customers indicating their age and gender and the second is a set of sales data from different

departments.

Build one pivot table which calculates minimum and maximum sales by department and customer gender. You will have to combine the data using VLOOKUP or MATCH$/$INDEX$.$ Note any observations you see regarding trends in the results. These observations can be typed as a sentence directly into the Excel workbook. Submit

the assignment by uploading your workbook with the pivot table and your observations.