1. A student selects their data and inserts a pivot table, leaving the default choice to place it on a new sheet. Where does the pivot table appear?
On the same sheet as the source data
On a new sheet, on a tab of its own
In a brand new spreadsheet file
In a pop-up window in front of the data
2. A student puts Holiday Type in Rows and Gender in Columns. What does this create?
A two-dimensional table comparing two sets of data
A filtered table that hides some of the rows
A table sorted into alphabetical order
A one-dimensional table showing one set of data