The way to type an absolute reference formula in excel is by: Before the column name and row number, for example that is $E$4, add the dollar sign ($). The equation will now be = B2*$E$4.
<h3>How can an absolute reference formula be added to Excel?</h3>
For adding absolute cell references to your calculations, there is a shortcut available. Press the F4 key to continue typing your formula after entering a cell reference. The cell reference is automatically made absolute by Excel! Excel will cycle through each possible absolute reference by pressing F4 repeatedly.
Therefore, Simply pick the cell reference(s) you want to change and click the F4 key to use the shortcut. Holding down the Shift key while pressing the F4 key will select all of the cell references you want to change at once.
Learn more about excel from
brainly.com/question/25863198
#SPJ1
