1) Create defined names for every column on the DAA3 Data worksheet.
2) Use Data Validation to restrict values for the entire Date column (excluding the header row) on the DAA3 Data worksheet to have to be less than or equal to today's date (so that dates which have not occurred yet cannot be entered).
3) Analyzing data from the DAA3 Data worksheet, use reference/lookup formulas to find the following information about the sale where SalesRep5 sold to Cust10 in Region4:
3a) How much was the sale in sales $?
3b) On what date this transaction occur?
3c) Which product was sold?
4) Create two MACROs, one each that captures all of the steps required to answer the questions 4a) and 4b) respectively. Please name your MACROs some variant of "Question 4a" and "Question 4b" so that I know which MACRO replicates the answer to which part of the question.
4a) Create a new column called Gross Profit into the DAA3 Data worksheet. In that column, calculate Gross Profit for each row as Sales - COGS for that row.
4b) Use SUMIFS to populate the B2:E6 array in the cross-sectional table on the DAA3 Table worksheet with total sales by region and product, analzying the data from the DAA3 Data worksheet.