  MS EXCEL

Quiz by Joriel Cruz

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

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

Correct quiz answers unlock more play!  10 questions
• 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

Teachers give this quiz to your class