Recent Home Sales in a Suburb of Washington, D

question 52

Multiple Choice

Recent home sales in a suburb of Washington, D.C., are shown in the accompanying ogive. Approximate the percentage of houses that sold for more than $500,000.

• A) 40%
• B) 50%
• C) 60%
• D) 70%

---

Definitions:

Return Value

The output generated by a function or a procedure after execution, which can be a number, text, or complex data types depending on the operation.

VLOOKUP

A function in spreadsheet software that searches for a value in the first column of a range and returns a value in the same row from a specified column.

MATCH Function

A function in Excel and other spreadsheet applications that searches for a specified item in a range of cells, and then returns the relative position of that item.

Total Row

A feature in spreadsheet software that automatically calculates and displays the sum, average, count, or other statistics for data in a column.