In cell b7 create a formula using external – In the realm of data manipulation, the ability to create formulas in Microsoft Excel is paramount. Among the many cells in…