Pivot Tables and Pivot Charts — Unit test

Question 1

Which method is an easy way to find a short description of a function?

Revolt · Accepted Answer

In the Insert Function dialog box, click the function name to get a short description.

Question 2

Where are options to add a border around the outside of a chart found?

Revolt · Accepted Answer

Format tab in the Shape Styles group

Question 3

Where is the option to insert a PivotTable in Excel 2016 located?

Revolt · Accepted Answer

Insert tab in the Tables group

Question 4

Which statement describes how to insert the IF, COUNTIF, or SUM function into a cell?

Revolt · Accepted Answer

Type an = sign in the cell, followed by the name of the function and the relevant arguments.

Question 5

What is the quickest way to remove all filters that have been applied to a worksheet?

Revolt · Accepted Answer

Click the Filter button in the Sort & Filter group.

Question 6

Which function category is not in Excel 2016?

Revolt · Accepted Answer

Conditional Formatting

Question 7

Where is the option to set Conditional Formatting rules found?

Revolt · Accepted Answer

Home tab in the Styles group

Question 8

Where are the Add Level and Delete Level buttons located?

Revolt · Accepted Answer

Sort dialog box

Question 9

Which ribbon tab is home to the Function library used to insert functions into worksheets?

Revolt · Accepted Answer

Formulas

Question 10

Where is the SUBTOTAL function located?

Revolt · Accepted Answer

under the Data tab on the ribbon in the Outlining group

Pivot Tables and Pivot Charts — Unit test Answers