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/28
Score 0
In Google Sheets, what will the formula =IF(A1>10, 'Above 10', IF(A1>5, 'Above 5', '5 or below')) return if A1 is 7?
30
5 or below
Above 10
Above 5
Error
Q 2/28
Score 0
Using the formula =IF(B1='Pass', 'Congratulations', IF(B1='Fail', 'Better luck next time', 'Unknown Status')) what will the output be if B1 contains 'Fail'?
30
Error
Better luck next time
Unknown Status
Congratulations
28 questions
Q.
In Google Sheets, what will the formula =IF(A1>10, 'Above 10', IF(A1>5, 'Above 5', '5 or below')) return if A1 is 7?
1
30 sec
Q.
Using the formula =IF(B1='Pass', 'Congratulations', IF(B1='Fail', 'Better luck next time', 'Unknown Status')) what will the output be if B1 contains 'Fail'?
2
30 sec
Q.
What will the formula =IF(C1>=90, 'A', IF(C1>=80, 'B', IF(C1>=70, 'C', 'F'))) return if C1 is 85?
3
30 sec
Q.
In the formula =IF(A1='Yes', 1, IF(A1='No', 0, -1)), what result will be returned if A1 is 'Maybe'?
4
30 sec
Q.
Which of the following formulas will count how many times the score '100' appears in the cells E1:E50?
5
30 sec
Q.
In Google Sheets, which formula would correctly count the number of cells in the range F1:F30 that contain the word 'Incomplete'?
6
30 sec
Q.
What formula would you use to count all cells in the range G1:G50 that are greater than or equal to 60?
7
30 sec
Q.
In Google Sheets, which function would you use to count the number of times a specific condition is met in two different ranges?
8
30 sec
Q.
Which of the following is a valid example of a COUNTIFS formula in Google Sheets?
9
30 sec
Q.
Which of the following statements is true about the COUNTIFS function?
10
30 sec
Q.
Which formula in Google Sheets would you use to find the largest number in the range B1 to B5?
11
30 sec
Q.
In Google Sheets, if you have a range of numbers from A1 to A5 (3, 7, 2, 9, 5), what is the result of the formula =AVERAGE(A1:A5)?
12
30 sec
Q.
If you want to calculate the total sum of numbers in cells C1, C2, and C3 in Google Sheets, which formula would you use?
13
30 sec
Q.
What is the result of the formula =MIN(D1:D4) if the values in D1, D2, D3, and D4 are 12, 5, 8, and 3 respectively?
14
30 sec
Q.
In a Google Sheets table, if you apply the formula =SUM(F1:F10) and the values in cells F1 through F10 are 4, 3, 7, 2, 10, 5, 8, 6, 9, and 1, what is the result?
15
30 sec
Q.
Which formula would you use in Google Sheets to find the smallest value in cells A1 through A6 containing the numbers 15, 22, 8, 19, 3, and 11?
16
30 sec
Q.
If the values in cells G1 to G4 are 20, 25, 30, and 15, what will the formula =MAX(G1:G4) return?
17
30 sec
Q.
In Google Sheets, what function do you use to search for a value in a table and return a corresponding value from another column?
18
30 sec
Q.
What is the correct syntax for the VLOOKUP function in Google Sheets?
19
30 sec
Q.
What will happen if you set the fourth parameter of the VLOOKUP function to FALSE?
20
30 sec
Q.
If you wanted to retrieve the third column from a range in VLOOKUP, what should you enter as the index?
21
30 sec
Q.
What error will you get if the VLOOKUP function cannot find the value you are searching for?
22
30 sec
Q.
Which of the following is a common use for the VLOOKUP function in Google Sheets?
23
30 sec
Q.
In Google Sheets, which function would you use to sum values in a range based on a specific condition?
24
30 sec
Q.
25
30 sec
Q.
26
30 sec
Q.
What is the purpose of the sum_range argument in the SUMIF function?
27
30 sec
Q.
If you want to sum the sales amounts in column C when the corresponding value in column B is 'Apples', which formula would you use in Google Sheets?
