Question

in calc to create the reference with the mouse​

Answer 1

Explanation:

Click the = icon next to the input line.

Switch to the other spreadsheet (the process to do this will vary depending on which operating system you are using).

Select the sheet and then the reference cell.

Switch back to the original spreadsheet.

Answer 2

Answer:

there is no need of '=' symbol