Microsoft Excel Trivia 4

Question 1

Which function would you use to combine the text from two or more cells into one cell?

Accepted Answer

CONCATENATE

Answer

CONCATENATE (or the & operator, or CONCAT in newer versions) joins text strings from multiple cells into a single string.

Question 2

What does 'PivotTable' allow you to do in Excel?

Accepted Answer

Summarize and analyze large data sets interactively

Answer

A PivotTable is an interactive tool that quickly summarizes, groups, and analyzes large datasets without changing the original data.

Question 3

Which Excel function returns the position of a value within a range?

Accepted Answer

MATCH

Answer

MATCH returns the relative position (row or column number) of a specified value within a range.

Question 4

What is the file extension for a macro-enabled Excel workbook?

Accepted Answer

.xlsm

Answer

The .xlsm extension denotes a macro-enabled Excel workbook, while .xlsx files cannot contain VBA macros.

Question 5

Which Excel tool is used to find the input value needed to achieve a specific formula result?

Accepted Answer

Goal Seek

Answer

Goal Seek finds the required input value by working backward from a desired formula result.

Excel Practice Test