Google Sheets FILTER Formula Quiz

What is the purpose of using the '+' operator in a FILTER formula?

• To multiply values in the dataset

• To concatenate text strings

• To apply OR logic between criteria

• To add numbers in the filtered data

How can you remove duplicates from a filtered list in Google Sheets?

• By using the DELETE function

• By sorting the data

• By using the REMOVE function

• By applying the UNIQUE function

What is the role of the comma in a FILTER formula?

• It acts as an OR operator

• It separates different formulas

• It acts as an AND operator

• It is used to concatenate strings

What is the effect of using braces in a FILTER formula?

• It highlights the filtered data

• It creates a new sheet

• It defines an array of columns

• It groups multiple criteria together

How can you dynamically refer to a column name in a FILTER formula?

• By applying the CONCATENATE function

• By nesting FILTER inside another FILTER

• By using the VLOOKUP function

• By using the INDIRECT function

Which function can be used to calculate the total of filtered payments?

• SUM

• AVERAGE

• COUNT

• PRODUCT

What function can be used to handle errors in a FILTER formula?

• ERROR

• ERRORCHECK

• ISERROR

• IFERROR

How can you ensure that only non-empty results are shown in a FILTER output?

• By applying the EMPTY function

• By using the NOT function

• By using the ISBLANK function

• By applying the LEN function as a criteria

What is the purpose of the ARRAYFORMULA function?

• To expand a formula across an entire column

• To create a new array from existing data

• To apply a formula to a single cell

• To sort data in ascending order

How can you remove zeros from the results of an ARRAYFORMULA?

• By applying a filter to exclude zeros

• By using the SUBSTITUTE function

• By manually deleting the zeros

• By using a combination of IF and LEN functions