Steps to Perform: \begin{tabular}{|c|c|c|} \hline step & Instructions & \begin{tabular}{l} Points \\ Possible \end{tabular} \\ \hline 1 & \begin{tabular}{l} Start Excel. Download and open the file named \\ Excol_.ApplicotionCapstone_Comp_Costumes.xisx. Grader has automatically added your last \\ name to the beginning of the filename.Click.Enable Editing, if nocosstiry. \end{tabular} & 0 \\ \hline 2 & \begin{tabular}{l} On the Sales Data worksheeL, format the data in A10 L 132 as an Excel Table with headers \\ Apply the Blue, Table Style Medium .6. Create named ranges from the table data, using the: \\ headings in A10 L10 \end{tabular} & 7.5 \\ \hline 3 & \begin{tabular}{l} Create an advanced fiker to find all purchases in the table that take place affer september 30 ; \\ 2025(>9/30/2025) Enter the appropriate criteria in cell A2 and fifter the data in-place: \end{tabular} & 3.5 \\ \hline 4 & \begin{tabular}{l} In cell D4. use the SUBrOTAL functicn to calculate the average number of Rainbow \\ costumes sold Format with 0 decimals \end{tabular} & 5 \\ \hline 5 & \begin{tabular}{l} In cell D5, use the suBTOTAL function to calculate the focal number of Basketball costumes \\ sold Format with 0 decimals. \end{tabular} & 5 \\ \hline 6 & \begin{tabular}{l} Insert a sticer for the Month field. Apply Light Blue, Slicer Style Dark 5 . Format the sficer with 4 \\ colurns, and then resize and move the slicer so it covers range M2. R5 (set the slicer within \\ the borders of these cells). In the slicer, select Nowember. \end{tabular} & 3 \\ \hline 7 & \begin{tabular}{l} Using the Exool Toble, create a PivotTable on a new worksheet Rename the worksheet \\ October Analysis. \end{tabular} & 4 \\ \hline 6 & \begin{tabular}{l} Construct the PivotTable to show the total quantity of costumes sold in the Vatues area as the \\ Sum of Hallowoen and the Sum of Christmas. Display these values by date, with the Date fold \\ in the Rows area. If necessary, remove the automatio grouping for Monhs. Rename the label \\ in cell A3 as Date. \end{tabular} & 5 \\ \hline 9 & Rename the column labels as Halloween Costumes and Christmas Costumes: & 2 \\ \hline 10 & \begin{tabular}{l} Grand totals for columns should be included. Fatter the data so only the month of October \\ displays Apply banded rows to the PivotTable, then select the Light Blue. Pwot Style Medium \\ 20 PivotTable Style \end{tabular} & 4 \\ \hline 11 & \begin{tabular}{l} in cel A1, type October Costume Sales, Merge and center A1; C1. Format as Cell Styles. \\ Tite \end{tabular} & 3 \\ \hline 12 & \begin{tabular}{l} Click cell D3, and then type Chart for a new column heading. Apoly the formatfing from cea C3 \\ to D3. Create line sparklines in cell range D4 DS4 fo chart the corresponding data in columns \\ B.C. Include the high point and low point. \end{tabular} & 8 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline Step & Instructions & \begin{tabular}{l} Points \\ Possible \end{tabular} \\ \hline 13 & \begin{tabular}{l} In cell B12 of the Pricing worksheet, insert a function that calculates the average price Carly \\ charges for her costumes. Format as Accounting. \end{tabular} & 5 \\ \hline 14 & \begin{tabular}{l} Create a 2D Column Chart using the average retail price data (A1:B11). Apply Style 15, \\ Colorful Palette 4, and apply Data Labels to the Outside End. \end{tabular} & 9 \\ \hline 15 & \begin{tabular}{l} Position the chart so that the top-left corner is set inside cell D1 and bottom-right corner is set \\ inside cell N21. Add a Primary Vertical axis title of Price and a Primary Horizontal axis title of \\ Costume Type. \end{tabular} & 8 \\ \hline 16 & \begin{tabular}{l} On the Break-Even Analysis worksheet, in cell D9, enter a formula that calculates the gross \\ revenue. In cell D14, enter a formula that calculates the total fixed costs. In cell D17, enter a \\ formula that calculates the total variable costs. In cell D18, enter a formula that calculates the \\ net income. Resize the column as needed. \end{tabular} & 5 \\ \hline 17 & \begin{tabular}{l} Insert a form control scroll bar in E12H13, use 10 as the minimum value, 120 as the \\ maximum value, and the average price as the cell link. Use the scroll bar to find the break- \\ even point for the average price when the average number of costumes sold per day is 10 . \end{tabular} & 9 \\ \hline 18 & \begin{tabular}{l} Use the data in the break-even analysis to complete the two-variable data table in range \\ G4:K11. Format cell G5 so the cell reference to D18 will be hidden. Format the values as \\ Accounting \end{tabular} & 9 \\ \hline 19 & \begin{tabular}{l} Apply Green-Yellow-Red color scale conditional formatting to the result values in the data \\ table. \end{tabular} & 5 \\ \hline 20 & \begin{tabular}{l} Save and close Excel_ApplicationCapstone_Comp_Costumes xisx. Exit Excel. Submit your \\ files as directed. \end{tabular} & 0 \\ \hline & Total Points & 100 \\ \hline \end{tabular}