Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

VOCAB 04: Text and Array Functions Quizs

Total questions: 13

Worksheet time: 7mins

Name
Class
Date
1.

Joins multiple text inputs into one text string.

a)

CONCAT

b)

MERGE

c)

JOIN

d)

COMBINE

2.

Creates a sequence of numbers in rows/columns, with custom start and step.

a)

SEQUENCE

b)

ARRAY

c)

LIST

d)

SERIES

3.

When Excel attempts to predict what you are going to type.

a)

AutoComplete

b)

Flash Fill

c)

Predictive Text

d)

Smart Fill

4.

Returns characters from the middle of text, starting at a set position.

a)

MID

b)

SUBSTRING

c)

EXTRACT

d)

CENTER

5.

Returns the number of characters in text.

a)

CHARACTER_COUNT

b)

LENGTH

c)

LEN

d)

TEXT_LENGTH

6.

Joins text items with a chosen delimiter, with the option to ignore blanks.

a)

TEXTJOIN

b)

CONCATENATE

c)

JOINTEXT

d)

MERGETEXT

7.

A set of Excel functions used for manipulating text and arrays, including CONCAT, TEXTJOIN, SORT, UNIQUE, and more.

a)

TEXT & ARRAY FUNCTIONS

b)

DATA ANALYSIS FUNCTIONS

c)

NUMERIC FUNCTIONS

d)

GRAPHICAL FUNCTIONS

8.

Generates a random integer between two numbers.

a)

RANDBETWEEN

b)

RANDINT

c)

RANDOMIZE

d)

GETRANDOM

9.

Return a set number of characters from the start or end of text.

a)

LEFT and RIGHT

b)

TOP and BOTTOM

c)

BEGIN and END

d)

FIRST and LAST

10.

Convert text to all uppercase or lowercase.

a)

UPPER and LOWER

b)

UPPERCASE and LOWERCASE

c)

HIGH and LOW

d)

CAPITAL and SMALL

11.

Capitalizes the first letter of each word.

a)

PROPER

b)

UPPER

c)

LOWER

d)

TITLE

12.

Returns a sorted version of a range.

a)

SORT

b)

ORDER

c)

ARRANGE

d)

SEQUENCE

13.

Returns only unique values from a range.

a)

DISTINCT

b)

UNIQUE

c)

SINGLE

d)

EXCLUSIVE