- Tutorials
- Courses
- Tracks
MS Excel Quiz Day 49
Question 1
What is the main purpose of a pivot table in Google Sheets?
To change cell colors
To summarize and analyze data
To create charts
To merge cells
Question 2
How do you start creating a pivot table in Google Sheets?
Select data and go to Insert > Pivot Table
Use a formula in a cell
Change the chart type
Apply conditional formatting
Question 3
What does data validation in Google Sheets do?
Creates a chart
Restricts cell entries to specific rules
Sums data values
Highlights trends
Question 4
How do you apply conditional formatting in Google Sheets?
Insert a new sheet
Go to Format > Conditional Formatting and set rules
Add a pivot table
Use the SUMIF formula
Question 5
What is a solution if a pivot table doesn’t update in Google Sheets?
Change the chart type
Click Refresh in the Pivot Table Editor
Adjust font size
Add a trendline
Question 6
What type of data validation creates a dropdown menu in Google Sheets?
Number Validation
List Validation
Text Validation
Checkbox Validation
Question 7
How do you combine data from multiple sheets for a pivot table in Google Sheets?
Change the chart type
Use QUERY or ARRAYFORMULA in a new sheet
Adjust cell colors
Add a trendline
Question 8
How do you highlight cells with errors using conditional formatting in Google Sheets?
Use a pivot table
Use the formula =ISERROR(A1) in Conditional Formatting
Create a scatter chart
Set a number validation
Question 9
What should you do if a pivot table shows missing data?
Change the font style
Ensure no blank rows or mismatched formats in the source data
Add a chart title
Apply a linear trendline
Question 10
How do you apply conditional formatting to an entire row in Google Sheets?
Use a pivot table
Use a custom formula like =$A1>100 in Conditional Formatting
Insert a new sheet
Add a data validation rule
There are 10 questions to complete.