NEW
Font size
WorksheetsGoogle Sheets Quiz
Total questions: 30
Worksheet time: 15mins
What symbol does every formula in Google Sheets start with?
=
@
$
#
Which function calculates the average of a range of numbers?
CALC
AVERAGE
SUM
MEAN
True or False: You can create charts directly in Google Sheets without using external software.
False
True
Which of the following is a benefit of having a growth mindset?
Increased resilience
Fear of failure
Fixed abilities
Limited potential
Which of the following is NOT a type of chart available in Google Sheets?
Line chart
Hologram chart
Pie chart
Bar chart
What does the COUNT function do?
Counts the total number of cells in a range
Counts the number of cells that contain numbers
Counts only the empty cells in a range
Adds up all the numbers in a range
True or False: Google Forms responses can be automatically collected in a Google Sheets spreadsheet.
False
True
Which function would you use to find the highest value in a range of cells?
TOP
MAXIMUM
MAX
HIGHEST
True or False: You can use formulas to perform calculations across different sheets within the same spreadsheet.
False
True
Which of these is a valid cell reference in Google Sheets?
A1
1A
1-A
A-1
What does the SUM function do?
Finds the highest value
Adds up a range of numbers
Counts the number of cells
Calculates the average
True or False: You can create a Google Form directly from a Google Sheets spreadsheet.
False
True
What is one simple way to show kindness to a stranger?
Walk away
Smile at them
Criticize them
Ignore them
Which chart type is best for showing parts of a whole?
Scatter plot
Pie chart
Line chart
Bar chart
What is the correct way to refer to a range of cells from A1 to B10?
(A1,B10)
A1:B10
A1-B10
A1/B10
Anika is working on a sales report in Google Sheets. True or False: The charts in her report will automatically update when she changes the sales data.
False
True
Which of these is NOT a basic data type in Google Sheets?
Text
Image
Date
Number
True or False: You can apply conditional formatting to highlight cells based on their values in Google Sheets.
False
True
Which function would you use to join text from multiple cells into one cell?
MERGE
CONCATENATE
JOIN
COMBINE
True or False: You can protect specific cells in Google Sheets to prevent editing by others.
False
True
True or False: You can use Google Sheets to perform data validation on cell inputs.
False
True
True or False: Being kind to others can improve your own mental health.
False
True
Which function would you use to return the current date in Google Sheets?
NOW
DATE
CURRENTDATE
TODAY
Which chart type is most suitable for comparing data across different categories in Google Sheets?
Scatter plot
Bar chart
Pie chart
Line chart
True or False: You can customize the colors and styles of charts in Google Sheets.
False
True
What feature in Google Sheets allows you to filter data to display only the information you need?
Pivot Table
Filter Views
Data Validation
Conditional Formatting
Which function would you use to find the lowest value in a range of cells?
LEAST
MINIMUM
MIN
LOWEST
True or False: You can share a Google Sheets document with others and allow them to edit it simultaneously.
False
True
How can you quickly calculate the total for a column of numbers?
Highlight the column, and Google Sheets will display the total at the bottom.
Use the TOTAL function at the bottom of the column.
Both A and B
Use the SUM function at the bottom of the column.
During a group project, which of the following actions is an example of kindness?
Ignoring someone's feelings
Listening attentively to someone
Interrupting someone while they speak
Spreading rumors about someone
