COMPUTER APPLICATIONS
OFFICE AUTOMATION SOFTWARE
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The correct formula to calculate the percentage in the given table is:
|
=B2+C2+D2+E2 /400*100
|
|
=B2+C2+D2+E2 *100
|
|
=(B2+C2+D2+E2) / 400*100
|
|
=(B2+C2+D2+E2) /100*400
|
Explanation:
Detailed explanation-1: -Enter the formula =C2/B2 in cell D2, and copy it down to as many rows as you need. Click the Percent Style button (Home tab > Number group) to display the resulting decimal fractions as percentages. Remember to increase the number of decimal places if needed, as explained in Percentage tips. Done!
Detailed explanation-2: -Step 1: Identify the whole from the given table. Take a look at the table and find the whole. Step 2: Find the part from the given table of values. Part is the number for which we are required to find the percentage. Step 3: Compute the percentage using the formula.
There is 1 question to complete.