Advanced Microsoft Excel Comprehensive Assessment - 2025 Edition

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

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

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

• Currency formatting
• Absolute cell reference
• Percentage calculation
• Decimal precision

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

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

What is the primary purpose of VLOOKUP function?

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

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

• Data Validation
• Cell Formatting
• Conditional Formatting
• Style Mapping

What does the RANK() function do in Excel?

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

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

• Line Chart
• Bar Chart
• Pie Chart
• Scatter Plot

What is the primary difference between relative and absolute cell references?

• Calculation speed
• Reference behavior when copied
• Visual appearance
• Data storage

Which function counts cells meeting specific criteria?

• COUNT()
• COUNTIF()
• SUMCOUNT()
• FILTERCOUNT()

What does the AND() function return?

• Sum of values
• Maximum value
• TRUE if all conditions are met
• Average of conditions