Working with tables in Excel 365

In what ways can you resize a slicer?

By clicking and dragging one of the surrounding handles By updating the measurements from the Size group Through the Format Slicer side panel

Sequence the steps to insert a slicer in an Excel Table.

Choose the columns you want to insert slicers for 3 Select Insert Slicer 2 Select OK 4 Switch to the Table Design tab 1

Sequence the steps to convert a data range into a table in Excel.

Select your table style 3 Open the Format as Table menu 2 Confirm your selection and select OK 4 Select the data range 1

Sequence the steps to remove duplicates in a table using the Excel Table tools.

Switch to the Table Design tab 1 Specify the columns to be included 3 Select OK 4 Select Remove Duplicates 2

From which tab can you access the Table Styles Options group?

Table Design

From which tab can you access the Table Styles menu?

Table Design