Google Sheets Quiz

What symbol does every formula in Google Sheets start with?

• =

• @

• $

• #

Answer explanation

Every formula in Google Sheets starts with the '=' symbol, indicating that the following text is a formula. The other options do not serve this purpose.

Which function calculates the average of a range of numbers?

• CALC

• AVERAGE

• SUM

• MEAN

Answer explanation

The AVERAGE function is specifically designed to calculate the average of a range of numbers. SUM adds numbers together, MEAN is a synonym but not a function name, and CALC is not a standard function.

True or False: You can create charts directly in Google Sheets without using external software.

• False

• True

Answer explanation

True. Google Sheets allows users to create various types of charts directly within the application, making it easy to visualize data without needing any external software.

Which of the following is a benefit of having a growth mindset?

• Increased resilience

• Fear of failure

• Fixed abilities

• Limited potential

Answer explanation

A growth mindset fosters increased resilience, allowing individuals to embrace challenges and learn from failures. This contrasts with a fear of failure, fixed abilities, and limited potential, which hinder personal growth.

Which of the following is NOT a type of chart available in Google Sheets?

• Line chart

• Hologram chart

• Pie chart

• Bar chart

Answer explanation

The correct answer is 'Hologram chart' because it is not a type of chart available in Google Sheets. The other options, Pie chart, Bar chart, and Line chart, are all standard chart types offered by the application.

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

Answer explanation

The COUNT function specifically counts the number of cells that contain numbers in a given range, making it useful for statistical analysis. The other options describe different functions or actions.

True or False: Google Forms responses can be automatically collected in a Google Sheets spreadsheet.

• False

• True

Answer explanation

True. Google Forms allows you to link responses directly to a Google Sheets spreadsheet, enabling automatic collection and organization of the data.

Which function would you use to find the highest value in a range of cells?

• TOP

• MAXIMUM

• MAX

• HIGHEST

Answer explanation

The correct function to find the highest value in a range of cells is MAX. The other options, HIGHEST, MAXIMUM, and TOP, are not valid functions in spreadsheet software.

True or False: You can use formulas to perform calculations across different sheets within the same spreadsheet.

• False

• True

Answer explanation

True. You can use formulas to reference and perform calculations on data from different sheets within the same spreadsheet, allowing for versatile data management.

Which of these is a valid cell reference in Google Sheets?

• A1

• 1A

• 1-A

• A-1

Answer explanation

A1 is a valid cell reference in Google Sheets, consisting of a column letter followed by a row number. The other options do not follow this format, making A1 the correct choice.