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

Returns an approximate match

Answer

Ignores case sensitivity

Answer

Searches from right to left

Question 2

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

Accepted Answer

Pie chart

Answer

Line chart

Answer

Bar chart

Answer

Scatter chart

Question 3

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

Accepted Answer

Joins two or more text strings into one

Answer

Adds numbers together

Answer

Counts characters in a cell

Answer

Converts numbers to text

Question 4

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

Accepted Answer

LEFT

Answer

MID

Answer

RIGHT

Answer

FIND

Question 5

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

Accepted Answer

Values area

Answer

Rows area

Answer

Columns area

Answer

Filters area

Question 6

What error does Excel display when a formula attempts to divide by zero?

Accepted Answer

#DIV/0!

Answer

#VALUE!

Answer

#REF!

Answer

#NULL!

Question 7

Which function returns the current date and time that updates each time the worksheet recalculates?

Accepted Answer

=NOW()

Answer

=DATE()

Answer

=TODAY()

Answer

=TIME()