Ask your own question, for FREE!
Mathematics 16 Online
OpenStudy (anonymous):

been a while.

OpenStudy (anonymous):

OpenStudy (jdoe0001):

spreadsheets use more or less, the same notation as ... many computer input boxes do so.... think about it this way, what would you use if you were to type it here? so... the spreadsheet will use more or less the same

OpenStudy (anonymous):

more?

OpenStudy (jdoe0001):

you're correct since A1 and A2 is just a cell reference, with varying row, same column

jimthompson5910 (jim_thompson5910):

hint: look for the one that has cells referencing themselves. This is a very bad idea because it leads to circular logic

jimthompson5910 (jim_thompson5910):

that option should be eliminated because of that flaw

OpenStudy (anonymous):

so I'm guessing its b?

jimthompson5910 (jim_thompson5910):

no, if you look closely at b, you'll notice that cell C1 references itself when it says =B1+C1 but how can we know the value of =B1+C1 if we don't know the value of C1? This is circular logic and leads to an error. If the program didn't throw the error, then it would be stuck in an infinite loop.

jimthompson5910 (jim_thompson5910):

try it out with excel to see what it says

OpenStudy (anonymous):

so the only option I have left would be A.

jimthompson5910 (jim_thompson5910):

correct

Can't find your answer? Make a FREE account and ask your own questions, OR help others and earn volunteer hours!

Join our real-time social learning platform and learn together with your friends!
Can't find your answer? Make a FREE account and ask your own questions, OR help others and earn volunteer hours!

Join our real-time social learning platform and learn together with your friends!