Microsoft Excel Basic and Advance 3

Question 1

What does VLOOKUP's fourth argument (range_lookup) do when set to FALSE?

Accepted Answer

Returns an exact match only

Answer

Setting range_lookup to FALSE forces VLOOKUP to find an exact match and return #N/A if none exists.

Question 2

Which Excel chart type is best suited for showing the proportion of parts to a whole?

Accepted Answer

Pie chart

Answer

A pie chart displays each category as a slice of the whole circle, making part-to-whole relationships immediately visible.

Question 3

What does the CONCATENATE function (or & operator) do in Excel?

Accepted Answer

Joins two or more text strings into one

Answer

CONCATENATE (or &) combines multiple text values into a single string.

Question 4

Which function extracts a specified number of characters from the left side of a text string?

Accepted Answer

LEFT

Answer

LEFT(text, num_chars) returns the first num_chars characters from the beginning of a text string.

Question 5

In a PivotTable, which area determines what values are calculated and displayed in the data cells?

Accepted Answer

Values area

Answer

The Values area contains the fields that are summarized (summed, averaged, counted, etc.) and shown in the body of the PivotTable.

Excel Practice Test