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 skillsfrom 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!

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