Quizalize logo
placeholder image to represent content

Basic Spreadsheets and Formatting

Quiz by Paul

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
10 questions
Show answers
  • Q1
    If you want to sum the values in cells A1 to A10 in Google Sheets, which formula would you use?
    ADD(A1:A10)
    TOTAL(A1:A10)
    SUMMATION(A1:A10)
    SUM(A1:A10)
    30s
  • Q2
    What will be the result of the formula =2*3+4 in Google Sheets?
    6
    8
    12
    10
    30s
  • Q3
    Which feature in a spreadsheet allows you to combine multiple cells into one and center the content?
    Adjust Column Width
    Currency Formatting
    Merge and Center
    AutoFill
    30s
  • Q4
    What should you use to automatically fill a series of cells with a sequence based on a pattern or a formula?
    Cell Formatting
    Freeze Panes
    AutoFill
    Merge and Center
    30s
  • Q5
    Which of the following formats is used to display monetary values in a spreadsheet?
    Percentage Formatting
    Date Formatting
    Currency Formatting
    Text Formatting
    30s
  • Q6
    How can you adjust the width of a column in a spreadsheet to fit its content?
    Drag the column border
    Click on the AutoFill handle
    Use the Merge option
    Right-click and select Format
    30s
  • Q7
    What is the purpose of using the 'Wrap Text' feature in a spreadsheet cell?
    To display all text within a cell without cutting it off
    To convert text into a number
    To merge multiple cells into one
    To change the text color
    30s
  • Q8
    What is the purpose of changing the column width in a spreadsheet?
    To insert images into cells
    To apply border styles
    To format text as bold
    To ensure that all data in the column is fully visible
    30s
  • Q9
    What happens when you merge cells in a spreadsheet?
    All data in the cells is deleted
    Only the leftmost cell retains its data
    The selected cells become a single cell that can contain a large amount of text
    The cells become non-editable
    30s
  • Q10
    Which option would you select to ensure that numbers are displayed with a dollar sign and two decimal places?
    Text Format
    Currency Format
    Date Format
    Percentage Format
    30s

Teachers give this quiz to your class