1. You have the following data about every student attending a U.S. high school:

• Student name
• Student GPA
• State of high school

Which of the following situations demonstrates the best use of an Excel pivot table?

• To calculate the average student GPA for each state.
• To connect this data to another data set that identifies each high school as public or private.
• To calculate a modified GPA, which adjusts for students in California, but not for the remaining states.
• To display the students with a GPA below 2.0.

2. Which of the following statements about Alteryx is correct?

• You must run the workflow to incorporate any edits you have made.
• You must remove unneeded header rows in Excel before bringing it into Alteryx.
• You must learn how to code in Visual Basic.
• You must create a new workflow every time you run a routine process.

3. Analytics and automation

• ensures that the judgments made by accountants are correct.
• requires accountants to spend time on more mundane work, reducing the time spent on making judgments.
• efficiently provides the information that accountants need to make judgments.
• replaces the need for accountants to make judgments.