ExcelDataPro Percentage Advance Practice Sheet for calculating percentages with answers and remarks.
Educational worksheet: Advanced Excel Exercises with Solutions PDF - ExcelDemy. Download and print for classroom or home learning activities.
JPG
800×418
96.3 KB
Free · Personal Use
Quality Assured by Worksheets Library Team
Reviewed for educational accuracy and age-appropriateness
ID: #149314
⭐
Show Answer Key & Explanations
Step-by-step solution for: Advanced Excel Exercises with Solutions PDF - ExcelDemy
▼
Show Answer Key & Explanations
Step-by-step solution for: Advanced Excel Exercises with Solutions PDF - ExcelDemy
The image shows a practice sheet for calculating percentages. The task involves finding the percentage of a given number and comparing it to the expected answer. Below is a detailed explanation of how to solve these problems, along with the solutions for the provided data.
To calculate the percentage of a number:
\[
\text{Percentage Value} = \left( \frac{\text{Percentage}}{100} \right) \times \text{Number}
\]
#### Left Side (Sr. No. 1 to 10)
1. Sr. No. 1:
- Percentage: \(3\%\)
- Number: \(195\)
- Calculation:
\[
\text{Answer} = \left( \frac{3}{100} \right) \times 195 = 0.03 \times 195 = 5.85
\]
- Result: \(5.85\) (Correct)
2. Sr. No. 2:
- Percentage: \(3\%\)
- Number: \(182\)
- Calculation:
\[
\text{Answer} = \left( \frac{3}{100} \right) \times 182 = 0.03 \times 182 = 5.46
\]
- Result: \(5.46\) (Correct)
3. Sr. No. 3:
- Percentage: \(1\%\)
- Number: \(187\)
- Calculation:
\[
\text{Answer} = \left( \frac{1}{100} \right) \times 187 = 0.01 \times 187 = 1.87
\]
- Result: \(1.87\) (Incorrect, as the sheet shows \(18.6\), which is wrong)
4. Sr. No. 4:
- Percentage: \(3\%\)
- Number: \(130\)
- Calculation:
\[
\text{Answer} = \left( \frac{3}{100} \right) \times 130 = 0.03 \times 130 = 3.9
\]
- Result: \(3.9\)
5. Sr. No. 5:
- Percentage: \(5\%\)
- Number: \(135\)
- Calculation:
\[
\text{Answer} = \left( \frac{5}{100} \right) \times 135 = 0.05 \times 135 = 6.75
\]
- Result: \(6.75\)
6. Sr. No. 6:
- Percentage: \(3\%\)
- Number: \(100\)
- Calculation:
\[
\text{Answer} = \left( \frac{3}{100} \right) \times 100 = 0.03 \times 100 = 3
\]
- Result: \(3\)
7. Sr. No. 7:
- Percentage: \(1\%\)
- Number: \(119\)
- Calculation:
\[
\text{Answer} = \left( \frac{1}{100} \right) \times 119 = 0.01 \times 119 = 1.19
\]
- Result: \(1.19\)
8. Sr. No. 8:
- Percentage: \(2\%\)
- Number: \(186\)
- Calculation:
\[
\text{Answer} = \left( \frac{2}{100} \right) \times 186 = 0.02 \times 186 = 3.72
\]
- Result: \(3.72\)
9. Sr. No. 9:
- Percentage: \(2\%\)
- Number: \(174\)
- Calculation:
\[
\text{Answer} = \left( \frac{2}{100} \right) \times 174 = 0.02 \times 174 = 3.48
\]
- Result: \(3.48\)
10. Sr. No. 10:
- Percentage: \(1\%\)
- Number: \(133\)
- Calculation:
\[
\text{Answer} = \left( \frac{1}{100} \right) \times 133 = 0.01 \times 133 = 1.33
\]
- Result: \(1.33\)
11. Sr. No. 11:
- Percentage: \(4\%\)
- Number: \(119\)
- Calculation:
\[
\text{Answer} = \left( \frac{4}{100} \right) \times 119 = 0.04 \times 119 = 4.76
\]
- Result: \(4.76\)
#### Right Side (Sr. No. 16 to 26)
1. Sr. No. 16:
- Percentage: \(5\%\)
- Number: \(170\)
- Calculation:
\[
\text{Answer} = \left( \frac{5}{100} \right) \times 170 = 0.05 \times 170 = 8.5
\]
- Result: \(8.5\)
2. Sr. No. 17:
- Percentage: \(4\%\)
- Number: \(171\)
- Calculation:
\[
\text{Answer} = \left( \frac{4}{100} \right) \times 171 = 0.04 \times 171 = 6.84
\]
- Result: \(6.84\)
3. Sr. No. 18:
- Percentage: \(5\%\)
- Number: \(192\)
- Calculation:
\[
\text{Answer} = \left( \frac{5}{100} \right) \times 192 = 0.05 \times 192 = 9.6
\]
- Result: \(9.6\)
4. Sr. No. 19:
- Percentage: \(3\%\)
- Number: \(181\)
- Calculation:
\[
\text{Answer} = \left( \frac{3}{100} \right) \times 181 = 0.03 \times 181 = 5.43
\]
- Result: \(5.43\)
5. Sr. No. 20:
- Percentage: \(2\%\)
- Number: \(129\)
- Calculation:
\[
\text{Answer} = \left( \frac{2}{100} \right) \times 129 = 0.02 \times 129 = 2.58
\]
- Result: \(2.58\)
6. Sr. No. 21:
- Percentage: \(4\%\)
- Number: \(199\)
- Calculation:
\[
\text{Answer} = \left( \frac{4}{100} \right) \times 199 = 0.04 \times 199 = 7.96
\]
- Result: \(7.96\)
7. Sr. No. 22:
- Percentage: \(1\%\)
- Number: \(170\)
- Calculation:
\[
\text{Answer} = \left( \frac{1}{100} \right) \times 170 = 0.01 \times 170 = 1.7
\]
- Result: \(1.7\)
8. Sr. No. 23:
- Percentage: \(1\%\)
- Number: \(151\)
- Calculation:
\[
\text{Answer} = \left( \frac{1}{100} \right) \times 151 = 0.01 \times 151 = 1.51
\]
- Result: \(1.51\)
9. Sr. No. 24:
- Percentage: \(1\%\)
- Number: \(123\)
- Calculation:
\[
\text{Answer} = \left( \frac{1}{100} \right) \times 123 = 0.01 \times 123 = 1.23
\]
- Result: \(1.23\)
10. Sr. No. 25:
- Percentage: \(1\%\)
- Number: \(161\)
- Calculation:
\[
\text{Answer} = \left( \frac{1}{100} \right) \times 161 = 0.01 \times 161 = 1.61
\]
- Result: \(1.61\)
11. Sr. No. 26:
- Percentage: \(1\%\)
- Number: \(188\)
- Calculation:
\[
\text{Answer} = \left( \frac{1}{100} \right) \times 188 = 0.01 \times 188 = 1.88
\]
- Result: \(1.88\)
Here are the calculated answers for all entries:
#### Left Side:
1. \(5.85\)
2. \(5.46\)
3. \(1.87\)
4. \(3.9\)
5. \(6.75\)
6. \(3\)
7. \(1.19\)
8. \(3.72\)
9. \(3.48\)
10. \(1.33\)
11. \(4.76\)
#### Right Side:
16. \(8.5\)
17. \(6.84\)
18. \(9.6\)
19. \(5.43\)
20. \(2.58\)
21. \(7.96\)
22. \(1.7\)
23. \(1.51\)
24. \(1.23\)
25. \(1.61\)
26. \(1.88\)
\[
\boxed{
\begin{array}{c|c}
\text{Left Side} & \text{Right Side} \\
\hline
5.85 & 8.5 \\
5.46 & 6.84 \\
1.87 & 9.6 \\
3.9 & 5.43 \\
6.75 & 2.58 \\
3 & 7.96 \\
1.19 & 1.7 \\
3.72 & 1.51 \\
3.48 & 1.23 \\
1.33 & 1.61 \\
4.76 & 1.88 \\
\end{array}
}
\]
General Formula for Percentage Calculation
To calculate the percentage of a number:
\[
\text{Percentage Value} = \left( \frac{\text{Percentage}}{100} \right) \times \text{Number}
\]
Step-by-Step Solution
#### Left Side (Sr. No. 1 to 10)
1. Sr. No. 1:
- Percentage: \(3\%\)
- Number: \(195\)
- Calculation:
\[
\text{Answer} = \left( \frac{3}{100} \right) \times 195 = 0.03 \times 195 = 5.85
\]
- Result: \(5.85\) (Correct)
2. Sr. No. 2:
- Percentage: \(3\%\)
- Number: \(182\)
- Calculation:
\[
\text{Answer} = \left( \frac{3}{100} \right) \times 182 = 0.03 \times 182 = 5.46
\]
- Result: \(5.46\) (Correct)
3. Sr. No. 3:
- Percentage: \(1\%\)
- Number: \(187\)
- Calculation:
\[
\text{Answer} = \left( \frac{1}{100} \right) \times 187 = 0.01 \times 187 = 1.87
\]
- Result: \(1.87\) (Incorrect, as the sheet shows \(18.6\), which is wrong)
4. Sr. No. 4:
- Percentage: \(3\%\)
- Number: \(130\)
- Calculation:
\[
\text{Answer} = \left( \frac{3}{100} \right) \times 130 = 0.03 \times 130 = 3.9
\]
- Result: \(3.9\)
5. Sr. No. 5:
- Percentage: \(5\%\)
- Number: \(135\)
- Calculation:
\[
\text{Answer} = \left( \frac{5}{100} \right) \times 135 = 0.05 \times 135 = 6.75
\]
- Result: \(6.75\)
6. Sr. No. 6:
- Percentage: \(3\%\)
- Number: \(100\)
- Calculation:
\[
\text{Answer} = \left( \frac{3}{100} \right) \times 100 = 0.03 \times 100 = 3
\]
- Result: \(3\)
7. Sr. No. 7:
- Percentage: \(1\%\)
- Number: \(119\)
- Calculation:
\[
\text{Answer} = \left( \frac{1}{100} \right) \times 119 = 0.01 \times 119 = 1.19
\]
- Result: \(1.19\)
8. Sr. No. 8:
- Percentage: \(2\%\)
- Number: \(186\)
- Calculation:
\[
\text{Answer} = \left( \frac{2}{100} \right) \times 186 = 0.02 \times 186 = 3.72
\]
- Result: \(3.72\)
9. Sr. No. 9:
- Percentage: \(2\%\)
- Number: \(174\)
- Calculation:
\[
\text{Answer} = \left( \frac{2}{100} \right) \times 174 = 0.02 \times 174 = 3.48
\]
- Result: \(3.48\)
10. Sr. No. 10:
- Percentage: \(1\%\)
- Number: \(133\)
- Calculation:
\[
\text{Answer} = \left( \frac{1}{100} \right) \times 133 = 0.01 \times 133 = 1.33
\]
- Result: \(1.33\)
11. Sr. No. 11:
- Percentage: \(4\%\)
- Number: \(119\)
- Calculation:
\[
\text{Answer} = \left( \frac{4}{100} \right) \times 119 = 0.04 \times 119 = 4.76
\]
- Result: \(4.76\)
#### Right Side (Sr. No. 16 to 26)
1. Sr. No. 16:
- Percentage: \(5\%\)
- Number: \(170\)
- Calculation:
\[
\text{Answer} = \left( \frac{5}{100} \right) \times 170 = 0.05 \times 170 = 8.5
\]
- Result: \(8.5\)
2. Sr. No. 17:
- Percentage: \(4\%\)
- Number: \(171\)
- Calculation:
\[
\text{Answer} = \left( \frac{4}{100} \right) \times 171 = 0.04 \times 171 = 6.84
\]
- Result: \(6.84\)
3. Sr. No. 18:
- Percentage: \(5\%\)
- Number: \(192\)
- Calculation:
\[
\text{Answer} = \left( \frac{5}{100} \right) \times 192 = 0.05 \times 192 = 9.6
\]
- Result: \(9.6\)
4. Sr. No. 19:
- Percentage: \(3\%\)
- Number: \(181\)
- Calculation:
\[
\text{Answer} = \left( \frac{3}{100} \right) \times 181 = 0.03 \times 181 = 5.43
\]
- Result: \(5.43\)
5. Sr. No. 20:
- Percentage: \(2\%\)
- Number: \(129\)
- Calculation:
\[
\text{Answer} = \left( \frac{2}{100} \right) \times 129 = 0.02 \times 129 = 2.58
\]
- Result: \(2.58\)
6. Sr. No. 21:
- Percentage: \(4\%\)
- Number: \(199\)
- Calculation:
\[
\text{Answer} = \left( \frac{4}{100} \right) \times 199 = 0.04 \times 199 = 7.96
\]
- Result: \(7.96\)
7. Sr. No. 22:
- Percentage: \(1\%\)
- Number: \(170\)
- Calculation:
\[
\text{Answer} = \left( \frac{1}{100} \right) \times 170 = 0.01 \times 170 = 1.7
\]
- Result: \(1.7\)
8. Sr. No. 23:
- Percentage: \(1\%\)
- Number: \(151\)
- Calculation:
\[
\text{Answer} = \left( \frac{1}{100} \right) \times 151 = 0.01 \times 151 = 1.51
\]
- Result: \(1.51\)
9. Sr. No. 24:
- Percentage: \(1\%\)
- Number: \(123\)
- Calculation:
\[
\text{Answer} = \left( \frac{1}{100} \right) \times 123 = 0.01 \times 123 = 1.23
\]
- Result: \(1.23\)
10. Sr. No. 25:
- Percentage: \(1\%\)
- Number: \(161\)
- Calculation:
\[
\text{Answer} = \left( \frac{1}{100} \right) \times 161 = 0.01 \times 161 = 1.61
\]
- Result: \(1.61\)
11. Sr. No. 26:
- Percentage: \(1\%\)
- Number: \(188\)
- Calculation:
\[
\text{Answer} = \left( \frac{1}{100} \right) \times 188 = 0.01 \times 188 = 1.88
\]
- Result: \(1.88\)
Final Answers
Here are the calculated answers for all entries:
#### Left Side:
1. \(5.85\)
2. \(5.46\)
3. \(1.87\)
4. \(3.9\)
5. \(6.75\)
6. \(3\)
7. \(1.19\)
8. \(3.72\)
9. \(3.48\)
10. \(1.33\)
11. \(4.76\)
#### Right Side:
16. \(8.5\)
17. \(6.84\)
18. \(9.6\)
19. \(5.43\)
20. \(2.58\)
21. \(7.96\)
22. \(1.7\)
23. \(1.51\)
24. \(1.23\)
25. \(1.61\)
26. \(1.88\)
Boxed Final Answer
\[
\boxed{
\begin{array}{c|c}
\text{Left Side} & \text{Right Side} \\
\hline
5.85 & 8.5 \\
5.46 & 6.84 \\
1.87 & 9.6 \\
3.9 & 5.43 \\
6.75 & 2.58 \\
3 & 7.96 \\
1.19 & 1.7 \\
3.72 & 1.51 \\
3.48 & 1.23 \\
1.33 & 1.61 \\
4.76 & 1.88 \\
\end{array}
}
\]
Parent Tip: Review the logic above to help your child master the concept of excel practice worksheets.