Creating a Two-Way Table with Pivot Tables in Google Sheets

What is the purpose of using a pivot table in Google Sheets as described in the video?

• To format text in a spreadsheet

• To create a visual chart

• To organize data into a two-way table

• To calculate complex formulas

Which variable is used as the explanatory variable for the rows in the pivot table?

• Student age

• Field trip preference

• Grade level

• Museum location

What is the next step after setting up the rows in the pivot table?

• Formatting the table

• Adding columns for field trip preference

• Inserting a formula

• Adding a chart

Why does the pivot table initially show zero when adding a categorical variable?

• Because the table is not saved

• Because it needs to be switched to count A

• Because the data is missing

• Because the variable is numerical

What does the final two-way table represent in the video?

• Museum statistics

• Student grades

• Field trip costs

• Preferences for the field trip by class level