0
Insert a formula to calculate the total number of correct answers. What would be the formula?
Wiki User
∙ 14y ago
That is a very unclear question, so it depends what you mean. If you mean you have someone typing in answers to a test and want to count the amount of correct answers they have, there are different ways you could do it. In the cell beside each answer given, you could put a 1 for a correct answer and a 0 for a wrong one and then total them up using the SUM function. If you have the correct answer in a cell and their answer in another one, you could use an IF function to compare the answers, and give 1 for a correct one and 0 for wrong ones, and again use SUM to total them. So say the correct answers were in the cells from A2 to A10 and you entered their answers in B2 to B10. Then in C2 you could put the following formula:
=IF(A2=B2,1,0)
You would copy that formula down to C10, and you'd have 1 for each correct answer and 0 for the wrong ones. Then in C11 you could put the following formula to add them up:
=SUM(C2:C10)
You would naturally adjust the cell references to suit the cells you are using in all of these formulas.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
What do you use to calculate things in spreadsheets?
Every formula starts with equal sign =If you want to display list of all functions in Excel from the upper toolbar select: Insert - Function.
The formula work and time is used to calculate what?
Power = Work/Time Time = Work/Power Work = Power * Time See related links for a power calculator. Insert work and time to calculate power.
What about if they tell you the width and the area of the rectangle?
The area of a rectangle is calculated by the formula: A = lw (area = length times width). If you know any two of those values, you can insert those values in the formula and calculate the third one.
What is the formula if price drops in 30 percent in excel?
If you put the original price in cell A1, then the formula you insert into cell B1 or whichever other cell you wish to calculate the new value is: =A1*(1-(30/100))
The disk you inserted is not the correct one - what do you do now?
Insert the correct one.
In excel what is the correct formula to auto sum column B?
If you have numbers in cells B1 through B134, use the formula: =SUM(B1:B134). You can use auto sum to insert the formula by highlighting the column (you can click on the column letter) and clicking the AutoSum button on the menu.
How can you insert a quadratic formula in your document on Microsoft word?
To insert a quadratic formula (or any other scientific formula) into a Word document, go toInsert (tab) > Equations (under the Symbols block)From there you can either select the format of the formula you would like to insert if a template is available (there is a template already for quadratic equations) but if there isn't one, can either download on from Office.com OR create your own by clicking Insert New Equation.
What is the correct use of an apostrophe with numbers?
anal insert
What are four ways to add a function to a formula?
Type the formula directly in the cell or the formula. Use formula AutoComplete. Select a function from the Function Library group, or click the Insert Function button to select a function from the Insert Function dialog. Use AutoSum
Sims why does it say please insert the correct CD ROM?
It will say that if you have the incorrect CD inserted. you might want to insert the correct disk in order for it to work properly
What is wrong with your keyboard?
Pressing f4 does not insert $ signs in a formula
How do you insert the formula of mean in excel?
=AVERAGE(Firstcell:lastcell) i think
