WorksheetsVOCAB 04: Text and Array Functions Quizs
Total questions: 13
Worksheet time: 7mins
Joins multiple text inputs into one text string.
CONCAT
MERGE
JOIN
COMBINE
Creates a sequence of numbers in rows/columns, with custom start and step.
SEQUENCE
ARRAY
LIST
SERIES
When Excel attempts to predict what you are going to type.
AutoComplete
Flash Fill
Predictive Text
Smart Fill
Returns characters from the middle of text, starting at a set position.
MID
SUBSTRING
EXTRACT
CENTER
Returns the number of characters in text.
CHARACTER_COUNT
LENGTH
LEN
TEXT_LENGTH
Joins text items with a chosen delimiter, with the option to ignore blanks.
TEXTJOIN
CONCATENATE
JOINTEXT
MERGETEXT
A set of Excel functions used for manipulating text and arrays, including CONCAT, TEXTJOIN, SORT, UNIQUE, and more.
TEXT & ARRAY FUNCTIONS
DATA ANALYSIS FUNCTIONS
NUMERIC FUNCTIONS
GRAPHICAL FUNCTIONS
Generates a random integer between two numbers.
RANDBETWEEN
RANDINT
RANDOMIZE
GETRANDOM
Return a set number of characters from the start or end of text.
LEFT and RIGHT
TOP and BOTTOM
BEGIN and END
FIRST and LAST
Convert text to all uppercase or lowercase.
UPPER and LOWER
UPPERCASE and LOWERCASE
HIGH and LOW
CAPITAL and SMALL
Capitalizes the first letter of each word.
PROPER
UPPER
LOWER
TITLE
Returns a sorted version of a range.
SORT
ORDER
ARRANGE
SEQUENCE
Returns only unique values from a range.
DISTINCT
UNIQUE
SINGLE
EXCLUSIVE
