\begin{tabular}{|ccc} \multicolumn{3}{c}{ Quantity Ordered } \\ From & To & Price per Roll \\ \hline 1 & 80 & $215 \\ 81 & 160 & $195 \\ 161 & 320 & $175 \\ 321 & and up & $155 \end{tabular} Click on the datafile logo to reference the data. DATA file (a) Use the VLOOKUP function with the preceding pricing table to determine the total revenue from these orders. $710750 (b) Use the COUNTIF function to determine the number of orders in each price \begin{tabular}{|rrr|r} From & To & Price per Roll & Number of Orders \\ \hline 1 & 80 & $215 & 13 \\ \hline 161 & 160 & $195 & 15 \\ \hline 321 & and up & $155 & 37 \\ \hline \end{tabular} \begin{tabular}{|ccc} \multicolumn{3}{c}{ Quantity Ordered } \\ From & To & Price per Roll \\ \hline 1 & 80 & $215 \\ 81 & 160 & $195 \\ 161 & 320 & $175 \\ 321 & and up & $155 \end{tabular} Click on the datafile logo to reference the data. DATA file (a) Use the VLOOKUP function with the preceding pricing table to determine the total revenue from these orders. $710750 (b) Use the COUNTIF function to determine the number of orders in each price \begin{tabular}{|rrr|r} From & To & Price per Roll & Number of Orders \\ \hline 1 & 80 & $215 & 13 \\ \hline 161 & 160 & $195 & 15 \\ \hline 321 & and up & $155 & 37 \\ \hline \end{tabular}