Quizalize logo
placeholder image to represent content

Microsoft Excel Sales Report Quiz

Quiz by secret guardian

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

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

Correct quiz answers unlock more play!

New Quizalize solo game modes
6 questions
Show answers
  • Q1
    1. What is the quickest way to find the sum of numbers in cells B4 to B8?
    Question Image
    B. Use the SUMIF formula.
    C. Use the SUMIFS formula.
    D. Highlight cells B4 to B8
    A. Use the SUM formula.
    20s
  • Q2
    2. What are the TWO ways to change the number for Final Fantasy 15 game, from 29 to 29.97 without having to retype the entire number?
    Question Image
    A. Click Cell C3 and click in the Formula bar and change.
    B. Double-click the Cell C3 and change the number.
    D. Both A and B are correct.
    C. Click the number in Cell C3 and type the number.
    20s
  • Q3
    3. How would you center the text, "Game Zoners Pte Ltd", in between cells B2 to E2?
    Question Image
    C. Click and drag Cell B2 till the text is in the center of B2 and E2.
    D. Not possible to center the text between B2 to E2.
    B. Highlight cell B2 and click Center Alignment icon.
    A. Highlight Cells B2 to E2 and click Merge and Center icon.
    20s
  • Q4
    4. What are the TWO ways to enter the value of Unit Price in cell C4, from the Games Database in Cell D13?
    Question Image
    D. Both B and C are correct.
    C. Click on Cell D13, press Ctrl C, click on Cell C4 and press Ctrl V.
    A. Click on Cell C4 and type the value of the Unit Price.
    B. Click on Cell C4, type '=' symbol, click on Cell D13 and press Enter.
    20s
  • Q5
    5. Which of the following is the correct formula to calculate the Total Price in Cell E4?
    Question Image
    B. =C5*D5
    A. =AVERAGE(E5:E8)
    D. =C4*D4
    C. =SUM(E5:E8)
    20s
  • Q6
    6. Which of the following is the correct steps to find the Total Sales for Playstation in Cell C4?
    Question Image
    C. Enter the formula '=SUM(D10:D19)
    D. Enter the formula '=COUNTIF(D10:D19,"Playstation")
    A. Calculate all the Total Price for Playstation using calculator and enter value in Cell C4.
    B. Click on Category, Filter launch button, unselect 'Select All' box, select 'Playstation' Box and highlight the Total Price cells.
    20s

Teachers give this quiz to your class