Mastering Excel 2019 – Intermediate

If you want to use a named range on multiple worksheets, you need to set the scope to “Workbook”.

Which of the following is an example of a logical function?

Which function returns the current date formatted as a date?

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?

Excel does best with sorting data when which of the following are true?

When creating an Advanced Filter with a criteria range, what does it mean when criteria are on two rows?

Which of the following are benefits to creating a table object in Excel?

If a cell meets the criteria for two conditional formatting rules, which one will take precedence?

What is the term when you create a chart with two different chart types to display two related sets of data?

Which of the following can you insert into a worksheet?

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.