On a scale of 1-10, how terrible are you at answering questionnaires based on a scale of 1 to 10?
7, no 8, maybe 9? oh, whatever...
1) Each data entry field is ideally a pop or pick list of 1-10. I guess what you are doing "works" if that is Excel normal. Can the arrows be in the same cell? That would make more sense to me.
yes, but at my ability/willingness to learn excel better, "Tables" seem "ugly" to implement...
BTW, why Excel? Not all respondents may own a copy. It may not translate directly to "google-sheets" (free)
Why not use survey monkey? I think your survey might fit their "Basic" (free plan) see below ...
A sample template here has your idea in Q1:
Your #3 would be messy unless you find a person with that area of expertise. I use excel for number analysis so quick and dirty is my way ...
Your #4 is easy, you simply "format" that cell as a "number, and select 2-decimals" option.* Excel formats "general" and uses its "wizard" to guess what you want. You must over-ride manually with "format" cells option where it applies.
Your #5 is something i have never seen before. I only know to "freeze panes" or "split panes"manually.
With "beauty" your ultimate goal, i think a free survey app (e.g. surveymonkey) is a much better option.
Survey 1) Personal + Financial 6 questions.
Survey 2) Work and Social 8 questions
Survey 3) Family up to 10 allowed with 5 assigned and 5 "blanks" for expansion.
This should be a free option under their "Basic Plan" - If you have $ there is no need to play this game.
Then YOU bring raw data into Excel (your own copy) and do the analysis there ... averaging and summing...