What is the name given to a value that does not change when used - ProProfs Discuss
Cancel
TopicsDown
Products Down
Follow Us:
FacebookTwitter
Advertisement

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

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

+ Answer
Request
Question menu
Vote up Vote down

2 Answers

g.Kenneth

g.Kenneth

g.Kenneth
G.Kenneth

Answered 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.

upvote downvote
Reply 

John Smith

John Smith

John Smith
John Smith

Answered Dec 28, 2016

Constant
upvote downvote
Reply 

Advertisement
Advertisement
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader

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