Font size
WorksheetsComputer 7 Lesson 11-12 Quiz
Total questions: 20
Worksheet time: 40mins
Function/statement on excel that applies an IF statement to determine whether or not to include the given cell in the COUNT
CountA
CountIF
Count
Discount
Function/statement on excel that count number of cells that are not empty; it counts the cells that contain character whether a letter, words, number or symbols.
CountA
CountIF
Count
CountB
Function/statement on excel that count the number of cells that have a numerical value inside of it. It does not consider that are empty or cells with non-numerical value.
CountA
CountIF
Count
CountB
It accommodates more conditions to check before deciding whether or not to perform the given operation.
IFS
IF
Count
CountA
If statement that average all the cells if the value matches the given condition. These statements can handle only one condition.
IFS
ProductIF
AverageIf
Sumif
If statement that multiply all the cells if the value matches the given condition. These statements can handle only one condition.
IFS
ProductIF
AverageIf
IF
Excel statements that performs the multiplication operation on the selected cells.
Product Statement
IF Statement
Sum Statement
Average Statement
In excel, what do you called the statement resulting from adding numerical value of the cell.
Product Statement
IF Statement
Sum Statement
Average Statement
If statement that add all the cells if the value matches the given condition. These statements can handle only one condition.
IF Statement
Productif
Sumif
Averageif
In excel, it is considered of a combination of two of the other statements namely Sum and Count statement.
Product Statement
Sum Statement
Average Statement
If statement
Given range J20:J30, create a formula on cell address J31 that count cells that are not empty and also count the cells that contain letters, words, number or symbols.
(a)
Given range O20:O30, create a formula on cell address O31 that count cells that are not empty and also count the cells that contain numerical value or numbers only
(a)
Given range S20:S30, create a formula on cell address S31 that add all the cell if the value is greater than or equal to 10
(a)
Given range H20:H30, create a formula on cell address H31 that add all the cell if the value is greater than or equal to 10
(a)
Given range G20:G30, create a formula on cell address G31 that will get all the average of the cell if the value is greater than or equal to 22
(a)
Given range S20:S30, create a formula on cell address S31 that add all the cell if the value is less than or equal to 10
(a)
Given range G20:G30, create a formula on cell address G31 that will get all the average of the cell if the value is less than or equal to 22
(a)
Given range G20:G30, create a formula on cell address G31 that will get all the average of the cell if the value is greater than or equal to 22
(a)
Given range H20:H30, create a formula on cell address H31 that add all the cell if the value is greater than or equal to 50
(a)
Given range O20:O30, create a formula on cell address O31 that count cells that are not empty and also count the cells that contain numerical and not numerical value
(a)
