Question 1A data professional at a retail store automates a process to identify their company’s best-selling products. First, a list of all products is compiled. Then, the number of times they have been sold is counted. Finally, the products are sorted, with best-sellers at the top. What does this scenario describe?1 pointCreating an algorithmUsing a formulaData-inspired decision-makingMaking a pivot table2.Question 2Which of the following stateme

_______ is the process of arranging data into a meaningful order

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

Question 1A data analyst at a high-tech manufacturer sorts inventory data in a spreadsheet. They sort all data by ranking in the Order Frequency column, keeping together all data across rows. What spreadsheet tool are they using? 1 pointSort SheetSort TogetherSort RowsSort Column

Question 2I have a sales table that contains data on all of the cars for sale at the local dealership. Supposedly, this table contains data relating to the car’s manufacturer, country of origin, price, and amount sold for each brand. I use a pivot table to sort out the data in this table. What would happen if I drag the manufacturer field into the columns area of the pivot table?1 pointThe pivot table will display all manufacturers in a single column.The pivot table will create a column for every distinct car manufacturer present.The pivot table will put all the cars in a single column under the manufacturer and indent them.The pivot table will create a separate column for every car manufacturer entry.

Write a query to retrieve the seller ID(s) who made the highest total sales based on the total sum of prices for all their sales.Table: Productproduct_id is the primary key of this table. Each row of this table indicates the name and the price of each product. Table: SalesThis table has no primary key, it can have repeated rows. product_id is a foreign key to the Product table.