$ $ $, Do you know what is absolute cell reference?

If you copy the formula =$A$1*B1 from cell C1 to cell C2, the formula in cell C2 will be:
_____________.

Many spreadsheet users may have trouble with this question.

(This question is from this research paper: McGill, T. J., and M. W. Dixon. "Spreadsheet knowledge: An exploratory study." (2001): 621-625.)

Comments

Post a Comment

Popular posts from this blog

How can I change precedent and dependent arrow colors? (LibreOffice)

Image
In LibreOffice Calc, we can choose the color for the precedent / dependent arrows. In LibreOffice (v5.3), choose    Tools/Options/LibreOffice/Application Colors You can select the color for "Detective" colors. "Detective" is the equivalent to Excel's precedent and dependent tracing. Color for Detective Arrows (Precedents and Dependents) Note that  LibreOffice changes all Detective arrows, including those that are already drawn, to the new color.  It is not possible to get two colors for the arrows in the same screen. However, with Basic programming in LibreOffice, it is possible to trace with different colors in the same sheet (worksheet). This is shown in the following diagram, with the software extension described in this book: Easily understand your spreadsheet model and detect errors with influence charts (For LibreOffice Calc) LibreOffice. Different Precedent Arrow Colors
Read more

I want to trace precedents in Google Sheets

I want to trace precedents in Google Sheets. It is not possible to do that in Google Sheets. The closest way is to open the file with Excel or LibreOffice Calc. But there are compatibility problems with special formulas and macros. (Update: Please see the comments for this post)
Read more