Which of the Following Formulas Is INCORRECT

question 63

Multiple Choice

Which of the following formulas is INCORRECT?

• A)i = - 1
• B)1 + rr =
• C)rr ≈ i - r
• D)rr =

---

Definitions:

VLOOKUP

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

Table Range

The difference between the highest and lowest values in a table, often used in data analysis to understand the variability within the data.

AVERAGE

AVERAGE refers to the mathematical mean, which is the sum of a list of numbers divided by the count of numbers in the list.

COUNTIF

A function in spreadsheet programs that counts the number of cells that meet a specified condition within a range.