Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
Give this quiz to my class
Q 1/21
Score 0
30
Q 2/21
Score 0
30
21 questions
Q.
1
30 sec
Q.
2
30 sec
Q.
3
30 sec
Q.
4
30 sec
Q.
5
30 sec
Q.
6
30 sec
Q.
7
30 sec
Q.
8
30 sec
Q.
9
30 sec
Q.
10
30 sec
Q.
11
30 sec
Q.
12
30 sec
Q.
A library spreadsheet has a list of book titles in column A and their genre in column B. To find the genre of a book by searching for its title, which function would be most effective?
13
30 sec
Q.
In a spreadsheet recording club members, column A contains names and column B contains their age. Which formula would calculate the total number of members whose names have been entered into the list?
14
30 sec
Q.
15
30 sec
Q.
A student is managing a spreadsheet for a school bake sale. Column A contains the name of the cake and Column B contains the quantity sold. Which formula should be used to calculate the total number of cakes sold only for the items named "Brownie"?
16
30 sec
Q.
17
30 sec
Q.
A student is creating a spreadsheet to track their pocket money savings. They want to find the total amount saved only on days where the category in column B is marked as "Gift". Which function should they use to add up the values in column C based on this condition?
18
30 sec
Q.
19
30 sec
Q.
A student is looking at a spreadsheet of a sports leaderboard. They want to retrieve the 'Team Name' from Column B by entering the 'Team ID' into a search box. Which function is designed to search vertically down the first column to find a match and return data from another column in that row?
