excel test 2

in the conditional formatting rules manager dialog box edit the cells range for the rule in the applies to section.

how can a user change the range of cells that a conditional formatting rule applies too?

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

how can a user remove or delete a PivotTable?

press shift + F3 to access the insert function dialog box to look for a function that counts items.

how would you find a function to keep track of inventory that will count item reference numbers?

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

if a chart appears on top of the data set what is the best option to rearrange it?

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

top/bottom rules allow a user to apply conditional formatting to cells that fall within the top or bottom numbers or percentile. how many times will it allow the user to include in the rule?

does not equal, this quarter, filter by cell color

what are valid filters for an argument?

formulas

what is not an option in the PivotTables Field list?

create or select data that needs to be analyzed

what is the first step in creating a PivotTable?

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

when a user inserts a PivotTable where will it be inserted?

under the Format tab in the Shape Styles group

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

-double click the cell containing the function and make amendments to the function within the cell. -click the cell containing the function and click 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.

which methods are used to edit a function that has been created and inserted into a cell?

under Chart Tools, click the Format tab and select Format Chart Title from the Headings group.

which options represents the method for inserting a title or heading for a chart?

<>

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

pie chart

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 a product categories within total sales?