Microsoft Excel Basic and Advance 3 — Questions and Answers
Question 1: What does VLOOKUP's fourth argument (range_lookup) do when set to FALSE?
- Returns an approximate match
- Returns an exact match only (Correct answer)
- Ignores case sensitivity
- Searches from right to left
Correct answer: Returns an exact match only
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?
- Line chart
- Bar chart
- Pie chart (Correct answer)
- Scatter chart
Correct answer: Pie chart
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?
- Adds numbers together
- Joins two or more text strings into one (Correct answer)
- Counts characters in a cell
- Converts numbers to text
Correct answer: Joins two or more text strings into one
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?
- MID
- RIGHT
- LEFT (Correct answer)
- FIND
Correct answer: LEFT
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?
- Rows area
- Columns area
- Filters area
- Values area (Correct answer)
Correct answer: Values area
The Values area contains the fields that are summarized (summed, averaged, counted, etc.) and shown in the body of the PivotTable.
Question 6: What error does Excel display when a formula attempts to divide by zero?
- #VALUE!
- #REF!
- #DIV/0! (Correct answer)
- #NULL!
Correct answer: #DIV/0!
#DIV/0! appears whenever a formula divides a number by zero or by an empty cell.
Question 7: Which function returns the current date and time that updates each time the worksheet recalculates?
- =DATE()
- =TODAY()
- =NOW() (Correct answer)
- =TIME()
Correct answer: =NOW()
NOW() returns the current date and time as a serial number and refreshes every time Excel recalculates.
Microsoft Excel Basic and Advance 3
What does VLOOKUP's fourth argument (range_lookup) do when set to FALSE?