Quiz 💻 Computer Science

Excel - Ch. 11: XLOOKUP, SORT, UNIQUE

Text-only quiz: Ch. 11: XLOOKUP, SORT, UNIQUE

excel_formulas_en

Translate

Want to study this quiz?

Copy it to your free Gradiuz library and make it your own.

Make your own from a PDF

Question 1

The TRIM function in Excel removes both ASCII space characters and non-breaking spaces.

True
False

Question 2

Which type of space character does the TRIM function solely eliminate from text?

Non-breaking space (code 160)
ASCII space character (code 32)
Tab character
Line break character

Question 3

To remove non-breaking spaces from text, you can utilize the __________ function along with TRIM.

Fill in the blank

Question 4

Which formula correctly removes non-breaking spaces from the text in cell A1?

=CLEAN(A1)
=TRIM(SUBSTITUTE(A1, CHAR(160), " "))
=REMOVE(A1, 160)
=TRIM(A1)

Question 5

The TRIM function is primarily used for complex numerical calculations.

True
False

Question 6

The XLOOKUP function is considered an enhanced and adaptable alternative to which previous Excel functions?

SUMIF and COUNTIF
VLOOKUP and HLOOKUP
INDEX and MATCH
IF and IFERROR

Question 7

The XLOOKUP function is used for searching and retrieving data in a table or range based on __________ criteria.

Fill in the blank

Question 8

The XLOOKUP function can only search for values within a single column.

True
False

Question 9

In the XLOOKUP function, what does the `lookup_array` argument represent?

The array or range from which to retrieve a value.
The value to search for.
The array or range where you would like to search for the lookup_value.
The value to return if no match is found.

Question 10

Which XLOOKUP argument refers to the array or range that you wish to retrieve a value from?

lookup_value
lookup_array
Return_array
if_not_found

Question 11

The `Return_array` argument in XLOOKUP refers to the array or range that you wish to __________ a value from.

Fill in the blank

Question 12

What happens if the `if_not_found` argument is omitted in XLOOKUP and the `lookup_value` is not found?

An error will be returned
A blank cell is returned
The first value in the lookup array is returned
0 is returned

Question 13

If the `if_not_found` argument is omitted in XLOOKUP and the `lookup_value` is not found, what will be returned?

Fill in the blank

Question 14

Which `match_mode` value in XLOOKUP specifies an exact match or the next smaller item?

-1
0
1
2

Question 15

What is the default `match_mode` for the XLOOKUP function?

0
1
-1
2

Question 16

The `match_mode` value of 2 in XLOOKUP allows for wildcard matching.

True
False

Question 17

Which `search_mode` value in XLOOKUP performs a binary search in descending order?

-2
1
-1
2

Question 18

What is the default `search_mode` for the XLOOKUP function?

1
-1
2
-2

Question 19

A `search_mode` of -1 in XLOOKUP means the search order is reversed, starting from the most recent item.

True
False

Question 20

What is the primary purpose of the SORT function in Microsoft Excel?

organizing and arranging data within a range or array
performing mathematical calculations
filtering data based on conditions
concatenating text strings

Made with Gradiuz

Turn any PDF into quizzes, flashcards and summaries - free.

Try it yourself