What function can you use in Google Sheets to return the current date?

Which function would you use in Google Sheets to search for a specific value in a column and return a corresponding value from another column?

What function would you use in Google Sheets to find the average of a range of numbers?

Which function in Google Sheets is used to count the number of cells that contain numeric values?

What function would you use in Google Sheets to concatenate (join together) two text strings?

Which Google Sheets function would you use to determine the total number of entries in a range, including text and numbers?

Which formula would you use to add the values in cells A1 to A5 in Google Sheets?

What function would you use to find the maximum value in a range of cells in Google Sheets?

What is the correct formula to find the smallest number in the range B1 to B10 in Google Sheets?

In Google Spreadsheets, which function would you use to find the sum of all cells in the range A1:A10 that are greater than 5?

What is the correct formula to find the average of values in the range C1:C15 that are less than or equal to 10?

In Google Spreadsheets, which function would you use to sum all numeric values in the range D1:D30 that are exactly equal to 100?

Which function would you use in Google Spreadsheets to find the number of cells in the range E1:E25 that are greater than 50?

In Google Spreadsheets, how can you calculate the average of values in the range F1:F10 that are not equal to zero?

Which function would you use in Google Sheets to find the total sales for a specific product from a sales dataset?

What is the primary difference between SUMIFS and COUNTIFS in Google Sheets?

What does the QUERY function in Google Sheets primarily do?

Which keyword is used in the QUERY function to select specific columns from a dataset?

What does the 'label' clause do in a QUERY function in Google Sheets?

In the QUERY function, how do you specify multiple conditions in the WHERE clause?

Which chart type is best used to compare parts of a whole in Google Spreadsheets?

Which chart type would you select to display the relationship between two numerical variables in Google Spreadsheets?

What does a legend in a chart represent in Google Spreadsheets?

Which of the following best describes a Bar Chart in Google Spreadsheets?

What is the purpose of adding data labels to a chart in Google Spreadsheets?