How do I do the result of a evaluation/survey on excel? I had rating questions as well.?

Hard to say exactly without know how your data is set up, but very often a Pivot Table will work for this. For example, you have questions in column A, and responses in column B, you can use a Pivot Table:





Let's say you have Question#s (Q1, Q2, etc.) in col. A, and Answers in col. B (A, B, C, etc.).





1) select all your data; just be sure that each column in your selected data has a heading at the top.





2) Data - PivotTable and PivotChart Report, this will bring up the pivot table wizard


- step 1: say OK


- step 2: make sure all your data is selected


- step 3: pick whether you want it in a new sheet


This will create the empty table structure.





3) You should have a list of fields on the right, showing Question#, Answer, and whatever else you selected.


- drag the Question# field to where it says "Drop Row fields here" on the left


- drag the Answer field to top of the table, where it says "Drop Column fields here"


- drag the Question# again, this time to where it says "Drop Data Items here"





You will end up with a table that has a row for each Question, and columns for how many people answered A, how many answered B, etc.





If you need more info, pls. add detail or e-mail.


Good luck!


.