NEW
Font size
WorksheetsQuiz for Day 4
Total questions: 15
Worksheet time: 11mins
Which chart type is best for showing trends over time?
Pie Chart
Column Chart
Line Chart
Scatter Plot
Which Excel chart is best for showing the correlation between two numeric variables?
Bar Chart
Area Chart
Scatter Plot
Pie Chart
What is the minimum number of data points needed to create a chart in Excel?
4
2
3
1
A bar chart and a column chart are exactly the same.
The legend in a chart shows the categories of data.
What is the main purpose of a Pivot Table in Excel?
To sort data alphabetically
To delete duplicate entries
To summarize and analyze large datasets
To create charts only
In a Pivot Table, what does the 'Values' area represent?
Column headings
Filters for slicing data
Summary calculations like counts, sums, etc.
Graph titles
What happens when you drag a field into both the 'Rows' and 'Values' areas?
An error message appears
Excel hides the field
It creates a detailed breakdown for that field
It creates a pie chart
Which of the following can you NOT do directly in a Pivot Table?
Filter data
Format cells
Manually enter new data into the table
Sort rows
You can add multiple fields to the Values area of a Pivot Table.
Scenario:
You are analyzing hospital patient records. You want to see the number of patients treated by each department.
Question:
Where should you drag the Department field in the Pivot Table?
Values
Columns
Rows
Filters
You can type directly into a Pivot Table cell to change the value.
What is the purpose of Conditional Formatting in Excel?
To apply mathematical formulas to cells
To automatically format cells based on criteria
To merge cells based on content
To sort data alphabetically
What does the formula =A1>100 do when used in Conditional Formatting?
Highlights A1 only
Highlights all cells with value exactly 100
Highlights cells with values less than 100
Highlights cells with values greater than 100
How can you highlight only the duplicate values in a column using Conditional Formatting?
Sort the column and highlight manually
Use Highlight Cell Rules → Duplicate Values
Use Remove Duplicates
Insert a formula manually
