Basic and Advance Flashcards
7 cards from real Microsoft Excel practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Basic and Advance flashcards as text
What does VLOOKUP's fourth argument (range_lookup) do when set to FALSE?
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.
Which Excel chart type is best suited for showing the proportion of parts to a whole?
Answer: Pie chart
A pie chart displays each category as a slice of the whole circle, making part-to-whole relationships immediately visible.
What does the CONCATENATE function (or & operator) do in Excel?
Answer: Joins two or more text strings into one
CONCATENATE (or &) combines multiple text values into a single string.
Which function extracts a specified number of characters from the left side of a text string?
Answer: LEFT
LEFT(text, num_chars) returns the first num_chars characters from the beginning of a text string.
In a PivotTable, which area determines what values are calculated and displayed in the data cells?
Answer: Values area
The Values area contains the fields that are summarized (summed, averaged, counted, etc.) and shown in the body of the PivotTable.
What error does Excel display when a formula attempts to divide by zero?
Answer: #DIV/0!
#DIV/0! appears whenever a formula divides a number by zero or by an empty cell.
Which function returns the current date and time that updates each time the worksheet recalculates?
Answer: =NOW()
NOW() returns the current date and time as a serial number and refreshes every time Excel recalculates.