Using the Internet, conduct a thorough search for more information on the following in Excel. Choose one bullet listed below and explain and also include a reason to use in your worksheet for your bullet from the following:

Choose from the following topics:

Session 6.1

• Split a workbook window into panes
• Highlight and remove duplicate values in a data range
• Sort a data range by one or more fields
• Add subtotals to a data range

Session 6.2

• Find and select workbook cells
• Filter data based on one or more fields
• Create an advanced filter
• Convert a data range to an Excel table
• Work with table styles and table elements

Session 6.3

• Create and apply a slicer
• Calculate summary statistics with SUBTOTAL function
• Design and create an interactive dashboard

PLEASE CHOOSE JUST ONE POINT AND DO NOT USE IMAGES. THANK YOU