In Sheets, ad spend is in B2:B7 and sales in C2:C7. Type the formula for their correlation coefficient.

Answer

=CORREL(C2:C7, B2:B7)

0.9986. CORREL takes the two ranges in either order; PEARSON is the same function under another name.