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

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



A. Reference
B. Constant
C. Function
D. Address

This question is part of Excel 2010 Test
Asked by Rpolete, Last updated: Apr 25, 2019

+ AnswerRequest Answer
...

2 Answers

g.Kenneth

G.Kenneth

Answered on Jan 24, 2018

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.

 Reply

John Smith

John Smith

Answered on Dec 28, 2016

Constant
 Reply

Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer

Email Sent
We have sent an email to your address "" with instructions to reset your password.