Foxoyo
Hey..!!
Excel Pivot Tables
Practice
MCQs
Quizzes
About
Leaderboard
Amazon Books
6
MCQs
0
Attempts
0 %
Accuracy
share
Filter by
Type here
Apply
Under which tab and in which function group will you find the option to insert a Pivot Table
In the Data group in the Pivot Tables group
Under the Insert tab in the Tables group
Under the Formulas tab in the Data Analysis group
In the Data group in the Tables group
Which of the following is NOT a box in the PivotTable Fields List
Column Labels
Formulas
Report Filter
values
Which function will you use to enter current time in a worksheet cell
=now()
=time()
=currentTime()
=today()
What is the first step for creating a Pivot Table
Clicking on the Insert Tab and inserting a Pivot Table
None of the above
Create or select data that needs to be analyzed
Deciding on which fields (column and row labels) to use to analyze the data
What command allows you to highlight the cell(s) in a data table that matches your set-up information
Conditional Formatting
Cell Styles
Data Table Styles
AutoFormatting
What is the purpose of using a pointer in a data table
It allows the array formula to be repositioned
It highlights the first cell with a potential error
It resets the file location to a recognized folder
It highlights the cell that matches the source data
1
take a quick Quiz
Practice mcqs on Excel Pivot Tables
Let's start
pick difficulty level
all
1
2
3
4
5
6
Mcqs
0
attempts
0
followers
Related Topics
Excel Pivot Tables
Advanced Excel
SQL Pivot
CSS Properties Elements Functions Tables
MySQL Database Tables and Datatypes
Data Structure Hash Tables
HTML Tables
Data Tables and Types
Truth Tables
Data Tables in Statistics
Suggested Books
Javascript is disabled
we serve best when javscript is enabled
Enable