This is excel and how to solve the problems just using excel and demonstrate how the steps used please show how you got the answer

_This is a question about self-reported hearing from the NHANES (National Health and Nutrition Examination Survey), 2017-2018. lHearing lit of respons Excellent 4361 Good 3074 'A little trouble _ s99 Moderate hearing trouble 372 _A lot of trouble 166 Deaf _ 22 Don't know _ 3 For each question: - Use a formula in the space above; I'll check the formula for the correct setup .. Where requested. type the answer in the space provided .3) Find the total number of reap" onses Answer: I b) Calculate the percentage of total responses for each response and put them in cells C4:C]l}. Note: so me of the numbers may be so small that the)r appear as 0%. If that happens, shift the decimal so that it rounds to the nearest 10th. Use these in the number formatting bar: out no u\" .3 :e) Create a graph (bar graph or histogram) for each set or data. You can choose to present the counts themselves or the percentages. Keep in mind: _- Should there be spaces between bars or not (remember: adjust \"gap width") - Add labels for the axes - Add or modify anything else that you think makes the graph look clear and easyr to understand