n range P$3$:P$6,$ use a function to determine the number of orders placed for each product.

$2.$ In range Q$3$:Q$6,$ use a function to determine the total number of units sold for each product.

$3.$ In range R$3$:R$6,$ use a function to determine the average revenue for each product.

$4.$ In range S$3$:S$6,$ use a function to determine the highest amount sold for each widget.

$5.$ In range T$3$:T$6,$ use a function to determine the lowest amount sold for each widget.

$6.$ In range P$10$:R$14,$ use a function to determine the number of orders placed, total number of units sold,

and average revenue for Widget A based on the salesperson.

$7.$ In range P$17$:R$21,$ use a function to determine the number of orders placed, total number of units sold,

and average revenue for Widget B based on the salesperson.

$8.$ In range P$24$:R$28,$ use a function to determine the number of orders placed, total number of units sold,

and average revenue for Widget C based on the salesperson.

$9.$ In range P$31$:R$35,$ use a function to determine the number of orders placed, total number of units sold,

and average revenue for Widget D based on the salesperson.

$10.$ In cell Q$37$ use a function to input the current date and time to reflect when calculations were

completed.