Combining Student Data in Sheets

What is the purpose of using the `ARRAYFORMULA` in Google Sheets?

• To apply a formula to a single cell

• To apply a formula to an entire column

• To sort data in ascending order

• To filter data based on a condition

Which function is used to look up and retrieve data from a specific column in a table?

• SUM

• VLOOKUP

• HLOOKUP

• INDEX

In the formula `=ARRAYFORMULA(A2:A &" - "& VLOOKUP(A2:A,"Names and Grades"!A:C,2,FALSE) &" - "& VLOOKUP(A2:A,"Names and Grades"!A:C,3,FALSE))`, what does `A2:A` represent?

• A single cell reference

• A range of cells in column A

• A specific row in column A

• A specific sheet name

What is the purpose of the `JOIN` function in Google Sheets?

• To combine text from multiple cells into one cell

• To split text into multiple cells

• To find the average of a range of cells

• To create a hyperlink

In the formula `=JOIN(" ",B2,C2)`, what does the `" "` represent?

• A comma

• A space

• A hyphen

• A period

Which of the following formulas correctly combines a student ID with their first and last name using two separate formulas?

• `=JOIN(" ",B2,C2)` and `=JOIN(" - ", A2, 'Names and Grades'!E2)`

• `=JOIN("-",B2,C2)` and `=JOIN(" ", A2, 'Names and Grades'!E2)`

• `=JOIN(" ",B2,C2)` and `=JOIN("-", A2, 'Names and Grades'!E2)`

• `=JOIN(" ",B2,C2)` and `=JOIN(" - ", A2, 'Names and Grades'!D2)`

What does the `FALSE` parameter in the `VLOOKUP` function indicate?

• The search should be case-sensitive

• The search should be case-insensitive

• The search should find an exact match

• The search should find an approximate match

How can you remove `#DIV/0!` errors from a data set in Google Sheets?

• Use the `IFERROR` function

• Use the `SUM` function

• Use the `AVERAGE` function

• Use the `COUNT` function

What is the correct syntax for using the `ARRAYFORMULA` function?

• `=ARRAYFORMULA(array_formula)`

• `=ARRAYFORMULA(array, formula)`

• `=ARRAYFORMULA(formula, array)`

• `=ARRAYFORMULA(array; formula)`

In the formula `=ARRAYFORMULA(VLOOKUP(L2:L,Descriptors!E:F,2,False))`, what does `Descriptors!E:F` represent?

• A single cell reference

• A range of cells in the current sheet

• A range of cells in the "Descriptors" sheet

• A specific row in the "Descriptors" sheet