answersLogoWhite

0

If you put numbers direct into formulas then the formulas are very restricted. They can only work with the specific numbers you have. If you want to use other numbers, you have to keep changing the formulas. It is better to use cell references in the formulas. Then all you have to do is change the cell values and the formulas will automatically calculate the new totals. It also makes it possible to copy the formulas so that they can use many sets of numbers, all through the same original formula. If you wanted to add 10 pairs of numbers, you could write 10 individual formulas each with the numbers you want to add, or do one single formula and copy it and it will add all 10 pairs. If numbers are in cells you can see the values on the sheet, which you can't do if they are all in the formulas. So if the numbers are separate in cells, it is easier to understand what is going on. For these and many other reasons, we use cell references rather than values in the spreadsheet formulas.

User Avatar

Wiki User

9y ago

What else can I help you with?

Related Questions

What can you use instead of in terms of?

A couple of choices that would suffice would be: " in reference to" or "pertaining to".


What would Greg rather do instead of the swim team?

Video games


What are the sentence of drama?

I would rather see a comedy instead of a drama.


How do you use the word instead in a sentence?

I would rather hang out with my friends instead of being at school doing work . "Dr. Pepper instead of water please", Mike told the waitress . Wouldn't you rather be with me instead of that other girl ?


Who is a black deathly unicorn dancing on a rainbow?

This would be a reference to Fenris - if it was a wolf instead of a unicorn.


What would Bella rather Edward call her instead of fiance?

She would rather he called her his girlfriend, as she is so young she dosent want to get married yet


What two numbers have a lcm of 30 and a HCF of 6?

Use GCF instead of HCF. 6 and 30 would be those numbers...


What is the basic reference used on maps to help determine location?

Maps usually have a grid lines printed on them which are numbered. Normally you would use these numbers as a grid reference to indicate a location


Why does Tony Stewart not use his legal name?

Because he would rather be called Tony instead of Anthony.


Is Joe Jonas going to sing on his own?

He does not want to. He said he would rather do some acting instead.


When would you use the mean rather than the median and the mode?

Mean is the average you add all the numbers and divide the total by the number of numbers that you added. you would use it rather thank median and mode basically when it asks you to find the mean or to find the average


What to do if your boyfriend only likes texting you now instead of talking on the phone?

tell him how you feel. tell him that you would rather like to actually talk to him instead of just reading a message. i know i would.