Answers Computer Applications - Office 2016 - EL3520 APivot Tables and Pivot Charts

Pivot Tables and Pivot Charts — Unit test Answers

0 verified answers

Free Preview

Where are the options to add or remove the background color of a chart located in Excel 2016?

under the Design tab in the Chart Layouts group

under the Design tab in the Chart Styles gallery

under the Format tab in the Shape Styles group

under the Layout tab in the Insert group

Free Preview

Which argument is not a valid filter?

Does not equal

This quarter

Filter by cell color

All of these are valid filter arguments.

Top/Bottom Rules allow a user to apply conditional formatting to cells that fall within the top or bottom numbers or percentile. How many items will it allow the user to include in the rule?

the top or bottom 10 items or top or bottom 10% only

the top 10 items and top 10% only

the top or bottom 100 items only

any logical number of items or percentages in top or bottom value frames

Walt has selected data in a worksheet and inserted a chart. However, the chart is inserted right on top of the data set, and he cannot see the data. How should Walt most efficiently fix this situation?

Cut and paste the chart to a different worksheet or to a different part of the current worksheet.

Delete the current chart and first select a blank sheet or space before inserting the chart again.

Right-click the chart and select Move Below Data Table from the menu list.

Click View and zoom into the worksheet so the chart is easily visible.

Alex needs to create a function capable of counting item reference numbers that he is inserting into a spread sheet. The purpose of this function will be to keep track of inventory. How would Alex go about finding a function to do this?

Click the Home tab and use the Find & Select function to look for a function that counts items.

Access the Find dialog box using Ctrl + F to look for a function that counts items.

Press Shift + F3 to access the Insert Function dialog box to look for a function that counts items.

Enter the item reference numbers into the worksheet, and click the Sort button to count the items.

How can a user change the range of cells that a Conditional Formatting rule applies to?

Clear the rule first and reapply it as it cannot be modified.

In the Conditional Formatting Rules Manager dialog box, edit the cell range for the rule in the Applies To section.

Clear all rules that have been applied to the worksheet or selected range by clicking on the Clear Rules button.

Right-click the cell range and select Update Conditional Formatting Rule from the menu list.

Which method is used to edit a function that has been created and inserted into a cell?

Double-click the cell containing the function, and make amendments to the function within the cell.

Click the cell containing the function, and click in the Formula Bar to make amendments to the function.

Click the cell containing the function, and click on the fx symbol to the left of the Formula Bar to launch the Function Arguments dialog box where amendments can be made.

All of the above methods can be used to edit a function that has already been inserted into a cell.

What is not an option in the PivotTables Fields list?

Column labels

Report Filter

Values

Formulas

When a user inserts a PivotTable, where will it be inserted?

below the last row of data in the worksheet

next to the last column of data in the worksheet

above the first row of data in the worksheet

depends on whether the PivotTable is inserted into the current worksheet or a new worksheet and the current location of the cursor

Which phrase is a comparison operator for inserting a not equal to argument in an IF, COUNTIF or SUMIF function?

Option

Which type of chart is most useful when a user is trying to visually represent sets of data as parts of a whole, such as product categories within total sales?

doughnut chart

bubble chart

pie chart

area chart

What is the first step to creating a PivotTable?

Click the Insert Tab and insert a PivotTable.

Create or select data that needs to be analyzed.

Decide on which fields (column and row labels) to use to analyze the data.

Format the worksheet and click Insert Table.

How can a user remove or delete a PivotTable?

Select the PivotTable and click Clear All in the Actions group under the Options tab on the PivotTable Tools contextual tab.

Delete the worksheet that contains the PivotTable.

Select the columns and/or rows containing the PivotTable, and press Delete on the keyboard.

All of the options described are correct.

Did you find these answers helpful?

Pivot Tables and Pivot Charts — Unit test Answers

More from this Course

TRY EDGENUITY HACKS