$1.$ Looking at sheet $2,$ how may sales orders did Arkansas $($AR$)$ customers have?

$2.$ Looking at sheet $2,$ what was the grand total quantity sold $($across all states and all products$)$

$3.$ Add state to your results in Sheet $1($examining null values$).$ Which state has the highest number of customers who haven't placed orders? MO

$4.$ Remove the filter from Sheet $1$ so that you are not only seeing null values. How many orders have Beverage Distributors placed?

$5.$ Looking at Sheet $2,$ how many Imperial IPAs were ordered by customers in Kansas $($KS$)?$