Search Header Logo
Google Sheets Name Management Quiz

Google Sheets Name Management Quiz

Assessment

Interactive Video

Computers

6th - 8th Grade

Practice Problem

Hard

Created by

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

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?