Using cell references enter a formula in cell b6 – Embark on a journey into the realm of cell references, where we delve into the art of using cell references…