I need the formulas to enter for the blank table. The numbers change and dates as well as some cells have $"$no data"

"Use the data provided in the left$-$most table to complete the worksheet, filling in each of the blue$-$shaded cells with a FORMULA that will calculate the correct answer. Make sure you copy your formulas all the way down to the row where there is a marker to stop. Format values appropriately $($monetary values should be represented as currency, percentages as percentage$-$formats, only relevent number of decimals should be shown, etc.$)$

If it is not possible to calculate a particular value because data is missing in that row, use an IF function to avoid the calculation and place a hyphen $(""-"")$ in the cell instead. DO NOT USE THE IFERROR$()$ FUNCTION! $"$ In the "data break$-$out table" below, use IF$()$ functions to copy the TOTAL VALUE OF SALES data from the original data, breaking it up by department. You will then use these columns of data to calculate the summary statistics. $($Note that the order of the departments will match the column headings.$)$

DATA BREAK$-$OUT TABLE SUMMARY STATISTICS TABLE

ANSWER THESE QUESTIONS... BY COMPOSING FORMULAS IN THIS COLUMN GROCERIES OUTDOORS ELECTRONICS CLOTHING GROCERIES OUTDOORS

N:

$1$ HOW MANY EMPLOYEES DO YOU HAVE? $104$ TOTAL:

MIN:

$2$ WHAT IS THE AVERAGE NUMBER OF SALES ACROSS ALL EMPLOYEES? $40\mathrm{.}47$ MAX:

RANK $($based on total$)$:

$3$ WHAT IS THE AVERAGE VALUE OF INDIVIDUAL SALES ACROSS ALL EMPLOYEES? $24\mathrm{.}39$