Question

What is the outcome of an arithmetic expression or function called?

• A. Horizontal value
• B. Derived value
• C. Basic value
• D. Vertical value

Hint:

The result of an expression or function is called a derived value.

Answer 1

The Correct Option is B

Step 1: Understanding the Concept:
In a worksheet some values are typed by hand and some come out of a formula.
The question asks for the name of the value that comes out of an expression or function.

Step 2: Working Out the Answer:
A value typed into a cell is a basic (entered) value.
The outcome of an arithmetic expression or function is worked out by Excel from other cells.
Such a value is called a derived value, so option (B) is correct.

Step 3: Why the Other Options Are Wrong:
Option (A): Horizontal value is not a term used for the result of a function.
Option (C): A basic value is the value typed directly in a cell, not the outcome of a formula.
Option (D): Vertical value is not a term used for the result of a function.

Final Answer:
The outcome of an expression or function is a derived value. This is option (B).