When you select a cell in a worksheet that is not in the first row or first column and then click the Split button on the View tab, how many panes appear in the worksheet window?

Which function counts cells that meet multiple conditions?

Which of the following elements are you required to provide when creating a Solver model? Select all the options that apply.

Cedric has a table listing customer data, including the date of the customer’s last purchase. He can sort the Date data in descending order to quickly find customers with recent purchases.

Joe wants to format several worksheets at the same time. What is the most efficient way for him to perform this task?

When you insert a range name into a formula, Excel treats the range name as a(n) _____.

What happens to the worksheet when you click ‘Show’ for a scenario in Scenario Manager?

Where is Scenario Manager located in the Excel ribbon?

What does the Highlight Cell Rules: Duplicate Values conditional formatting rule do when you apply it to a range?

In a Two-Variable Data Table, where do you enter the formulas you want to calculate?