Returns the Value or the Reference to a Value Within

question 61

Multiple Choice

Returns the value or the reference to a value within a range based on X and Y coordinates.

• A)DSUM
• B)INDEX
• C)IPMT
• D)PPMT

---

Definitions:

Conditional Formatter

A feature in spreadsheet and database software that changes the appearance of cells based on certain conditions.

Format Painter

A tool in many software applications that lets users copy formatting from one item to another.

Shape Effects Tool

A feature in graphic design and presentation software that allows users to apply special visual effects to shapes, such as shadows, glows, and bevels.

Form Layout View

A feature in database and form-building software that allows users to visually design and arrange the interface through which data is entered and displayed.