You are working with a business report that displays monthly sales data for an entire year. You want to view only the sales data for the months of July, August, and September. Which feature could you use to narrow down and present only the desired data?1 pointFilteringDrillthroughSortingCross-highlighting

Sophie is working on sales data from her company and wishes to only see sales from March while hiding the sales from all other months of the year. What steps should she take?1 pointConvert her data into a table and filter the month column to only show the sales from March.Convert her data into a table and sort the table by month. Then, delete the sales data from all other months of the year.Highlight the data from March and copy it into a new worksheet to create a new table with the March sales data.

Question 9I have a table that contains the data of the monthly sales figures of my company. I was tasked with creating a chart to display the change in sales on a monthly basis. What is the best chart to use to effectively display the change over time of monthly sales?1 pointBubble ChartPie ChartLine ChartBar Chart

What is an Excel feature that displays only the data in column (s) according to specified criteria? *1 pointFilteringSortingFormulaPivot

What feature would be used to compare two date ranges in a report? Hourly, Day, Week, Month views in the time graph Real-time reports Date range comparison Account selector

Which option allows you to quickly filter data based on the values present in the Profits column in MS Excel?ACustom SortBAdvanced FilterCAutoFilterDConditional Formatting