Assuming that you are using a survey asking questions that allow for only nominal categorical answer choices (1,2,3....), what is the best statistical test to analyze the resulting data for a survey with 20 questions in it (some questions have only two answer choices 0 or 1 and some have multiple like 1,2,3...) explain the answer and how to to the testing in Excel?

Years	Environment	Default	2.1	2.2	2.3	2.4	3.1	3.2	3.3	3.4	4.1	4.2	4.3	4.4	5.1	5.2	Honoring DNR	Define Resuscitation	Duration
3	1	1	1	3	5	1	1	1	5	1	1	3	5	1	5	5
1	1	1	4	4	4	4	4	4	4	4	4	4	4	4	2	2
1	2	4	3	3	3	3	2	2	2	2	3	3	3	3	2	2	1	1
1	1	1	3	3	4	3	2	2	4	2	1	1	4	3	2	2	2	3	5
5	1	4	1	1	1	1	1	1	1	1	1	1	1	1	1	2	1	3	6
5	1	4	3	3	3	4	4	4	4	4	4	4	4	4	2	2	2	2	6
5	1	1	1	1	1	1	1	1	1	1	1	1	1	1	5	5	1	1	1
2	1	1	3	3	3	3	2	2	2	2	3	3	3	3	3	7	4	5	6
5	5	4	3	3	3	3	2	2	2	2	3	3	3	3	2	1	1	1	6
5	1	1	3	3	3	3	2	2	2	2	3	3	3	3	2	2	1	2	6
3	1	1	3	3	3	3	3	3	3	3	3	3	3	3	4	4	1	3	6
3	1	1	2	3	5	3	2	2	2	2	2	3	3	2	3	2	2	2	5
3	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	2	2	2	5
4	2	1	1	2	5	1	1	2	5	1	1	1	5	1	2	2	2	1	5
5	1	1	3	3	3	3	2	2	2	2	3	3	3	3	1	1	1	2	6
5	1	4	3	3	3	3	2	2	2	2	3	3	3	3	1	1	2	4	6
2	1	1	3	3	3	3	2	2	2	2	3	3	3	3	2	2	4	5	6
5	1	1	1	3	3	3	4	4	4	4	3	3	3	3	2	2	1	3	1
3	4	4	4	4	5	4	4	2	5	2	4	3	5	3	2	2	1	2	1
4	1	1	1	1	1	2	2	2	2	2	2	1	1	1	2	1	3	2	5
5	1	4	4	4	4	4	4	4	4	4	4	4	4	4	2	1	1	5	6
3	1	4	3	3	3	3	2	2	1	2	3	3	4	3	2	2	1	2	6
2	1	4	1	1	1	2	1	1	1	2	1	1	1	1	2	2	2	2	5
2	1	4	3	3	3	3	2	2	2	2	3	3	3	3	2	1	2	2	5
5	5	1	3	3	3	3	2	2	2	2	3	3	3	3	2	2	1	3	6