MS EXCEL | Quizalize

placeholder image to represent content

MS EXCEL

Quiz by Joriel Cruz

Feel free to use or edit a copy

includes Teacher and Student dashboards

Measure skills
from any curriculum

Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.

With a free account, teachers can

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

Q 1/10
Score 0
What Microsoft office program is designed to create spreadsheets which can later be used to analyze statistical data?
29

MS Word
MS OneNote
MS Publisher
MS Excel

Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

New Quizalize solo game modes

10 questions

Show answers

Q1
What Microsoft office program is designed to create spreadsheets which can later be used to analyze statistical data?
MS Word
MS OneNote
MS Publisher
MS Excel
60s
Q2
What should you type into an empty cell to start a formula?)
*
(
=
^
60s
Q3
To divide 853 by 16 in a formula in Excel, you would use what sign should you use?
*
+
-
/
60s
Q4
In figure 1.3, what is the name of the cell where the age of John is located?
B3
B2
B1
B4
60s
Q5
What formula will you use in getting the sum of values 4 and 3?
=B1+C1
=A1+A2
=SUM(A1:C1)
=A1+B1
60s
Q6
What is the correct average function in computing the average value of number of examinees from the month of January to March ?
=AVE(B2+B3+B4)/3
=AVERAGE(B2:B4)/3
=AVERAGE(B2:B4)
=AVE(B2+B3+B4/3)
60s
Q7
How will you compute the total sales ?
=TOTAL(D4:D13
=SUM(D4:D13)
=SUM(D4-D13)
=SUM(D4+D13)
60s
Q8
How will you get the number of items under Food category
=COUNTIF(”Food”,C4:C13)
=COUNTIF(C4:C13,”Food”)
=COUNTIF(B4:B13.”Food”)
=COUNTIF(“Food”)
60s
Q9
A ______________ is an expression which calculates the value of a cell.
Slide
Formula
Cell
Functions
60s
Q10
If you will compute the average sales of Non-food, what will be your range in your AVERAGEIF formula?
D4:D13
B4:B13
C4:C13
“Non-food”
60s