![placeholder image to represent content](/_next/image?url=%2Fassets%2Fquiz_default_logo.jpg&w=256&q=75)
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
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
20 questions
Show answers
- Q1What allows you to summarize large amounts of data in Microsoft Excel?Pivot tableIF functionSUM formulaVLOOKUP30s
- Q2What function in Microsoft Excel allows you to create graphical representations of data from a pivot table?Pivot ChartLine chartBar chartScatter chart30s
- Q3What is the keyboard shortcut to refresh a pivot table in Microsoft Excel?Alt + F5F5Ctrl + Alt + F9Ctrl + R30s
- Q4Which of the following statements about a pivot table in Microsoft Excel is true?It can only be used with numerical dataIt is only used for basic calculationsIt can help you analyze large amounts of data quicklyIt is not compatible with functions such as sorting and filtering30s
- Q5What 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 ExcelA pivot table is a table that summarizes data while a pivot chart is a graphical representation of the pivot tableA pivot table is used for numerical data while a pivot chart is used for text dataA pivot table is a graphical representation of data while a pivot chart is a table that summarizes data30s
- Q6What is the purpose of data validation in Microsoft Excel?To create a pivot table from a range of dataTo merge and center cells in a worksheetTo calculate the sum of a range of cellsTo restrict the type of data that can be entered in a cell or range of cells30s
- Q7What 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
- Q8What 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
- Q9What 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
- Q10What 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
- Q11What 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
- Q12Which function in Microsoft Excel capitalizes the first letter of each word in a text string?TrimLowerUpperProper30s
- Q13What does the TRIM function in Microsoft Excel do?Converts text to lowercaseRemoves extra spaces from a text stringCapitalizes the first letter of each word in a text stringConverts text to uppercase30s
- Q14Which function in Microsoft Excel converts text to lowercase?TrimProperUpperLower30s
- Q15Which function in Microsoft Excel changes the capitalization of all letters in a text string to uppercase?LowerTrimUpperProper30s