In cell k1 enter a formula using the maxifs function – In the realm of data analysis, the MAXIFS function emerges as a formidable tool, empowering users to effortlessly identify…