WorksheetsGoogle Sheet Chapter 5
Total questions: 18
Worksheet time: 17mins
XLOOKUP can look up values anywhere in a spreadsheet.
True
False
Is this the correct syntax for XLOOKUP(lookup_value, col_index_num, table_array)?
True
False
XLOOKUP finds a value and returns a result from another column.
Identify the formula for
XLOOKUP
=XLOOKUP(lookup_value, return_array, lookup_array, [if_not_found])
=XLOOKUP(lookup_value, lookup_array, [if_not_found])
=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found])
=XLOOKUP(lookup_array, lookup_value, return_array, [if_not_found]
What formula is used to find East_01?
=XLOOKUP(A11, B1:B9, TRUE)
=XLOOKUP(A11, A1:B9,B11)
=XLOOKUP(A11, A1:A9,A11)
=XLOOKUP(A11, A1:A9,B1:B9)
What is the correct formula for B4 aims at finding the given entity in A4?
=XLOOKUP(A4, B1:F1,B2:F2)
=XLOOKUP(B4, A1:F1,2)
=XLOOKUP(A4, B2:F2,B1:12)
=XLOOKUP(A4, A1:F2, A1:F2)
What is the correct formula in B8?
=XLOOKUP(A8, A1:A5, B1:B5)
=XLOOKUP(A8, A1:B5, B1:B5)
=XLOOKUP(A8, B1:B5, A1:B5)
What function is used to find price of Product_2 in B5?
xlookUp
sum
average
ylookUp
What is the main job of the XLOOKUP function?
To create colorful charts and graphs.
To alphabetize a list of names.
To find a specific item and return a related result.
To add up a column of numbers.
XLOOKUP formula to be used to get result in the highlighted cell, E3 is...
=YLOOKUP(D3,B2:B9,A2:A9)
=XLOOKUP(D3,B2:B9,A2:A9)
=YLOOKUP(D3,A2:A9,B2:B9)
=XLOOKUP(D3,A2:A9,B2:B9)
The first piece of information you give XLOOKUP is called the lookup_value. What is it?
The column where the answer should come from.
The item you are searching for.
The word "FALSE" for an exact match.
The title of your spreadsheet.
Which of these is the correct, basic order of arguments for XLOOKUP?
=XLOOKUP(lookup_array, lookup_value, return_array)
=XLOOKUP(return_array, lookup_array, lookup_value)
=XLOOKUP(lookup_value, lookup_array, return_array)
=XLOOKUP(return_array, lookup_value, lookup_array)
The [if_not_found] argument is optional. What does it let you do?
Change the color of the result cell.
Make the search faster.
Show a friendly message like "Not Found" if the search fails.
Look for numbers instead of text.
In the formula =XLOOKUP("Mars", A2:A10, B2:B10), what does B2:B10 represent?
The list of planets we are searching through.
The range where the answer will be pulled from.
The cell where we are typing the formula.
A special code for exact match.
Which item is FALSE regarding charts in Google Sheets?
You can create pie and line charts.
Charts can't be inserted on their own sheet.
You can change the chart title.
You can put a background color on your chart.
If you want to create a graph, what is the first step after typing in the data?
Select the chart button
Select the data by highlighting it
Go to Chart Editor
Go to Series
How can you change the type of graph?
Go to the Insert tab
Go to Chart Editor
Go to the Functions button
