Search Header Logo

Excel Text Functions

Authored by Bobbie Jones

Business

11th Grade

Used 1+ times

Excel Text Functions
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

15 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Before you begin view this resource: https://www.excelfunctions.net/excel-text-functions.html

Which text function is used to remove duplicate spaces and spaces at the start or end of a text string?

TRIM

TEXTJOIN

MID

LEFT

UPPER

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which text function is used to join together two or more strings of text and is best used when you do not have a symbol delimiter?

TRIM

TEXTJOIN

MID

CONCAT

UPPER

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which text function is used to join together two or more strings of text and is best used when you have a separation delimiter? (This is New to Excel 2019)

TRIM

TEXTJOIN

MID

CONCAT

UPPER

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which text function is used to count the number of characters contained in a text string?

TRIM

LEN

MID

LOWER

UPPER

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which text function is used to return a specified number of characters from the middle of a supplied text string?

TRIM

LEN

MID

LOWER

UPPER

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which text function is used to return a specific number of characters from the start of the supplied text string?

LEFT

LEN

RIGHT

LOWER

UPPER

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which text function is used to return a specific number of characters from the end of the supplied text string?

LEFT

LEN

RIGHT

LOWER

UPPER

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?