[img]http://dl.iteye.com/upload/attachment/285208/caacd0e2-1eed-34db-ba91-6ce9837e5308.gif[/img]
思路:
1.使用公式统计每道题目重复出现次数;
如图显示:
单选:COUNTIF(C2:C38,"[A.有]"
)
多选:COUNTIF(J2:J38,"*A.香港*"
)
[img]http://dl.iteye.com/upload/attachment/285207/065233af-a111-36d8-8192-01218c4a421a.jpg[/img]
2.使用统计好的信息。制作图表;
如图显示:
[img]http://dl.iteye.com/upload/attachment/285211/ccd62edb-c8d1-3c73-8c6f-8443f247a584.gif[/img]
思路:
1.使用公式统计每道题目重复出现次数;
如图显示:
单选:COUNTIF(C2:C38,"[A.有]"
)
多选:COUNTIF(J2:J38,"*A.香港*"
)
[img]http://dl.iteye.com/upload/attachment/285207/065233af-a111-36d8-8192-01218c4a421a.jpg[/img]
2.使用统计好的信息。制作图表;
如图显示:
[img]http://dl.iteye.com/upload/attachment/285211/ccd62edb-c8d1-3c73-8c6f-8443f247a584.gif[/img]