Create a scenario pivottable report showing result cells k6:k8 – Create a scenario pivot table report showing result cells k6:k8 introduces a pivotal concept in data analysis, empowering users to…