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/50
Score 0
Function that count the number of cell that fits with the criteria within the range
30
=COUNT(range)
=COUNTIF(range, criteria)
=ISODD(x)
=ISEVEN(x)
Q 2/50
Score 0
Function that counts the number of cell containing a number within a range
30
=COUNT(range)
=ISODD(x)
=ISEVEN(x)
=COUNTIF(range, criteria)
50 questions
Q.
Function that count the number of cell that fits with the criteria within the range
1
30 sec
Q.
Function that counts the number of cell containing a number within a range
2
30 sec
Q.
Function that joins x and y
3
30 sec
Q.
Function that removes extra spaces in x
4
30 sec
Q.
Function that returns the absolute value of x
5
30 sec
Q.
Function that returns the average of x and y
6
30 sec
Q.
Function that returns the characters of x specified by y (from the left)
7
30 sec
Q.
Function that returns the characters of x specified by y (from the right)
8
30 sec
Q.
Function that returns the column number of x
9
30 sec
Q.
Function that returns the current date
10
30 sec
Q.
Function that returns the current date and time
11
30 sec
Q.
Function that returns the difference of x subtracted by y
12
30 sec
Q.
Function that returns the largest number between x and y
13
30 sec
Q.
Function that returns the largest number within the range
14
30 sec
Q.
Function that returns the length of characters in x
15
30 sec
Q.
Function that returns the product of x and y
16
30 sec
Q.
Function that returns the product of x and y
17
30 sec
Q.
Function that returns the proper casing of x
18
30 sec
Q.
Function that returns the quotient of x divided by y
19
30 sec
Q.
Function that returns the quotient of x divided by y
20
30 sec
Q.
Function that returns the row number of x
21
30 sec
Q.
Function that returns the smallest number between x and y
22
30 sec
Q.
Function that returns the smallest number within the range
23
30 sec
Q.
Function that returns the square root of x
24
30 sec
Q.
Function that returns the sum of x and y
25
30 sec
Q.
Function that returns the sum of x and y or (all the numbers within the range)
26
30 sec
Q.
Function that returns the value of pi
27
30 sec
Q.
Function that returns the value of x raised to the power of y
28
30 sec
Q.
Function that returns true if x is a number
29
30 sec
Q.
Function that returns true if x is a text
30
30 sec
Q.
Function that returns true if x is an even number
31
30 sec
Q.
Function that returns true if x is an odd number
32
30 sec
Q.
Function that returns x if the condition is true, else it returns y
33
30 sec
Q.
Function that returns x in all capital form
34
30 sec
Q.
Function that returns x in non- capital form
35
30 sec
Q.
Function that rounds x to a specified number of digits (y)
36
30 sec
Q.
It allows users to organize data in rows and columns and perform calculations on the data
37
30 sec
Q.
It is a highly innovative and versatile program that can ensure a successful communication whether you’re presenting in front of potential investors, a lecture theatre or simply in front of your colleagues.
38
30 sec
Q.
It is an expression which calculates the value of a cell.
39
30 sec
Q.
It is the bar that displays the contents of a cell
40
30 sec
Q.
It is the box at the top of each column containing a letter
41
30 sec
Q.
It is the cell address of the cell usually combine letter and number (ex. A1, B4, C2)
42
30 sec
Q.
It is the combining or joining two or more cells
43
30 sec
Q.
It is the horizontal line of entries in a table.
44
30 sec
Q.
It is the place where information is held in a spreadsheet
45
30 sec
Q.
It is the row number
46
30 sec
Q.
It is the selected cell.
47
30 sec
Q.
It is the vertical line of entries in a table.
48
30 sec
Q.
These are predefined formulas and are already available in Excel
49
30 sec
Q.
To present information and ideas in an interactive and interesting way