Y8_T2_L5_level up your data skills

How is data sorted in a spreadsheet?

• A-Z or Z-A

• A-Z

• By column name

• By row name

What does filtering in a spreadsheet allow you to do?

• allows you to delete specific data

• allows you to add specific data

• allows you to find specific data

• allows you to edit specific data

Which AVERAGE formula is correct?

• =average(D:F)

• =average(D4:D23)

• average(D11,D22)

• average(D7:D21)

What does the COUNTIF formula do?

• counts the columns

• counts the number of rows and columns

• counts how many of a certain item there are

• counts the data

Which is the correct IF formula?

• =IF(D5>9,"Well done","Try harder")

• IF(D5<50,"Score is okay","Great score")

• =IF("Score is okay",D3>20)

• =IF("Score is good","Try harder",B7)

What is the purpose of the VLOOKUP function?

• To look up a value in a table and return a corresponding value

• To count the number of cells that meet a criterion

• To sum a range of cells

• To find the maximum value in a range

Which formula correctly calculates the sum of cells A1 to A10?

• =SUM(A1:A10)

• =ADD(A1:A10)

• =TOTAL(A1:A10)

• =SUMMATION(A1:A10)

What does the CONCATENATE function do?

• Combines the contents of multiple cells into one cell

• Splits the contents of a cell into multiple cells

• Calculates the average of a range of cells

• Finds the minimum value in a range