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/15
Score 0
It is used to get the total of all the values from the range of cells.
30
MAX
SUM
MIN
AVERAGE
Q 2/15
Score 0
It is used to get the least value from the range of values.
30
COUNT
MAX
MIN
SUM
15 questions
Q.
It is used to get the total of all the values from the range of cells.
1
30 sec
Q.
It is used to get the least value from the range of values.
2
30 sec
Q.
It is used to get the average value from the range of values.
3
30 sec
Q.
It is used to get the greatest value from the range of values.
4
30 sec
Q.
It is used to add all cells that meet certain criteria.
5
30 sec
Q.
It is used to count cells that meet certain criteria.
6
30 sec
Q.
It is used to prevent cell references from adjusting when it is copied to another cell.
7
30 sec
Q.
In the formula =IF(D6>=1000,”Spender”,”Saver”), what is the output if the condition is true?
8
30 sec
Q.
Which of the following is the correct format in writing the range of cells?
9
30 sec
Q.
[Total Amount per Week] is computed as [Amount per Day] multiplied by 7. Which of the following formulas are you going to type in cell C2?
10
30 sec
Q.
[Total Amount Saved per Week] is deducting [Total Amount Spent per Week] from [Total Allowance per Week]. Which of the following formulas are you going to type in cell E2?
11
30 sec
Q.
[Overall Total Allowance per Week] is adding all the [Total Allowance per Week]. Which of the following formulas are you going to type in cell C6?
12
30 sec
Q.
[Overall Total Amount Saved per Week] is adding all the [Total Amount Saved per Week]. Which of the following formulas are you going to type in cell E6?
13
30 sec
Q.
To be typed in cell C8, which of the following formulas is used to get the minimum total amount saved per week?
14
30 sec
Q.
In the formula =IF(D6>=1000,”Spender”,”Saver”), what is the output if the condition is true?