You can address these cells directly. In a calculation you can refer to a specific cell in the spreadsheet and use its content.
Prerequisite
A table view is created for the query or the ad-hoc analysis.
Procedure
The references in the formula have changed:
You have inserted relative cell references. If you insert the calculation cell at another position, the calculation is performed for the new area, as well.