Google Sheets Name Management Quiz

Google Sheets Name Management Quiz

Assessment

Interactive Video

Computers

6th - 8th Grade

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