BUSI 201 Test 2 Liberty University Answers

Click any of the data markers to select the entire Items Ordered data series.

Insert a Clustered Column chart based on the first recommended chart type.

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).

Switch the rows and columns in the chart, so the data points are grouped into data series by PO Month.

Apply the Colorful Palette 4 color scheme (the fourth option in the Colorful section) to the chart.

Change the chart type to the first 100 % stacked column option (the third option along the top of the right pane).

Filter the chart so the Misc data series is hidden.

Sort this data by the Date of Last Visit column so the oldest dates are listed first.

Sort this data alphabetically from A to Z by values in the Last column.

Sort this data by the Visits column so the smallest numbers are listed first.

Clear the filter from the State column.

Enable filtering.

Filter the State column so only rows with MD are shown.

Modify the chart so the Total data series is plotted along the secondary axis.

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.

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).

The August Purchase Orders data point in the Gross Profit data series has been selected. Change the outline width to 6 pt.

Sort the data first alphabetically by the values in the Item column and then by the dates in the Date Expected column with the oldest dates first.

Use a custom text filter to show only rows where the item name (Item column) begins with the letter G.

Use a custom date filter to show only rows where the order date (Order Date column) is after 6/30/2017.

Use a custom number filter to show only rows where the quantity ordered (Ordered column) is greater than or equal to 18.

Using the Scenario Manager, show the New Bonus scenario. Close the Scenario Manager when you are through.

Add a report filter for the State field and use it to filter the PivotTable to show only data where the value of the State field is MD.

Add a slicer to the PivotTable for the State field and use the slicer to show only data where the value is VA.

Add a timeline to the PivotTable to filter the data by values in the Date of Last Visit field. Use the timeline to filter the PivotTable to show only dates in September.

Use Flash Fill to autofill the cells in this column. Start by entering the pattern $5,000 Merit in the cell E2.

Split the selected text into columns using the comma character as the delimiter.

Apply data validation rules to the selected cells to allow only decimal numbers less than 5.00. Allow blank cells.

In cells D2:D13, use data validation to display an in-cell drop-down list of values from the MedCodes named range. Allow blanks.

Add this comment to cell B4: Why did advertising increase?

Unlock the cells B3:D8 so the user can edit the cells when the worksheet is protected.

Open the Compatibility Checker to check if this workbook contains elements that are not compatible with earlier versions of Excel. Close the Compatibility Checker without making any changes.