NEED ASAP

Let's see just how much time Pivot Tables save. Below is a table of Sales Data. Complete the table to the right by writing Excel functions that will find the Sum and Average based on two conditions. After manually writing the formula, generate two Pivot Tables based on the original table of data (B13:E35) and place them in L13 and L26. The Pivot Table in L13 should be made to look similar to your Sum Table, summarizing the sum of Date by Region. Your Pivot Table in L26 should be made to look similar to your Average Table, summarizing the average of Sales Rep by Region. In the 'Sum Table' find the sum for a given date in a specific region. In the 'Average Table', find the average for a given Sales Representative based on a specific region. This is called a Cross Tabulated Table. For full credit, turn off the Grand Totals for Rows and Columns and adjust the number formatting to be in Dollars with o decimal points. A B D E F G H Sum Table Date/Region Northwest Southwest West 10/18/20 10/19/20 10/20/20 10/22/20 10/23/20 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Date Region SalesRep Sales 10/19/20 Northwest Fran $196 10/19/20 Northwest Rin $373 10/19/20 Southwest Rin $934 10/18/20 West Rin $795 10/18/20 Northwest Rin $517 10/19/20 West Fran $2,342 10/18/20 West Whitney $699 10/23/20 Southwest Fran $768 10/23/20 West Rin $1,299 10/23/20 Northwest Jude $791 10/18/20 Northwest Whitney $1,158 10/22/20 Southwest Rin $1,040 10/18/20 Northwest Fran $1,096 10/22/20 Northwest Rin $1,272 10/22/20 West Jude $1,441 10/23/20 Northwest Fran $267 10/22/20 Southwest Fran $1,223 10/18/20 West Fran $266 10/20/20 Northwest Jude $972 10/18/20 West Jude $2,011 10/22/20 Northwest Jude $222 10/22/20 West Jude $532 Average Table SalesRep/Region Northwest Southwest West Fran Jude Rin Whitney 31 32 33 34 35 36 Let's see just how much time Pivot Tables save. Below is a table of Sales Data. Complete the table to the right by writing Excel functions that will find the Sum and Average based on two conditions. After manually writing the formula, generate two Pivot Tables based on the original table of data (B13:E35) and place them in L13 and L26. The Pivot Table in L13 should be made to look similar to your Sum Table, summarizing the sum of Date by Region. Your Pivot Table in L26 should be made to look similar to your Average Table, summarizing the average of Sales Rep by Region. In the 'Sum Table' find the sum for a given date in a specific region. In the 'Average Table', find the average for a given Sales Representative based on a specific region. This is called a Cross Tabulated Table. For full credit, turn off the Grand Totals for Rows and Columns and adjust the number formatting to be in Dollars with o decimal points. A B D E F G H Sum Table Date/Region Northwest Southwest West 10/18/20 10/19/20 10/20/20 10/22/20 10/23/20 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Date Region SalesRep Sales 10/19/20 Northwest Fran $196 10/19/20 Northwest Rin $373 10/19/20 Southwest Rin $934 10/18/20 West Rin $795 10/18/20 Northwest Rin $517 10/19/20 West Fran $2,342 10/18/20 West Whitney $699 10/23/20 Southwest Fran $768 10/23/20 West Rin $1,299 10/23/20 Northwest Jude $791 10/18/20 Northwest Whitney $1,158 10/22/20 Southwest Rin $1,040 10/18/20 Northwest Fran $1,096 10/22/20 Northwest Rin $1,272 10/22/20 West Jude $1,441 10/23/20 Northwest Fran $267 10/22/20 Southwest Fran $1,223 10/18/20 West Fran $266 10/20/20 Northwest Jude $972 10/18/20 West Jude $2,011 10/22/20 Northwest Jude $222 10/22/20 West Jude $532 Average Table SalesRep/Region Northwest Southwest West Fran Jude Rin Whitney 31 32 33 34 35 36