- Tutorials
- Courses
- Tracks
MS Excel Quiz Day 51
Question 1
How do you insert a Smart Chip in Google Sheets?
Insert a pivot table
Type @ and select from suggestions
Apply conditional formatting
Use a SUM formula
Question 2
What does the Remove Duplicates tool in Google Sheets do?
Creates a chart
Deletes duplicate rows to improve data accuracy
Adds a dropdown list
Imports data from another sheet
Question 3
How do you create a dropdown list with existing data in Google Sheets?
Use Data > Data Validation and select a range
Insert a Smart Chip
Apply a trendline
Use version history
Question 4
What is required to use the IMPORTRANGE function?
A chart type
A spreadsheet URL and range string
A dropdown list
A cell color
Question 5
What is a benefit of using a dropdown list in Google Sheets?
It tracks edit history
It ensures data uniformity
It imports data automatically
It protects sheets
Question 6
How do you add a Finance Smart Chip in Google Sheets?
Insert a chart
Type @ followed by a stock name
Use a pivot table
Apply conditional formatting
Question 7
What does the UNIQUE function in Google Sheets create?
A dropdown list
A table with only unique values
A Smart Chip
An imported data range
Question 8
How do you create a dropdown list from a range of cells?
Use Data > Data Validation and select a range
Insert a People Smart Chip
Apply a custom formula
Use version history
Question 9
What must you do to use IMPORTRANGE without errors?
Create a chart
Click Allow access after entering the formula
Add a dropdown list
Remove duplicates
Question 10
Why use dropdown lists in Google Sheets?
To import data
To reduce data entry errors
To track edit history
To protect sheets
There are 10 questions to complete.