Excel is a versatile tool for data analysis that can help you manipulate and analyze your data. It offers features…