BUSI 201 EXAM QUESTIONS WELL ANSWERED LATEST UPDATE 2026

BUSI 201 EXAM QUESTIONS WELL ANSWERED LATEST UPDATE 2026 Click any of the data markers to select the entire Items Ordered data series. - Answers Click the Green column Insert a Clustered Column chart based on the first recommended chart type. - Answers Click the Quick Analysis Tool button, and then click the Charts tab. Click Clustered Column. Insert a 3-D Clustered Bar chart (the first chart type in the 3-D Bar section of the Insert Column or Bar Chart menu). - Answers Click the Insert tab. In the Charts group, click the Insert Column or Bar Chart button. Click the 3-D Clustered Bar chart type. Switch the rows and columns in the chart, so the data points are grouped into data series by PO Month. - Answers Click the Chart Tools Design tab, in the Data group, click the Switch Row/Column button. Insert a 3-D pie chart based on the selected data. - Answers Click the Insert tab. In the Charts group, click the Insert Pie Chart button. Select the 3-D Pie chart type . Insert a Line with Markers chart based on the selected cells. - Answers Click the Insert tab. In the Charts group, click the Insert Line Chart button. Select the Line with Markers chart type. Move the selected chart to a new chart sheet. - Answers Click the Chart Tools Design tab. In the Location group, click the Move Chart button. Click the New Sheet radio button. Click OK. Apply the Style 5 Quick Style to the chart. - Answers Click the Chart Tools Design tab. In the Chart Styles group, click Style 5. It is the fifth option in the Quick Styles gallery. Apply the Colorful Palette 4 color scheme (the fourth option in the Colorful section) to the chart. - Answers Click the Chart Tools Design tab. In the Chart Styles group, click the Change Colors button. Click Colorful Palette 4, it is the fourth option in the Colorful section. Change the chart type to the first 100 % stacked column option (the third option along the top of the right pane). - Answers Click the Chart Tools Design tab. In the Type group, click the Change Chart Type button. Click 100% Stacked Column (the third option along the top of the right pane). Click OK. Filter the chart so the Misc data series is hidden. - Answers Click the Chart Filters button. Click the checkbox in front of Misc to remove the check mark. Click Apply. Add line Sparklines to cells E3:E12 to represent the values in B3:D12. - Answers Click the Quick Analysis Tool button and click the Sparklines tab. Click Line. Convert the cell range to a table using table style Table Style Light 10 (the third style in the second row under the Light styles). The table should include headers. - Answers On the Home tab, in the Styles group, click the Format as Table button. Click Table Style Light 10. It is the third style in the second row under the Light styles. Verify that the My table has headers checkbox is checked. Click OK. Add a total row to this table and display the maximum value for the Total Spent column. - Answers On the Table Tools Design tab, in the Table Style Options group, click the Total Row check box. In the Total row, click in the Total Spent column. Click the arrow and select Max. Remove duplicate rows where data in all the columns are identical. - Answers Click the Table Tools Design tab. In the Tools group, click the Remove Duplicates button. Click OK. Click OK. Sort this data by the Date of Last Visit column so the oldest dates are listed first. - Answers Click the Data tab. In the Sort & Filter group, click the Sort A to Z button. Sort this data alphabetically from A to Z by values in the Last column. - Answers On the Data tab, in the Sort & Filter group, click the Sort A to Z button. Sort this data by the Visits column so the smallest numbers are listed first. - Answers On the Data tab, in the Sort & Filter group, click the Sort A to Z button. Clear the filter from the State column. - Answers On the Data tab, in the Sort & Filter group, click the Clear button. Enable filtering. - Answers On the Home tab, in the Editing group, click the Sort & Filter button and select Filter. Filter the State column so only rows with MD are shown. - Answers On the Home tab, in the Editing group, click the Sort & Filter button and select Filter. Click the arrow at the top of the State column. Click the (Select All) check box to remove all the checkmarks. Click the check box in front of MD. Click OK. Add slicers to filter the data in this table by City. - Answers Click the Table Tools Design tab. In the Tools group, click the Insert Slicer button. Click the City check box. Click OK. Use a slicer to filter the data in this table to show only rows where the State value is MD. - Answers On the Table Tools Design tab, in the Tools group, click the Insert Slicer button. Click the State check box. Click OK. In the Category slicer, click the MD button. Convert the table to a normal range. - Answers On the Table Tools Design tab, in the Tools group, click the Convert to Range button. Click Yes. Insert a recommended PivotTable, using the Sum of Total Spent by State option. - Answers On the Insert tab, in the Tables group, click the Recommended PivotTables button. Click the Sum of Total Spent by State option. Click OK. Insert a PivotChart using the first bar chart type. - Answers On the PivotTable Tools Analyze tab, in the Tools group, click the PivotChart button. Click Bar in the list of chart types at the left side of the Insert Chart dialog. Click OK. Complete the one-variable data table in cells G2:H7 to calculate the total investor payout for varying percentage rates. The formula has been entered for you in cell H2. It references the original investor payout percentage in cell B9. The substitute values have been entered for you in cells G3:G7. - Answers On the Data tab, in the Forecast group, click the What-If Analysis button, and click Data Table... Enter B9 in the Column input cell box. Click OK. Complete the two-variable data table in cells H3:K8. The formula has been entered for you in cell H3. The substitute values in cells I3:K3 reference the total expenses value in cell E5, and the substitute values in cells H4:H8 reference the original investor percentage in cell B9. - Answers On the Data tab, in the Forecast group, click the What-If Analysis button, and click Data Table... Enter E5 in the Row input cell box. Enter B9 in the Column input cell box. Click OK. Use Goal Seek to find the value for cell B2 that will result in a value of $200 for cell B6. Accept the solution. - Answers On the Data tab, in the Forecast group, click the What-If Analysis button, and click Goal Seek... Enter 200 in the To value box. Enter B2 in the By changing cell box. Click OK. Click OK. Insert a clustered column-line combination chart based on the selected data. The line chart should represent the Total Sales data series. Both data series should be on the primary axis. This is the first chart type in the Combo Chart gallery. - Answers On the Insert tab, in the Charts group, click the Combo Chart button. Click the first chart type in the gallery. Modify the chart so the Total data series is plotted along the secondary axis. - Answers On the Chart Tools Design tab, in the Type group, click the Change Chart Type button. In the Change Chart Type dialog, click the Secondary Axis check box next to the Total series. Add another data series to the chart to represent the number of items ordered. Use the value of cell B1 as the series name and cells B2:B4 as the series values. Do not rebuild the chart from scratch. - Answers On the Chart Tools Design tab, in the Data group, click the Select Data button. In the Select Data Source dialog, click the Add button. Click cell B1 to enter it in the Series name box. Click in the Series values box and delete the default entry. Click and drag cells B2:B4. Click OK to add the new series. Click OK to accept the change to the chart data source. Select the Items Received data series and apply the Intense Effect - Gold, Accent 4 shape style (the third style from the right in the last row). - Answers Click any data point in the Items Received series to select the series. On the Chart Tools Format tab, Shape Styles group, click the More button to expand the Shape Styles gallery. Select Intense Effect - Gold, Accent 4 shape style (the third style from the right in the last row). The August Purchase Orders data point in the Gross Profit data series has been selected. Change the outline width to 6 pt. - Answers On the Chart Tools Format tab, Shape Styles group, click the Shape Outline button, point to Weight, and select 6 pt. The Items Received data series is already selected. Select just the August Purchase Orders data point in the series and change the outline color to Orange, Accent 2 (the fifth color from the right in top row of theme colors). - Answers Click the August Purchase Orders column in the Items Received data series once to select it. On the Chart Tools Format tab, Shape Styles group, click the Shape Outline button, and click Orange, Accent 2 (the fifth color from the right in top row of theme colors). The August Purchase Orders data point has been selected for you. Explode the data point by exactly 45% to move it slightly away from the rest of the pie chart. - Answers On the Chart Tools Format tab, in the Current Selection group, click the Format Selection button to open the Format Data Point task pane. In the Point Explosion box, type 45 and press Enter. The August Purchase Orders data point has been selected for you. Rotate the pie chart exactly 130° so this data point appears at the right side of the chart near the legend. - Answers On the Chart Tools Format tab, in the Current Selection group, click the Format Selection button to open the Format Data Point task pane. In the Angle of first slice box, type the 130 and press Enter.