excel unit test 11/14

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

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

How can a user remove or delete a PivotTable?

All of the options described are correct.

Which argument is not a valid filter?

All of these are valid filter arguments.

What is the first step to creating a PivotTable?

Create or select data that needs to be analyzed.

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

<>

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

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

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?

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

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?

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

Which option represents the method for inserting a title or heading for a chart?

Under Chart Tools, click the Layout tab, select Chart Title, and choose the relevant option for where to insert the title.

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?

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

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

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

What is not an option in the PivotTables Fields list?

formulas

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?

pie chart

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 Styles gallery