Question

Enter a formula in cell E4 to calculate how long each item has been on sale. This is calculated by subtracting the launch date in cell D4 from the Data Updated date in cell C20. To show the time in years, divide that result by 365. Use an absolute reference to the date in cell C20. Copy the formula from cell E4 to cells E5:E14.

Answer 1

The formula is given below:

(C20-E4)/365

where 365 is the no of the days.

In a spreadsheet application, an absolute cell reference is a cell reference that doesn't change even if the spreadsheet's size or shape changes, or if the reference is copied or relocated to a different cell or page. When making references to constant values in a spreadsheet, absolute cell references are crucial.

Learn more about cells here https://brainly.com/question/25879801

#SPJ10