Mastering Excel 365 – Intermediate

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

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

Which function returns the current date formatted as a date?

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.