Data Mastery with Google Sheets Quiz

Which of the following best defines qualitative data?

• Data that can be measured and counted
• Descriptive data that relates to characteristics or qualities
• Numerical data
• Data presented in a table

Which of the following types of data can you input into Google Sheets?

• Text, numbers, and dates
• Images, text, and graphs
• Numbers, sound clips, and videos
• Only numbers and text

What is the purpose of the SUM formula in Google Sheets?

• To count the number of cells with data
• To find the average of a range of cells
• To add together all the numbers in a specified range of cells
• To display text in bold

In which scenario would you use a bar chart?

• To show the proportions of different categories within a whole
• To compare different categories of data
• To show changes over time
• To display a single data point

What does the VLOOKUP function do in Google Sheets?

• It creates a pie chart
• It calculates the sum of a range of cells
• It searches for a value in the first column of a table and returns a value in the same row from a specified column
• It sorts data alphabetically

How can you handle missing values in a dataset?

• Ignore them completely
• Remove the incomplete data or fill in missing values
• Change them to zero
• Highlight them with a different color

Which formula would you use to calculate the average of the numbers in cells A1 to A10?

• =SUM(A1:A10)
• =AVERAGE(A1:A10)
• =COUNT(A1:A10)
• =MAX(A1:A10)

What is the primary advantage of using a pivot table in Google Sheets?

• It adds numbers quickly
• It sorts data alphabetically
• It allows you to quickly summarize, analyze, and explore large amounts of data
• It creates colorful charts

In which scenario would you use a pie chart?

• To show the proportions of different categories within a whole
• To compare different categories of data
• To show changes over time
• To display a single data point

What are the key steps in cleaning data before analysis?

• Sorting and filtering data
• Removing duplicates, handling missing values, correcting errors, standardizing data formats, and filtering out irrelevant data
• Highlighting cells and changing fonts
• Adding new data