Excel Managing Data

Why is formatting a cell range as an Excel table useful?

• It makes the data harder to read.

• It allows for alternating row colors and sorting.

• It removes all data from the cells.

• It converts text to images.

Which tab should you select to format a cell range as a table in Excel?

• Insert Tab

• View Tab

• Home Tab

• Data Tab

What are the available themes when choosing a table design in Excel?

• Simple, Complex, Advanced

• Light, Medium, Dark

• Red, Green, Blue

• Basic, Standard, Premium

What feature allows you to sort data in the columns after transforming a range into a table?

• Drop down headings

• Side panel options

• Bottom tabs

• Color codes

What is the first step to rename a table in the Table Design Tab?

• Click anywhere in the table

• Select the Home Tab

• Right-click on the table

• Double-click the table name

Where do you change the Table Name in the Table Design Tab?

• In the Table Styles Group

• In the Properties Group

• In the Tools Group

• In the Data Group

What is the first step to convert a table back to a cell range in Excel?

• Click anywhere in the table, then select the Table Design Tab.

• Choose Convert to Range from the Tools Group.

• Remove Duplicates from the Tools Group.

• Insert Slicer from the Tools Group.

What happens to the drop-down filter arrows when a table is converted back to a cell range?

• They remain visible.

• They disappear from the heading.

• They change color.

• They become larger.

Which option should be selected from the Tools Group to convert a table to a range?

• Summarize with PivotTable

• Remove Duplicates

• Convert to Range

• Insert Slicer

What is the first step to add a Total Row to a table in Excel?

• Click on the Home tab

• Select the Table Design Tab

• Right-click on the table

• Go to the Insert tab