placeholder image to represent content

Unit Test

Quiz by Mark Kevin Garcia

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

Correct quiz answers unlock more play!

New Quizalize solo game modes
50 questions
Show answers
  • Q1
    A program designed to create spreadsheets which can later be used to analyze statistical data.
    Microsoft PowerPoint
    Adobe Photoshop
    Microsoft Word
    Microsoft Excel
    60s
  • Q2
    A function that adds a range of cells
    total
    sum
    plus
    add
    60s
  • Q3
    A function that gets the average of a range of cells
    median
    sum
    mean
    average
    60s
  • Q4
    Which of the following is not the part of the syntax for AVERAGEIF?
    Logical Test
    range
    Average range
    Criteria
    60s
  • Q5
    A function used to count the number of cells that contains something in them of a range of cells.
    average
    count
    sum
    sumif
    60s
  • Q6
    A function used to compute for the average of a range if a certain condition is met
    average
    averageif
    sum
    sumif
    60s
  • Q7
    A value of label that determines if a cells is a part of the range to be averaged..
    averagerange
    Average range
    criteria
    range
    60s
  • Q8
    Which of the following is the correct format in writing the range of cells?
    E1:E8
    E1,E8
    E1..E8
    E1;E8
    60s
  • Q9
    The bar that displays the contents of a cell
    Content Bar
    Display Bar
    Formula Bar
    Cell Bar
    60s
  • Q10
    To open Microsoft Excel, Press “Windows Logo” + R then type _________ then press enter.
    msexcel
    Xcel
    excel
    MicrosoftExcel
    60s
  • Q11
    It makes complex data become more visually appealing to the average user.
    tables
    infographics
    slideshows
    piktocharts
    60s
  • Q12
    The file jpeg stands for
    Joint Photographic Experts Group
    Jotter Prime Element Garnish
    Japan Photo Excellence Guild
    Joint Photographer Experts Group
    60s
  • Q13
    This file format supports image transparency but not animation
    BMP
    JPEG
    GIF
    PNG
    60s
  • Q14
    What image format are you going to use if you want to provide high-quality photographs?
    JPG
    GIF
    PNG
    BMP
    60s
  • Q15
    Remove unwanted or distracting areas, improve the composition, or help emphasize a focal point.
    cropping
    cloning
    Filters
    Compression and Resizing
    60s

Teachers give this quiz to your class