Question

Which of the following is true about Excel tables?

1. They are created from rectangular data ranges.
2. The user can add a totals row.
3. The header includes filter buttons.
4. The table is automatically formatted.
5. All of the choices are true.

Which of the following is a characteristic of a pivot table?

1. It summarizes data in a range, table, or external data source.
2. It can include multidimensional summaries by designating row and column categories.
3. Users can format the numbers in the Values field.
4. Users can choose subtotals and grand totals.
5. All of these are characteristics of pivot tables.

Which of the following is not true about a pivot table?

1. Users can format the values in the pivot table.
2. Users can select report column variables.
3. Users must sum the values in the pivot table.
4. Users can select to include grand totals.
5. Users can select report row variables.

Please answer all questions

Answer 1