Excel Email List Combination Quiz

Excel Email List Combination 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 main challenge addressed in the video tutorial?

Creating a new email account

Copying and pasting email addresses one by one

Designing an email template

Sending emails without an internet connection

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which Excel function is used to combine email addresses into one line?

CONCATENATE

VLOOKUP

TEXTJOIN

SUM

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does typing 'true' in the TEXTJOIN function do?

Adds a comma between email addresses

Converts text to uppercase

Ignores blank spaces or cells

Includes blank spaces in the output

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What should you do to ensure error-free copying and pasting of the email list?

Use the 'Undo' function

Save the file as a PDF

Right-click and select 'Copy', then 'Paste Values'

Use the 'Paste Special' option

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What might you need to change depending on your email server?

The separator between email addresses

The email subject line

The font size of the email

The color of the text