Quizalize logo
placeholder image to represent content

Analysing data with Excel- Day 4 Visualising Data & EPA practice

Quiz by Ashlie Ryan

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
11 questions
Show answers
  • Q1

    What is the name of the tool used in Microsoft Excel to perform mathematical calculations and display the results in a table format?

    Pivot Table

    Formula Bar

    VLOOKUP

    Solver

    30s
  • Q2

    What is the keyboard shortcut to auto-fit the column width in Microsoft Excel?

    Ctrl + W

    Ctrl + 1

    Ctrl + Shift + W

    Ctrl + 0

    30s
  • Q3

    How do you add a new sheet in Microsoft Excel?

    Go to the Insert tab and select "Table"

    Right-click on an existing sheet and select "Insert Sheet"

    Right-click on the tab bar and select "Insert Sheet"

    Go to the Home tab and click on "New Sheet"

    30s
  • Q4

    What is the keyboard shortcut to insert a new row in Microsoft Excel?

    Ctrl + Shift + +

    Ctrl + +

    Ctrl + R

    Ctrl + Shift + R

    30s
  • Q5

    How do you freeze the top row in Microsoft Excel so that it is always visible when scrolling?

    Go to the View tab and select "Freeze Panes"

    Go to the Home tab and select "Freeze Top Row"

    Go to the View tab and select "Freeze Top Row"

    Right-click on the top row and select "Freeze Row"

    30s
  • Q6

    What is the keyboard shortcut to sort a range of cells in Microsoft Excel?

    Ctrl + Shift + S

    Alt + Shift + S

    Ctrl + S

    Alt + S

    30s
  • Q7

    What is the name of the tool used in Microsoft Excel to find and replace text in a worksheet?

    Find and Replace

    Flash Fill

    Text to Columns

    Go To

    30s
  • Q8

    What is the keyboard shortcut to apply bold formatting to a selected range of cells in Microsoft Excel?

    Ctrl + Shift + B

    Alt + B

    Alt + Shift + B

    Ctrl + B

    30s
  • Q9

    What is the shortcut to quickly sum a range of cells in Excel? 

    Ctrl + S 

    Ctrl + U 

    Ctrl + D 

    Ctrl + Alt + =

    30s
  • Q10

    How do you create a chart in Excel?

    Go to Data > Chart

    Go to Insert > Chart

    Go to Home > Chart

    Go to Page Layout > Chart

    30s
  • Q11

    How do you apply conditional formatting in Excel?

    Go to Data > Conditional Formatting

    Go to Page Layout > Conditional Formatting

    Go to View > Conditional Formatting

    Go to Home > Conditional Formatting

    30s

Teachers give this quiz to your class