the symbol used to tell excel that the cell from which information comes should
ID: 3256846 • Letter: T
Question
the symbol used to tell excel that the cell from which information comes should not change when the formula is cut groups of studen ocean County College TO ocean Connect e/9309/quizzes/4 C Quiz M9. Quiz O Since po 18; there are no significant differences between the test scores of the three groups of students. Question 8 3 pts The symbol used to tell Excel that the cell from which information comes should NOT change when the formula is cut and pasted in another cell is: O 96 Question 9 3 pts To calculate measures of central tendency and measures of variability. which option do you select from the Data Analysis menu? CorrelationExplanation / Answer
The dollar sign in an Excel cell reference affects just one thing - it instructs Excel how to treat the reference when the formula is moved or copied to other cells. In a nutshell, using the $ sign before the row and column coordinates makes an absolute cell reference that won't change. Without the $ sign, the reference is relative and it will change
Hence
the symbol used to tell excel that the cell from which information comes should change when the formula is cut and pasted in another cell is $
option d) is correct
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.