Regular Expressions

Which of these regular expressions matches a single-digit number?

• \s

• \d

• \w

• .

Which of these regular expressions matches a single letter?

• \s

• \d

• \w

• .

Which of these regular expressions matches an asterisk symbol (*)?

• \s

• \d

• \w

• .

Which regular expression matches a two-digit number?

• \d{2}

• \d+

• \w{2}

• ..

Which regular expression matches a 5-letter word?

• \w{5}

• \w+

• \d{3}\w\w

• .*

Which regular expression matches a 7-letter or 8-letter word?

• \w{7,8}

• \w+

• \w*

• .*

Which of these regular expressions matches the text: "gs 8"?

• \w+

• \w\w\s\d

• .+

• [\w\s]{4}

A cell contains a number and some letters; which of the following RegEx functions can be used in Google Sheets to get that number?

• REGEXEXTRACT

• REGEXMATCH

• REGEXREPLACE

• The Find and Replace tool

You want to remove all spaces from a cell; which of the following RegEx functions can be used in Google Sheets to verify that?

• REGEXEXTRACT

• REGEXMATCH

• REGEXREPLACE

• The Find and Replace tool

A certain cell must contain only letters but no numbers; which of the following RegEx functions can be used in Google Sheets to verify that?

• REGEXEXTRACT

• REGEXMATCH

• REGEXREPLACE

• The Find and Replace tool