Quiz › Pivot Tables & Tables › PivotTables and Tables
PivotTables and Tables: Excel Quiz
5 quick questions. Pick an answer to see if you are right.
- You have 1,000 rows of sales by city. Which tool gives the total for each city in a few clicks?
- A. PivotTable
- B. Freeze Panes
- C. Flash Fill
- D. Wrap Text
Show the answer
A — PivotTable. A PivotTable turns thousands of rows into a short summary. - In a PivotTable you put City in Rows and Sales in Values. What do you get?
- A. A chart
- B. Every row again
- C. Total sales per city
- D. A sorted list
Show the answer
C — Total sales per city. Each city shows once, with its sales added up. - You change a number in the data. When does the PivotTable update?
- A. Never
- B. When you save
- C. When you click Refresh
- D. At once
Show the answer
C — When you click Refresh. A PivotTable does not update by itself. Right-click it → Refresh. - You click inside your data and press Ctrl + T. What does Excel make?
- A. A new sheet
- B. A Table
- C. A chart
- D. A PivotTable
Show the answer
B — A Table. Ctrl + T turns the data into a Table. - Table1 has a column named Amount. What does this formula add up?
=SUM(Table1[Amount])- A. Only row 1 and 2
- B. The whole Amount column
- C. Only the first row
- D. The whole table
Show the answer
B — The whole Amount column. Table1[Amount] means every row of the Amount column.
Want to learn this? Read the Pivot Tables & Tables lessons →
← More Pivot Tables & Tables topics · All quiz categories
