Search Header Logo

Excel Assessment

Authored by AMRITA 2328206

Other

University

Excel Assessment
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which chart type is best suited for showing trends over time?

Pie Chart

Column Chart

Line Chart

Scatter Plot

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What option allows you to switch the rows and columns in an Excel chart?

"Chart Tools" > "Switch Row/Column"

"Design" > "Switch Row/Column"

"Insert" > "Switch Data Source"

"Format" > "Transpose Data"

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How can you insert sparklines into a worksheet?

Go to "Insert" > "Sparklines" and choose the type

Right-click on the data and select "Insert Sparklines"

Go to "Data" > "Insert Sparklines"

Use "Home" > "Conditional Formatting"

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is NOT a type of sparkline in Excel?

Line

Column

Win/Loss

Area

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of using sparklines in Excel?

To create large, detailed charts for presentations

To display mini-charts within a single cell for quick analysis

To replace formulas in Excel

To highlight errors in data

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which chart type is most suitable for visualizing the proportion of parts to a whole?

Bar Chart

Pie Chart

Line Chart

Scatter Plot

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the "High Point" option in sparklines do?

Highlights the highest value in the sparkline with a different color

Adds a data label showing the highest value

Automatically creates a new chart for high values

Filters data to show only high values

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?