1. What are some qualitative tools used to analyze data withinMicrosoft Excel? H

1. What are some qualitative tools used to analyze data withinMicrosoft Excel? How do these tools assist users with theirbusiness decisions? Provide an example from a past or current workexperience when the use of these tools would have helped to analyzedata in your spreadsheet. How the data was originally analyzed?Explain your answer.2. Microsoft Excels versatility allows users to analyze bothqualitative and quantitative data. How does the versatility ofMicrosoft Excel affect application support? Because of itsversatility what assumptions must be made when diagnosing andtroubleshooting Microsoft Excel-based problems?