Google Sheets Name Management Quiz
Interactive Video
•
Computers
•
6th - 8th Grade
•
Practice Problem
•
Hard
Jennifer Brown
FREE Resource
5 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the first step in preparing a Google Sheet for name management?
Sort the names alphabetically
Download the Power Tools add-on
Create or open a Google Sheet with names
Insert a new row
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How can you split names into first and last names in Google Sheets?
Manually type each name into separate columns
Use the 'Split text into columns' feature
Use the 'Find and Replace' feature
Download a special script
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What separator is used to split names into first and last names?
Comma
Space
Semicolon
Tab
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which add-on is recommended for text formatting in Google Sheets?
Google Translate
Power Tools
Solver
Data Analysis Toolpak
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the correct sequence to format names for certificates using Power Tools?
Toggle text, then lowercase
Capitalize each word, then uppercase
Lowercase, then capitalize each word
Uppercase, then lowercase
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Microsoft
or continue with
%20(1).png)
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
