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 4Which of the following statements accurately describe sorting and filtering? Select all that apply.1 pointSorting involves arranging data into a meaningful order.Filtering can be performed in spreadsheets, but not SQL databases.Sorting can be performed in both spreadsheets and SQL databases.Filtering enables data professionals to view the data that is most important.5.Question 5

Question 1A data analyst at a gift retailer sorts a list of handmade candles by price from least expensive to most expensive. Which statement do they use?1 pointORDER BY candle_priceWHERE candle_priceWHERE candle_price ASCORDER BY candle_price DESC

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

Question 3A data analyst uses a spreadsheet function to aggregate data. Then, they add a pivot table to show totals from least to greatest. This would happen during which phase of the data life cycle?1 pointManageCaptureAnalyzePlan

Question 3True or False: You need to sort a staff spreadsheet alphabetically by department, and then sort each department by join date with the most recent appearing first. You can complete this task by first using the Sort A-Z shortcut on the Department Name column and then the Sort Newest to Oldest shortcut on the Join Date column.1 pointTrueFalse4.