Which formula contains a cell reference. Answer choices 14-7 B12 C65 1045. Using Absolute Cell References Working With Formulas And Functions In Excel 2013 Informit An absolute cell reference is a cell address that contain a dollar sign in row and column coordinate or both. . Which of the following formulas contains an absolute cell referencea. Pages 7 This preview shows page 2 - 4 out of 7 pages. For example in the first absolute cell reference formula in this tutorial B4B10 I could have typed B4B10 then pressed the F4 key to change B10 to B10. To create and copy a formula using absolute references. The following formula conditional formatting should work for you. If you enter 90 in the Degrees box in the ____ area of the Format Cells dialog box the text will appear vertically and read from bottom to top in the cell. Because each formula is using the same tax rate we want that reference to remain constant...