NEW
Font size
WorksheetsADVANCED EXCEL
Total questions: 30
Worksheet time: 15mins
What is the purpose of a Pivot Table in Excel?
To summarize and analyze data
To create macros
To apply formatting only
To insert charts
Which feature allows combining data from multiple sheets into a single summary?
Goal Seek
Consolidation
Data Validation
Data Table
In PivotTables, “Show Values As → % of Row Total” is used to:
Display grand totals
Show each item as a percentage of its row total
Sort data in rows
Create filters
What is the function of a “Slicer” in PivotTables?
To change data formatting
To create charts
To filter data visually
To consolidate sheets
Pivot Charts are used to:
Automatically generate macros
Graphically represent Pivot Table data
Calculate subtotals
Create data models
To include external data in a PivotTable, you use:
Consolidate feature
Get & Transform Data / External Data Source
Goal Seek
Data Table
What is the purpose of “Show Value As → Running Total”?
To create filters
To calculate cumulative totals
To display averages
To show column totals
What is AutoFormat used for?
To automatically correct spelling
To apply a predefined style to a worksheet
To create charts
To merge cells
Conditional formatting allows you to:
Change cell color based on conditions
Create PivotTables
Consolidate data
Insert Macros
Macros in Excel are used to:
Automate repetitive tasks
Sort data
Create data tables
Filter charts
The difference between Relative and Absolute Macros is:
Absolute macros record exact cell references
Relative macros ignore cell references
Both record identical steps
None of the above
Which of the following statements about editing a macro is TRUE?
Macros cannot be edited
You can edit macros in the Visual Basic Editor
Macros are edited in PivotTable options
You must recreate macros to edit them
Conditional formatting can be applied to:
Only text cells
Any cells based on a condition
Only numeric cells
Only date cells
The Goal Seek tool is used to:
Find an unknown input to reach a desired output
Compare two datasets
Create Pivot charts
Merge cells
Scenario Manager allows you to:
Create charts
View different sets of input values and outcomes
Add conditional formatting
Run macros
Data Tables in What-if Analysis are used to:
Organize multiple possible outcomes
Apply data validation
Sort data
Filter records
Which of the following is NOT part of What-if Analysis tools?
Goal Seek
Scenario Manager
Data Table
Pivot Table
To create a PivotTable from multiple sheets, which option must you use?
Insert → PivotTable → Select Table Range
Data → Consolidate → Add Ranges → OK
Data → Remove Duplicates
Review → Share Workbook
You want to display each product’s sales as a percentage of the total column. Which step is correct?
Right-click value → Show Values As → % of Column Total
Add Data Bars in Conditional Formatting
Use SUMIF for total calculation
Apply Filter → Top 10%
In a PivotTable, to compare current year sales with previous year sales, which feature do you use?
Filter
Compare with Specific Field
Slicer
Goal Seek
To create a PivotChart for a PivotTable you already have:
Go to Insert → Chart → Select data manually
Click inside PivotTable → PivotChart → Choose chart type
Copy and paste into another sheet
None of the above
To apply a “Running Total” in a PivotTable, you should:
Add Calculated Field → Running Total
Right-click field → Show Values As → Running Total In
Create a formula manually in Excel
Use SUMPRODUCT
To record a new Macro, you must first:
Enable Developer Tab → Record Macro
Select all cells → Save Workbook
Turn on Conditional Formatting
Use AutoFormat command
You want to apply conditional formatting so that all values greater than 100 are highlighted in green. Which option should you use?
Format → Color Filter → Green
Conditional Formatting → Highlight Cell Rules → Greater Than → 100 → Green Fill
Data → Filter → Top 10
Insert → Shapes → Green Box
A “Relative Macro” records actions:
Based on exact cell addresses
Based on the current active cell position
Only for one worksheet
Using PivotTable settings
You want to find what value of Price will make Profit = ₹10,000. Which tool do you use?
Scenario Manager
Data Table
Goal Seek
Consolidate
In Goal Seek, which fields must you fill?
Set cell, To value, By changing cell
Source cell, Result cell, Output cell
Input field, Range field, Value cell
None of these
A one-variable Data Table changes:
One input value and shows multiple output results
Two inputs and one output
Multiple columns of unrelated data
None of these
Which step comes first when creating a Data Table?
Enter formula that refers to the input cell
Apply conditional formatting
Insert PivotTable
Rename sheet
To remove all scenarios in Scenario Manager, you should:
Delete worksheet
Click Scenario Manager → Select scenario → Delete
Use Goal Seek
Refresh data
