table shows the price per roll depending on order size:

Quantity Ordered

$\backslash$begin$\{$tabular$\}\{|$r$|$r$|$r$|\}$

$\backslash$hline From & $\backslash$multicolumn$\{1\}\{|$c$|\}\{$ To $\}$ & Price per Roll $\backslash \backslash$

$\backslash$hline $1$ & $100$ & $\backslash (\backslash$$ $210\backslash )\backslash \backslash$

$\backslash$hline $101$ & $150$ & $\backslash (\backslash$$ $185\backslash )\backslash \backslash$

$\backslash$hline $151$ & $250$ & $\backslash (\backslash$$ $170\backslash )\backslash \backslash$

$\backslash$hline $251$ & and up & $\backslash (\backslash$$ $150\backslash )\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$

The file RSR contains $172$ orders that have arrived for the coming six weeks.

$($a$)$ Use the VLOOKUP function with the preceding pricing table to determine the total revenue $($in dollars$)$ from these orders.

$\backslash$$

$($b$)$ Use the COUNTIF function to determine the number of orders in each price bin.

Quantity Ordered

$\backslash$begin$\{$tabular$\}\{|$r$|$r$|$r$|$r$|\}$

$\backslash$hline From & $\backslash$multicolumn$\{1\}\{|$c$|\}\{$ To $\}$ & Price per Roll & Number of Orders $\backslash \backslash$

$\backslash$hline $1$ & $100$ & $\backslash (\backslash$$ $210\backslash )$ & $\backslash \backslash$

$\backslash$hline $101$ & $150$ & $\backslash (\backslash$$ $185\backslash )$ & $\backslash \backslash$

$\backslash$hline $151$ & $250$ & $\backslash (\backslash$$ $170\backslash )$ & $\backslash \backslash$

$\backslash$hline $251$ & and up & $\backslash (\backslash$$ $150\backslash )$ & $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$