WorksheetsBSAB1C-ELEC1 (FQuiz1)
Total questions: 21
Worksheet time: 20mins
What is a key difference between a Column Chart and a Bar Chart?
Column charts use vertical bars, while bar charts use horizontal bars.
Column charts are only for percentages, while bar charts are for whole numbers.
Bar charts show trends over time, while column charts do not.
Column charts show proportions, while bar charts do not.
Line charts are best suited for:
Comparing proportions
Showing trends over time
Displaying 3D landscapes
Grouping data by category
The legend in a chart:
Provides a description of the chart
Displays values on the x-axis
Identifies different data series by color
Shows proportions in a pie chart
If you want to move a chart to a new worksheet, you should:
Drag and drop the chart
Use the Move Chart command on the Design tab
Change the chart style
Update the data range
What chart type is best used to show proportions of a whole?
Bar Chart
Column Chart
Line Chart
Pie Chart
Which chart type allows you to display data across a 3D landscape?
Pie Chart
Surface Chart
Column Chart
Area Chart
What command can you use to add predefined chart layouts?
Add Chart Element
Recommended Charts
Chart Styles
Quick Layout
In an Area Chart, what is unique about its data display?
It uses horizontal bars.
It shows data as slices.
It fills in the area under the lines.
It shows data as points on a 3D surface.
What do you call the part of a chart that measures values on the y-axis?
Legend
Horizontal Axis
Data Series
Vertical Axis
In what scenario would a Pie Chart not be suitable?
Comparing proportions of a whole
Tracking monthly sales
Showing percentages of categories
Illustrating parts of a total
In Excel, what element on a chart typically describes the categories of data?
Chart Title
Data Series
Vertical Axis
Horizontal Axis
Which chart element is used to describe the purpose of the chart?
Chart Title
Legend
Data Series
Axis
The reference A2 is an example of:
Relative reference
Absolute reference
Mixed reference
Static reference
What is the default type of cell reference in Excel?
Absolute
Relative
Mixed
Constant
When copied to another cell, which type of reference remains constant?
Mixed
Relative
Absolute
Dynamic
When inserting a chart in MS Excel, once you select a chart type, you cannot change it instantly. You need to start over, select the data to convert into a chart, and then choose the new chart type.
True
False
If you use the formula =A1+B1 in cell C1 and then copy it to cell C2, what will the formula become?
=A2+B2
=A1+B1
=A2+B1
=A1+B2
How would you reference cell B3 on a worksheet named "Sales Data" that contains a space in the name?
=Sales Data!B3
='Sales Data'!B3
="Sales Data"!B3
=[Sales Data]!B3
Pie charts are limited to displaying a single data series.
True
False
Which reference would be created if you press F4 once while editing the reference A2?
$A$2
A$2
$A2
A2
Bonus Point:
1. Type/Write reference G1 as absolute reference.
(a)
