Page 395 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

EXERCISE 66 : Use different types of cell references

Objectives

At the end of this exercise you shall be able to
• use different types of cell references in your tasks.

Requirements
Tools/Materials
• PC/Laptop with Windows OS
• MS Excel 2013 or Higher

Procedure

In Excel, there are three main types of cell references: relative, absolute, and mixed. Using different types of cell
references can be helpful when creating formulas that you plan to copy or fill to other cells.
TASK 1: Different types of Cell References
Method 1: Relative Cell Reference

A relative cell reference adjusts when you copy the formula to other cells.
In a scenario where the objective is to establish a formula P (Price) equals INR (Indian Rupees), the suggestion
is to create a single formula in cell E3 and then copy it to other rows to avoid the need for a new formula for each
row. The emphasis is on using relative references to ensure the formula calculates the total for each item correctly.

380