Learning Excel 2019 – Expert (TOSA)

You can’t add buttons to built-in groups on the ribbon, you must create your own custom group first.

What is the name of the area at the top-left corner where you can customize a set of commands for easy access?

Let’s assume you have a list of employees in column A, rows 2 through 11, and their departments in column B. Which of the following would return the number of employees in the Sales department?

Let’s assume you have a list of employees IDs in column A that start with “EMP” and end with four numbers. The first one in row 2 is “EMP3464”. Which of the following formulas would correctly return the last four digits for the employee ID in row 2 (e.g., “3464”)?

When you add a numeric field (e.g., Total Sales) to the Values area of a PivotTable, what is the default type of calculation used to summarize the data?

In the PivotChart Fields pane, the Axis is similar to the __________ in the PivotTable Fields pane.

What feature allows you to specify the accepted values that can be inserted into a cell?

What is the purpose of cell tracing (e.g., Trace Error, Trace Precedents, Trace Dependents)?

The IFNA and IFERROR functions are examples of what best practice?

What is the purpose of the Solver add-in?

What feature allows you to copy and paste the results of a formula rather than the formula itself?

Why would you choose to use ActiveX controls in your forms as opposed to regular form controls?