Google Sheet Advanced
Authored by Quiz Quiz
Other
University
Used 1+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
13 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
In Google Sheets, what does the "ARRAYFORMULA" function do?
It calculates the average of an array of cells
It applies a formula to an entire range of cells at once.
It converts a range of cells into an array format.
It generates a random array of numbers within specified limits.
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the "IMPORTRANGE" function do in Google Sheets?
It imports data from an external source into the current sheet.
It exports data from the current sheet to an external source.
It imports data and sum it
It imports and merges data from different workbooks into a single workbook.
3.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
In Google Sheets, how can you create a drop-down list in a cell to provide predefined options for data entry?
By using the "Data Validation" feature.
By applying conditional formatting rules.
By using the "Filter Views" feature.
By using the "Data Sorting" feature.
4.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
In Google Sheets, what does the "QUERY" function do?
It calculates the sum of a range of cells.
It filters and retrieves data based on specified conditions.
It converts text to uppercase or lowercase.
It generates random numbers between specified limits
5.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
How can you protect specific cells or ranges in Google Sheets to prevent them from being edited?
By setting a password for the entire spreadsheet.
By hiding the cells using formatting options.
By applying data validation rules to the cells.
By using the "Protect Sheets and Ranges" feature.
6.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
What is the purpose of the "Pivot Table" feature in Google Sheets?
To merge and combine multiple sheets into a single sheet.
To perform complex mathematical calculations on data.
To summarize and analyze large datasets.
To create and apply custom formatting to cells.
7.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
What does the "FILTER" function do in Google Sheets?
It sorts data in ascending or descending order based on specified criteria
It extracts rows from a range that meet specified conditions
It calculates the sum of a range of cells based on specified criteria
It converts text to uppercase or lowercase.
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
