What is the name given to a value that does not change when used - ProProfs Discuss

# What is the name given to a value that does not change when used within a formula?

A. Reference
B. Constant
C. Function

This question is part of Excel 2010 Test
Asked by Rpolete, Last updated: Jan 16, 2020

#### g.Kenneth

G.Kenneth

When doing a scientific experiment, you will have the independent variable, the dependent variable and the constant. For example in an experiment, a scientist wants to see how much seeds will grow under the same temperature but in different locations around the yard. The constant is the temperature because it never changes.

The independent variable is the different locations where the seeds were planted. The constant can be seen in other areas. In a formula there is a function in excel and the constant can also be seen there. It functions in similar ways. The constant in Excel remains the same. The value in the cell will not change even if a formula is set up. The numbers or values will not change.

John Smith