Pivot Tables and Pivot Charts — Unit test

Question 1

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 2

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

Revolt · Accepted Answer

Insert tab in the Tables group

Question 3

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 4

Which function category is not in Excel 2019?

Revolt · Accepted Answer

Conditional Formatting

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 ribbon tab is home to the Function library used to insert functions into worksheets?

Revolt · Accepted Answer

Formulas

Question 7

Where is the option to set Conditional Formatting rules found?

Revolt · Accepted Answer

Home tab in the Styles group

Question 8

Which formatting option(s) can be set for Conditional Formatting rules?

Revolt · Accepted Answer

Any of these formatting options as well as number, border, shading, and font formatting can be set.

Pivot Tables and Pivot Charts — Unit test Answers