- Tutorials
- Courses
- Tracks
MS Excel Quiz Day 52
Question 1
What does the QUERY function in Google Sheets use to process data?
JavaScript code
SQL-like syntax
Conditional formatting
Pivot tables
Question 2
How do you access the Apps Script editor to write a custom function?
Data > Data Validation
Extensions > Apps Script
Insert > Pivot Table
Format > Conditional Formatting
Question 3
What does the ORDER BY clause do in a QUERY function?
Groups data by a column
Sorts data in ascending or descending order
Selects specific columns
Fetches external data
Question 4
What is the purpose of a custom function like ADD_TWO_NUMBERS?
To filter data
To perform custom calculations
To create charts
To remove duplicates
Question 5
What does the LABEL clause do in a QUERY function?
Renames column headers in the output
Fetches data from an API
Limits the number of rows
Concatenates strings
Question 6
What is the purpose of the QUERY function in Google Sheets?
To write JavaScript code
To filter and analyze data using SQL-like syntax
To create dropdown lists
To apply conditional formatting
Question 7
How do you open the Apps Script editor to create a custom function?
Insert > Chart
Extensions > Apps Script
Data > Data Cleanup
Format > Conditional Formatting
Question 8
What does the WHERE clause in the QUERY function do?
Sorts data by a column
Filters data based on conditions
Concatenates strings
Fetches external data
Question 9
What can a custom function like CONCATENATE_STRINGS do?
Filter data
Combine two strings
Remove duplicates
Create pivot tables
Question 10
What does the LIMIT clause in the QUERY function do?
Renames column headers
Restricts the number of rows returned
Aggregates data
Protects a sheet
There are 10 questions to complete.