placeholder image to represent content

Excel Pivot and other Function Review 2

Quiz by Anawelyn Bacar

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
20 questions
Show answers
  • Q1
    What allows you to summarize large amounts of data in Microsoft Excel?
    Pivot table
    IF function
    SUM formula
    VLOOKUP
    30s
  • Q2
    What function in Microsoft Excel allows you to create graphical representations of data from a pivot table?
    Pivot Chart
    Line chart
    Bar chart
    Scatter chart
    30s
  • Q3
    What is the keyboard shortcut to refresh a pivot table in Microsoft Excel?
    Alt + F5
    F5
    Ctrl + Alt + F9
    Ctrl + R
    30s
  • Q4
    Which of the following statements about a pivot table in Microsoft Excel is true?
    It can only be used with numerical data
    It is only used for basic calculations
    It can help you analyze large amounts of data quickly
    It is not compatible with functions such as sorting and filtering
    30s
  • Q5
    What is the difference between a pivot table and a pivot chart in Microsoft Excel?
    There is no difference between a pivot table and a pivot chart in Microsoft Excel
    A pivot table is a table that summarizes data while a pivot chart is a graphical representation of the pivot table
    A pivot table is used for numerical data while a pivot chart is used for text data
    A pivot table is a graphical representation of data while a pivot chart is a table that summarizes data
    30s
  • Q6
    What is the purpose of data validation in Microsoft Excel?
    To create a pivot table from a range of data
    To merge and center cells in a worksheet
    To calculate the sum of a range of cells
    To restrict the type of data that can be entered in a cell or range of cells
    30s
  • Q7
    What is the function of the COUNT formula in Microsoft Excel?
    It inserts a page break into the worksheet.
    It calculates the median value of a range of cells.
    It counts the number of cells in a range that contain numbers.
    It changes the background color of selected cells.
    30s
  • Q8
    What is the function of the VLOOKUP formula in Microsoft Excel?
    It deletes the contents of a selected cell.
    It formats selected cells as bold text.
    It searches for a value in the first column of a table and returns a corresponding value from a specified column.
    It inserts a new worksheet into the workbook.
    30s
  • Q9
    What is the function of the AVERAGE formula in Microsoft Excel?
    It calculates the arithmetic mean of a range of cells.
    It deletes a worksheet from the workbook.
    It changes the font size of selected cells.
    It inserts a hyperlink into the worksheet.
    30s
  • Q10
    What is the function of the LEFT formula in Microsoft Excel?
    It rounds a number up to the nearest integer.
    It converts a text string to uppercase.
    It returns a specified number of characters from the beginning of a text string.
    It multiplies a range of cells by a specified number.
    30s
  • Q11
    What is the function of the NOW formula in Microsoft Excel?
    It returns the current date and time.
    It sorts data in descending order.
    It fills a range of cells with a series of numbers.
    It converts a number to a percentage.
    30s
  • Q12
    Which function in Microsoft Excel capitalizes the first letter of each word in a text string?
    Trim
    Lower
    Upper
    Proper
    30s
  • Q13
    What does the TRIM function in Microsoft Excel do?
    Converts text to lowercase
    Removes extra spaces from a text string
    Capitalizes the first letter of each word in a text string
    Converts text to uppercase
    30s
  • Q14
    Which function in Microsoft Excel converts text to lowercase?
    Trim
    Proper
    Upper
    Lower
    30s
  • Q15
    Which function in Microsoft Excel changes the capitalization of all letters in a text string to uppercase?
    Lower
    Trim
    Upper
    Proper
    30s

Teachers give this quiz to your class