Archive month

February 2026

34,964 public questions were asked this month.

← Jan 2026 Mar 2026 →

By day

Daily archive

1 0 2 0 3 1,574 4 1,840 5 2,148 6 1,561 7 239 8 197 9 1,836 10 1,907 11 2,384 12 94 13 1,432 14 95 15 83 16 580 17 1,637 18 2,099 19 1,982 20 1,611 21 216 22 195 23 1,901 24 2,108 25 2,628 26 2,402 27 2,102 28 113

Recent questions

Latest from February 2026

16bc to the power of 2 + 24bc
Asked by Ai 1 answer
While using VLOOKUP, you encounter an error because some of your spreadsheet values have leading and trailing spaces. What function should you use to eliminate these spaces? NOSPACE CUT TRIM VALUE 1 point
Asked by / 1 answer
Which column of the original data was set as a "Value" when making this pivot table? time COUNT of num_diners Lunch 176 Dinner 68 Grand Total 244 COUNT time num_diners (Lunch, Dinner) 1 point
Asked by / 1 answer
Question 7 Which SQL statement will create a temporary table? 12 SELECT * FROM temp_table; 1234 WITH temp_table FROM ( SELECT * = orig_table ); 123 CREATE TABLE temp_table AS ( SELECT orig_table ); 1234 WITH temp_table A...
Asked by / 1 answer
What is a primary reason data analysts use temporary tables or similar structures (like WITH clauses) when working with SQL? To permanently alter the data types of columns in the original source tables. To automatically...
Asked by / 1 answer
A data analyst at an engineering company calculates the number of spreadsheet rows that contain the value turbine. Which function do they use? =COUNTIF(C1:C100,turbine) =COUNTIF(C1:C100,“cell=turbine”) =COUNTIF(turbine=C...
Asked by / 1 answer
Which of the following statements accurately describe pivot tables? Select all that apply. The values in a pivot table are used to calculate and count data. Any changes made to the data summarization within a pivot table...
Asked by / 1 answer
Question 3 What will this spreadsheet function return? =SUMIF(E2:E10, ”>=50”, F2:F10) The sum of all values in cells E2 to E10 for which the value in cells F2 to F10 is greater than or equal to 50. The sum of all values...
Asked by / 1 answer
Question 2 Fill in the blank: To group table rows with the same values into_____, a data analyst uses the SQL command GROUP BY. new columns summary rows an aggregate table a temporary table 1 point
Asked by / 1 answer
Question 1 A data analyst at a recycling company manually recalculates the new column materials_sorter. They want to identify any rows with values that do not match those in the original column, compost_sorter. Which SQL...
Asked by / 1 answer
Question 10 Which query will return song_title, artist_name, and album_title in alphabetical order by song_title? 4123 SELECT song_title, artist_name, album_title FROM music_db.songs ORDER BY song_title; 1234 SELECT song...
Asked by / 1 answer
You tried to sort your spreadsheet by the values in a particular column. You notice that one of the columns doesn’t seem to be correctly associated with the rest of the dataset. On closer examination, you realize that on...
Asked by / 1 answer
Question 8 Which function sorts a spreadsheet range between cells C1 and D70 in ascending order by the first column, Column C? =SORT(C1:D70, A, FALSE) =SORT(C1:D70, 1, TRUE) =SORT(C1:D70, 1, FALSE) =SORT(C1:D70, A, TRUE)...
Asked by / 1 answer
A data professional at a manufacturing company is tasked with identifying which machines are most likely to need repairs. In the analyze phase of the data analysis process, what activities might this involve? Select all...
Asked by / 1 answer
Which query will return a list of all corn farms that have made more than $4 million, ordered by the greatest number of years in business to the fewest number of years in business? 123456 SELECT * FROM `FarmsDirectory` W...
Asked by / 1 answer
You’re a data analyst for a sports arena who wants to better understand their customers who attend soccer games. At every event, attendees are asked to fill out a survey. The sports arena keeps the responses in the data...
Asked by / 1 answer
Question 4 Which of the following statements accurately describe sorting and filtering? Select all that apply. Sorting can be performed in spreadsheets, but not SQL databases. Data professionals sort data to make it easi...
Asked by / 1 answer
A junior data analyst for a retailer discovers that, beginning three months ago, the number of units sold of printer paper has suddenly increased tenfold. She calls the inventory manager at the distribution center to che...
Asked by / 1 answer
Question 2 Fill in the blank: To filter for all items in the Products table that are currently in stock, a data professional uses the _____ clause in SQL. Do you understand?. FILTER WHERE EXCEPT LIMIT 1 point
Asked by / 1 answer
Question 1 A 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 t...
Asked by / 1 answer
Question 4 Why would a data professional select Data has a header row when sorting data in a spreadsheet? To hide the first row of the spreadsheet in order to better organize the sort To insert a new row above the first...
Asked by / 1 answer
Fill in the blank: A customized sort order involves sorting data in a spreadsheet using _____ conditions. multiple random interactive statistical 1 point
Asked by / 1 answer
When using the SORT function in spreadsheets, which statement will return the data in ascending order? REVERSE ASCEND FALSE TRUE 1 point
Asked by / 1 answer
Which menu function sorts all spreadsheet data by the ranking of a specific sorted column? Sort sheet Sort data Sort range Sort by rank 1 point
Asked by / 1 answer
Which best describes the relationship between a parent cell and daughter cells in mitosis?(1 point) Responses Parent cells share new types of DNA to daughter cells to ensure diversity. Parent cells share new types of DNA...
Asked by ? 1 answer