开发者

doing quiz help in excel [closed]

开发者 https://www.devze.com 2022-12-24 10:45 出处:网络
It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical andcannot be reasonably answered in its current form. For help clari
It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. 开发者_开发问答 Closed 10 years ago.

how do i make all the answers that are "correct" add up in percentage?? i have done the correct and try again....


Assuming that your table looks like this (where 1 means correct and 0 incorrect):

   |  A
---+-----
1  |  1
2  |  1
3  |  1
4  |  0

You can put the following into A10:

=AVERAGE(A1:A9)

to get the result

0.75
0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号