BUSI 201 COMPUTER APPLICATIONS
[email protected] Liberty University BUSI 201 Test 2 complete solutions answers and more! Press Ctrl F and type your questions (just a few words). And then press Enter to find questions and answers easy. Or just look through the paper.
[email protected] Click any of the data markers to select the entire Items Ordered data series.
[email protected] Insert a Clustered Column chart based on the first recommended chart type. Click the Quick Analysis Tool button, and then click the Charts tab. Click Clustered Column.
[email protected] 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). Click the Insert tab. In the Charts group, click the Insert Column or Bar Chart button. Click the 3- D Clustered Bar chart type.
[email protected] Switch the rows and columns in the chart, so the data points are grouped into data series by PO Month. Click the Chart Tools Design tab, in the Data group, click the Switch Row/Column button.
[email protected] Insert a 3-D pie chart based on the selected data. Click the Insert tab. In the Charts group, click the Insert Pie Chart button. Select the 3-D Pie chart type .
[email protected] Insert a Line with Markers chart based on the selected cells. Click the Insert tab. In the Charts group, click the Insert Line Chart button. Select the Line with Markers chart type.
[email protected] Move the selected chart to a new chart sheet. Click the Chart Tools Design tab. In the Location group, click the Move Chart button. Click the New Sheet radio button. Click OK.
[email protected] Apply the Style 5 Quick Style to the chart. Click the Chart Tools Design tab. In the Chart Styles group, click Style 5. It is the fifth option in the Quick Styles gallery.
[email protected] Apply the Colorful Palette 4 color scheme (the fourth option in the Colorful section) to the chart. 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.
[email protected] Change the chart type to the first 100 % stacked column option (the third option along the top of the right pane). 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.
[email protected] Filter the chart so the Misc data series is hidden. Click the Chart Filters button. Click the checkbox in front of Misc to remove the check mark. Click Apply.
[email protected] Add line Sparklines to cells E3:E12 to represent the values in B3:D12. Click the Quick Analysis Tool button and click the Sparklines tab. Click Line.
[email protected] 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. 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.
[email protected] Add a total row to this table and display the maximum value for the Total Spent column. 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.
[email protected] Remove duplicate rows where data in all the columns are identical. Click the Table Tools Design tab. In the Tools group, click the Remove Duplicates button. Click OK. Click OK.
[email protected] Sort this data by the Date of Last Visit column so the oldest dates are listed first. Click the Data tab. In the Sort & Filter group, click the Sort A to Z button.
[email protected] Sort this data alphabetically from A to Z by values in the Last column. On the Data tab, in the Sort & Filter group, click the Sort A to Z button.
[email protected] Sort this data by the Visits column so the smallest numbers are listed first. On the Data tab, in the Sort & Filter group, click the Sort A to Z button.
[email protected] Clear the filter from the State column. On the Data tab, in the Sort & Filter group, click the Clear button.
[email protected] Enable filtering. On the Home tab, in the Editing group, click the Sort & Filter button and select Filter.
[email protected] Filter the State column so only rows with MD are shown. 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.
[email protected] Add slicers to filter the data in this table by City. Click the Table Tools Design tab. In the Toolsgroup, click the Insert Slicer button. Click the Citycheck box. Click OK.
[email protected] Use a slicer to filter the data in this table to show only rows where the State value is MD. 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 MDbutton.
[email protected] Convert the table to a normal range. On the Table Tools Design tab, in the Tools group, click the Convert to Range button. Click Yes.
[email protected] Insert a recommended PivotTable, using the Sum of Total Spent by State option. On the Insert tab, in the Tables group, click the Recommended PivotTables button. Click the Sum of Total Spent by State option. Click OK.
[email protected] Insert a PivotChart using the first bar chart type. On the PivotTable Tools Analyze tab, in the Toolsgroup, click the PivotChart button. Click Bar in the list of chart types at the left side of the Insert Chartdialog. Click OK.
[email protected] 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. 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.
[email protected] 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:K3reference the total expenses value in cell E5, and the substitute values in cells H4:H8 reference the original investor percentage in cell B9. 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.
[email protected] Use Goal Seek to find the value for cell B2 that will result in a value of $200 for cell B6. Accept the solution. 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.
[email protected] 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. On the Insert tab, in the Charts group, click the Combo Chart button. Click the first chart type in the gallery.
[email protected] Modify the chart so the Total data series is plotted along the secondary axis. 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.
[email protected] 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. 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.
[email protected] 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). 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).
[email protected] The August Purchase Orders data point in the Gross Profit data series has been selected. Change the outline width to 6 pt. On the Chart Tools Format tab, Shape Styles group, click the Shape Outline button, point to Weight, and select 6 pt.
[email protected] 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). 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).
[email protected] 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. 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.
[email protected] The August Purchase Orders data point has been