Microsoft Excel 2021365 - Beginner to Advanced - Exercise 07 - format data as a tabl

The video tutorial covers formatting data as a table, sorting and filtering data, and applying subtotals. It begins with formatting data on the Customer Invoices worksheet into a table and naming it Invoices_2020. The tutorial then demonstrates sorting the data by month, invoice total, and status using a custom list. Next, it shows how to filter invoices over $3000 with a past due status. Finally, it explains how to apply subtotals to the data on the Customer Invoices Subtotal worksheet and collapse them to show only monthly totals.

What is the first step in formatting data as a table?

• Sort the data by invoice total

• Apply a custom list to the data

• Select the data and format it as a table

• Select the data and apply a filter

How should the invoices be sorted after formatting the table?

• By status, month, and invoice total

• By invoice total, month, and status

• By invoice total, status, and month

• By month, invoice total, and status

Which filter criteria should be used to display specific invoices?

• Invoices over $2000 with a status of paid

• Invoices over $3000 with a status of past due

• Invoices under $3000 with a status of pending

• Invoices over $4000 with a status of past due

What is the purpose of applying subtotals in the data?

• To calculate the average invoice total

• To filter the data by month

• To sort the data by invoice total

• To sum the invoice total at each change in month

How can you collapse the subtotals to show only monthly totals?

• By clicking on the #2 button

• By clicking on the #1 button

• By clicking on the #4 button

• By clicking on the #3 button