\begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline 1 & Product & Sales Count & Unit Production Cost & Unit Market Price & Unit Profit & Total Profit & Q\# & Question Text \\ \hline 2 & Jeans & 5000 & 8 & 21 & & & 1 & Calculate unit profit using subtraction operator per product. \\ \hline 3 & T-shirts & 3000 & 7 & 16 & & & 2 & Calculate total profit using unit profit per product. \\ \hline 4 & Sweaters & 2000 & 6 & 17 & & & 3 & Calculate average total profit at the end of the Total Profit column using AVERAGE function. Allow only 2 digits after decimal point. \\ \hline 5 & Backpacks & 1500 & 16 & 26 & & & 4 & Color the cells in Total Profit column to the red if its total profit is less than the average using conditional formatting. \\ \hline 6 & Laptops & 7000 & 4 & 9 & & & 5 & Draw a chart for Product in X axis and Unit Profit in y axis. \\ \hline 7 & Headphones & 2500 & 16 & 21 & & & & \\ \hline 8 & Tablets & 4000 & 6 & 14 & & & & \\ \hline 9 & Smartwatches & 1800 & 15 & 30 & & & & \\ \hline 10 & Sneakers & 4000 & 5 & 14 & & & & \\ \hline 11 & Dresses & 3500 & 12 & 29 & & & & \\ \hline 12 & Swimwear & 2500 & 16 & 29 & & & & \\ \hline 13 & Sunglasses & 1200 & 3 & 22 & & & & \\ \hline 14 & Hiking Boots & 3500 & 7 & 26 & & & & \\ \hline 15 & Tent & 2000 & 19 & 27 & & & & \\ \hline 16 & Ski Jackets & 4500 & 7 & 14 & & & & \\ \hline 17 & & & & & Avg. Total Profit= & & & \\ \hline \end{tabular}