Absolute Relative Reference – Dollar in Formula In Excel, a cell reference could be relative or absolute (written with dollars). It's important to understand both situations
Exercise: Calculate the income of the week Exercise to calculate the income of the week. You will see how to use the dollars in your calculation and create SUM formulae.