MS EXCEL

Quiz by Joriel Cruz

Feel free to use or edit a copy

includes Teacher and Student dashboards

### Measure skillsfrom any curriculum

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

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

Correct quiz answers unlock more play!

10 questions

Show answers

- Q1What Microsoft office program is designed to create spreadsheets which can later be used to analyze statistical data?MS WordMS OneNoteMS PublisherMS Excel60s
- Q2What should you type into an empty cell to start a formula?)*(=^60s
- Q3To divide 853 by 16 in a formula in Excel, you would use what sign should you use?*+-/60s
- Q4In figure 1.3, what is the name of the cell where the age of John is located?B3B2B1B460s
- Q5What formula will you use in getting the sum of values 4 and 3?=B1+C1=A1+A2=SUM(A1:C1)=A1+B160s
- Q6What 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
- Q7How will you compute the total sales ?=TOTAL(D4:D13=SUM(D4:D13)=SUM(D4-D13)=SUM(D4+D13)60s
- Q8How 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
- Q9A ______________ is an expression which calculates the value of a cell.SlideFormulaCellFunctions60s
- Q10If you will compute the average sales of Non-food, what will be your range in your AVERAGEIF formula?D4:D13B4:B13C4:C13“Non-food”60s