Data-tastic Quiz 1

Which Excel feature allows you to visually represent data with charts and graphs?

• PivotTables

• Data Validation

• Sparklines

• Chart Wizard

In Excel, what is a cell reference that does not change when copied to another cell?

• Absolute cell reference

• Relative cell reference

• Mixed cell reference

• Circular cell reference

Which color scheme is generally recommended for data visualizations to ensure clarity and accessibility?

• Rainbow colors

• Grayscale

• Neon colors

• Random color combinations

Data visualization is the process of presenting data in a visual or graphical format.

• TRUE

• FALSE

True or False: A bar chart is best for showing the progression of data over time.

• TRUE

• FALSE

True or False: A line chart is the most suitable chart type for showing categorical data.

• TRUE

• FALSE

How many insights should we ideally communicate in a single chart?

• as many as we can

• 1 to 2

• 3 to 4

• it does not matter

True or False: A scatter plot is used to show the relationship between two continuous variables.

• TRUE

• FALSE

What is the purpose of data visualization?

• To confuse the audience

• To present data in a visual format

• To hide the data

• To make the data more complicated

Which chart type is best for comparing data across different categories?

• Bar chart

• Pie chart

• Line chart

• Scatter plot