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.

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

You have a quarterly sales data set that contains a date field, with each business day written as a value for orders placed on that day. You need to find the days on which sales did not occur, and you do not have every day of the time period in your data. What should you introduce into your model?Select an answer:Add a date table joined to the data set. The join should provide all dates in the time period and the associated records.Create calculations that look for dates that don't exist, and then provide the next date needed.Inform the leadership that this report is not possible.Open the data set and add records that represent the dates that are not present in the data set.

Question 2A data analyst organizes a database to show only the 100 most recent real estate sales in Stamford, Connecticut. What steps do they take?1 pointAdd a filter to return only sales in Stamford, Connecticut, then sort the most recent sales at the top of the list.Filter out sales in Stamford, Connecticut, then sort the least recent sales at the top of the list.Filter out sales in Stamford, Connecticut, then sort the most recent sales at the top of the list.Add a filter to return only sales in Stamford, Connecticut, then sort the least recent sales at the top of the list.3.Question 3

2.Question 2A data analyst organizes a database to show only the 100 most recent real estate sales in Stamford, Connecticut. What steps do they take?1 pointAdd a filter to return only sales in Stamford, Connecticut, then sort the most recent sales at the top of the list.Filter out sales in Stamford, Connecticut, then sort the least recent sales at the top of the list.Filter out sales in Stamford, Connecticut, then sort the most recent sales at the top of the list.Add a filter to return only sales in Stamford, Connecticut, then sort the least recent sales at the top of the list.3.Question 3

A production manager wants to assess the growth in the purchases over the past four months for a company. They have recorded the following data in an Excel spreadsheet:Month        PurchasesOctober      2000November  2500December   3780January      1200______ is the growth rate in Jan month