Font size
WorksheetsQuiz - Lesson 5
Total questions: 20
Worksheet time: 20mins
What is a chart in Microsoft Excel?
A type of formula
A visual representation of worksheet data
A formatting tool
A data entry method
Which chart type is best for comparing values across categories using vertical bars?
Bar
Line
Column
Pie
A Pie chart is most useful when:
Values are negative
Data represents trends over time
You have multiple data series
Values add up to a total
Which chart type is used to display trends over time?
Line
Scatter
Column
Bar
The Scatter chart is best for:
Comparing multiple values
Showing the correlation between two data series
Displaying cumulative data
Representing hierarchical relationships
Which chart type emphasizes differences between multiple sets of data over time?
Pie
Radar
Area
Surface
A Sunburst chart represents data using:
A single line
Multiple rings with segment values
Bars and columns
X and Y axes
Which chart type requires four series of values in the order: Open-High-Low-Close?
Stock
Scatter
Surface
Radar
What is the main purpose of Sparklines in Excel?
To create a large chart
To summarize data in a compact visual format
To create hyperlinks
To replace formulas
Which of the following is NOT a type of Sparkline?
Line
Column
Pie
Win/Loss
The High Point function in Sparklines:
Highlights the lowest value in the group
Highlights the highest value in the group
Changes the chart type
Clears the Sparklines
To change the color of negative points in a Sparkline, which option is used?
Axis
Sparklines Color
Marker Color
Group
The Group option in Sparklines:
Shows arrows indicating dependent and precedent cells
Deletes all sparklines
Highlights the lowest point
Converts a Sparkline into a full chart
A hyperlink in Excel can link to:
Only text within a document
Only websites
Both text and graphics
Only other Excel worksheets
When assigning a hyperlink to a text, which tab should you use?
Home
Insert
Data
View
What color does a text hyperlink typically turn into?
Red
Green
Blue
Black
Which dialog box appears when assigning a hyperlink?
Format Cells
Insert Hyperlink
Data Validation
Conditional Formatting
What happens when you click on a graphic with an assigned hyperlink?
It moves to another worksheet
The linked file or web page opens
It changes color
It deletes the hyperlink
What is the purpose of linking data between worksheets?
To create duplicate data
To automatically update data across sheets
To format cells
To delete data from other sheets
In the Paste Special dialog box, which option is used to link data from one worksheet to another?
Values
Formulas
Paste Link
Formatting
