Search Header Logo

Advanced Microsoft Excel Comprehensive Assessment - 2025 Edition

Authored by Kelzang Lethro

others

Advanced Microsoft Excel Comprehensive Assessment - 2025 Edition
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

20 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which Excel function allows you to combine text from multiple cells without manual concatenation?

MERGE()
JOIN()
CONCATENATE()
TEXTJOIN()

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the '$' symbol represent in cell referencing?

Currency formatting
Absolute cell reference
Percentage calculation
Decimal precision

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In Excel, which function would you use to find the highest value in a range of cells?

LARGEST()
TOP()
MAXIMUM()
MAX()

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the primary purpose of VLOOKUP function?

Vertical data sorting
Vertical data lookup
Horizontal data calculation
Complex mathematical operations

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which Excel feature allows automatic color highlighting based on cell value conditions?

Data Validation
Cell Formatting
Conditional Formatting
Style Mapping

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the RANK() function do in Excel?

Calculate average
Determine position in a dataset
Sum numerical values
Count unique entries

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which chart type is best for showing parts of a whole?

Line Chart
Bar Chart
Pie Chart
Scatter Plot

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?