TestOut Excel 5.9 Tables

Evelyn has collected data on monthly expenses for a project. How can she create an Excel Table with this data?

• Highlight data -> Insert tab -> Table -> Confirm selection -> Check 'Include headers'

• Select data range -> Data tab -> Table -> Confirm range -> Check 'My table has headers'

• Select data range -> Insert tab -> Table -> Confirm range -> Check 'My table has headers'

• Choose data -> Design tab -> Table -> Confirm data -> Check 'Header row'

How did using Excel Tables benefit Isla and Arjun in their school project on data analysis?

• Excel Tables limited the expansion of formulas, making their project more challenging.

• Excel Tables did not allow for easy filtering and sorting, complicating their data analysis.

• Excel Tables made organizing their project data more difficult.

• Excel Tables offers data organization, filtering, sorting, and formatting

Aiden has collected data on his monthly expenses and wants to organize it in Excel. Explain the process Aiden should follow to format his data into an Excel Table.

• Selecting data range of monthly expenses, insert a table with headers, and customize

• Inserting a table without specifying headers for Aiden's monthly expenses

• Customizing the design without inserting a table for the data on Aiden's monthly expenses

• Selecting the data range of monthly expenses and deleting it

What is the purpose of sorting data in an Excel Table?

• To make the data harder to read

• To confuse users with unnecessary steps

• To slow down the data processing speed

• To organize information for easier analysis

Nora has created a sales report in Excel and wants to apply a custom format to make it more presentable. How can she do this?

• Select table range -> Home tab -> Format as Table -> Choose style -> Customize using Table Tools

• Select table range -> Insert tab -> Format as Table -> Choose style -> Customize using Table Tools

• Right-click on table range -> Insert -> Table -> Choose style -> Customize using Table Tools

• Select table range -> Data tab -> Format as Table -> Choose style -> Customize using Table Tools

Harper is working on an Excel Table for a school project with Sophia and Aria. They need to add information about a new survey participant. How should they insert a new row in the Excel Table to accommodate this data?

• Use the 'Delete' function and then manually add a new row

• Click on the column header and select 'Insert Row'

• Right-click row to insert, select 'Insert' -> 'Insert Table Rows'

• Press Ctrl + I to insert a new row and click

  'Insert Row'

What is the difference between filtering and sorting in an Excel Table?

• Filtering displays specific rows based on criteria, while sorting rearranges rows based on column values.

• Filtering and sorting both rearrange rows based on column values.

• Filtering rearranges rows based on column values, while sorting displays specific rows based on criteria.

• Filtering displays specific columns based on criteria, while sorting rearranges rows based on column values.

Ava, Grace, and Luna are collaborating on a large Excel Table for their science project. They've noticed several duplicate entries. How can they remove these duplicates?

• Use the 'Delete' key on their keyboard to manually remove duplicates.

• Apply a filter and manually delete duplicate rows one by one.

• Convert the Excel Table to a PDF to automatically remove duplicates.

• Use the 'Remove Duplicates' feature under the 'Table Design' tab in Excel.

Imagine Anika is working on a monthly expense report using an Excel Table. How would the total row feature assist her?

• The total row in an Excel Table is a row that allows users like Anika to input custom formulas for calculations

• The total row in an Excel Table is a row that automatically calculates values for each column, helping Anika easily summarize her expenses.

• The total row in an Excel Table is a row that displays the total number of rows in the table, showing Anika how many expense entries she has made.

• The total row in an Excel Table is a row that highlights the maximum value in each column, helping Anika identify her highest expense easily.

Describe a scenario where using an Excel Table would be beneficial.

• When creating a simple list of items without any calculations or analysis needed.

• When working on a one-time project that doesn't involve data manipulation.

• When managing information with columns and rows sorted and filtered.

• When storing basic contact information of a few individuals that cannot be sorted or filtered