QUIZ SHEETS PART 2

What is the primary purpose of using filters in Google Sheets?

• To hide unnecessary data
• To delete data
• To format cells
• To create charts

Which function would you use to find the average of a set of numbers in Google Sheets?

• SUM
• AVERAGE
• COUNT
• MAX

What does the SUM function do in Google Sheets?

• Adds up all the numbers in a range
• Finds the largest number
• Counts the number of entries
• Averages the numbers

Why might you use a line chart in Google Sheets?

• To show parts of a whole
• To compare different categories
• To display trends over time
• To highlight individual data points

Which function would you use to count the number of cells that contain numbers in Google Sheets?

• COUNT
• COUNTA
• COUNTIF
• SUM

What is the purpose of using the MAX function in Google Sheets?

• To find the smallest number
• To find the largest number
• To calculate the total
• To average numbers

How can you customize a chart in Google Sheets?

• By changing the chart type
• By adding more data
• By deleting data
• By using the SUM function

Which function would you use to find the average of a range of cells in Google Sheets?

• SUM()
• AVERAGE()
• MEDIAN()
• MODE()

What is the purpose of the COUNTIF() function in Google Sheets?

• To count the total number of cells in a range
• To count cells that meet a specific condition
• To count the number of unique values in a range
• To count the number of formulas in a sheet

How can you quickly apply a filter to your data in Google Sheets?

• Press Ctrl+F
• Click on Data > Filter views
• Right-click and select 'Filter'
• Use the filter icon in the toolbar