Instruction:

Input all the sheets from D$02\_$Internal$\_$Control.xlsx using Input Data tool and Dynamic Input tool. $($You can find Instructions from the recorded Alteryx$1$ In$-$class practice$)$

Add a Count Records tool after the Dynamic Input tool.

Add a Browse tool after the Dynamic Input tool.

Run the workflow and check whether it is successful.

Add an Output Data tool after the Dynamic Input tool. Write the whole data to an Alteryx Database file $(-$yxdb$)$ and name it as $"$D$02\_$Internal$\_$Control$\_$New".

Run the workflow and check whether it is successful.

Answer the following questions:

Q$1$: How many sheets are in the excel file D$02\_$Intemal$\_$Control.xlsx$?$ Answer: $()$

Q$2$: What is the total number of records after inputting all the sheets from D$02\_$Intemal$\_$Control.xlsx$?$

Answer: $()$

Q$3$: In this database, what is the median of AuditFee and what is the standard deviation of AuditFee?

Answer: median $()$; standard deviation $()$

Q$4$: How many unique auditors are in this database $($auditor$)?$

Answer: $()$

Q$5$: What is the percentage of Empty value for the column Reason$\_$AccountRule$\_$keys?

Answer: $()$

$7.$ Don't forget to save this workflow $($Ctrl$+$S$).$