EXCEL POP QUIZ
Quiz by NURUL ASHIKIN BINTI ABD SAMAD
Feel free to use or edit a copy
includes Teacher and Student dashboards
Measure skillsfrom any curriculum
Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
- edit the questions
- save a copy for later
- start a class game
- automatically assign follow-up activities based on students’ scores
- assign as homework
- share a link with colleagues
- print as a bubble sheet
- Q1
The intersection of a row and a column is called a ________.
sum
worksheet
chart
cell
30s - Q2
A group of cells is called a ________.
cell range
cluster
chart
multi cell
30s - Q3
Where is the fill handle located?
At the bottom right corner of selected cell
At the right side of the Home tab
At the Backstage view
At the beginning of each formula
30s - Q4
In this image, why does the value in cell G1 look slightly different from the value in the formula bar?
It is using cell range
It is using conditional formatting
It is using formula
It is using currency number format
30s - Q5
You can click the tabs at the bottom of a workbook to switch between ________.
formula
permission
number format
worksheet
30s - Q6
Let’s say you’re trying to find your average grade. What’s wrong with the formula shown in the image?
it should use quotation mark instead of bracket
it should have equal sign (=) at the beginning of formula
nothing wrong with the formula
it should use COUNT formula
30s - Q7
True or False: You can view a formula by double-clicking the cell that contains the formula.
truefalseTrue or False30s - Q8
Which of the following is an cell reference?
A2
#A2
A2$
A:2
30s - Q9
Which of the formulas below are valid?
=A2+B2
4B=B3
A2/B4
= 2B + 2A
30s - Q10
What value would Excel return for this formula? =(82-32)/5+8*2
7.69
91.6
36
26
30s