Percentage Practice Sheet is a ready-to-use excel template which enables the student to practice and easily learn to find the percentage of given numbers.
In addition to the above, you can also conduct a test to check the learning curve. You don’t need to change numbers manually in all cells. It automatically changes numbers between a prescribed range just by clicking a button.
Furthermore, this template also consists of printable sheets which you can give to your child to practice.
What is the Percentage?
In mathematics, a percentage is a number or ratio expressed as a fraction of 100. It is a club of two words (Per + Cent). “Per” means “Out Of ” and “Cent” means “100” in mathematical language.
% is the sign used for percentage. All percentage amounts can be expressed in fractional and decimal equivalents.
The percentage is the part of of our daily lives. It is used in schools, colleges, business maths, UPSC exams, competitive exams, etc. We and our children must learn this.
Thorough grip over this helps the child to calculate proportionate values in fractions of seconds.
Formula To Calculate Percentage
Let us understand the above formula with some examples.
Example – Calculating Percentage
For example, a test of 5 subjects was taken each having 100 marks. Thus, a total of 500 marks of which a test is taken.
Now the number of marks obtained by any student will be a portion of this number. Let us assume that a student obtained 400 marks.
Thus, applying the above formula, the calculation will be as follows:
400 / 500 X 100 = 80%
Formula to Calculate Percentage Value
Let us understand the above formula with some examples.
Example – Calculating Percentage Value
For example, if there are 200 apples and 20% are rotten. Applying the formula given above, the calculation will be as follows:
200 X 20 / 100 = 40 apples are rotten.
Percentage Practice Sheet Excel Template
To simply the learning process and learn with the play we have created a simple and easy to Percentage Practice Sheet Excel Template with predefined formula and macros.
This sheet helps you to practice percentage and test your knowledge also. In addition to this, it also consists of a printable version which helps to do practice on printed sheets.Click here to Download All Educational Excel Templates for ₹299.
You can download other useful educational templates like Student Study Planner, MCQ Test Sheet, Basic Division Test Sheet, Basic Subtraction Test Sheet, Basic Addition Test Sheet, and Multiplication Table Test Sheet.
Let us discuss the contents of the template in detail.
Contents of Percentage Practice Sheet Excel Template
This template consists of 7 sheets as follows:
- Basic Percentage Practice Sheet.
- Basic Percentage Test Sheet.
- Printable Basic Percentage Practice Sheet.
- Advanced Percentage Practice Sheet.
- Advanced Percentage Test Sheet.
- Printable Advanced Percentage Practice Sheet.
- Tips and Tricks Sheet.
Basic Percentage Practice Sheet
This sheet consists of two tables. Each table consists of 15 sums, that is 30 sums for practicing percentage. The sheet consists of a color pattern that you need to follow.
The cells with dark blue cells have predefined formulas and thus you don’t need to enter any data in it. Make sure you instruct your child for the same.
Above the first table insert the percent you want your child to find for every given number in the table. For example 10%. A formula is applied to the cell adjacent to the answer cell. This identifies whether the answer to the given percentage is right or wrong.
First and foremost, insert a range of numbers that you wish your child to practice. It can be 2,3 or 4 digit. Insert the desired range.
Click the “New Number” button below the range. It will change the questions between the given range. It chooses random numbers from the range and displays it in questions.
Give the sheet to the child to practice. If the answer is right the cell adjacent to answer will display “Good Job” and if the answer is incorrect then it displays “Try Again!” and turns the cell red.
Once your child completes the test, tell them to click on “New Number” button to get another set of questions. Your child can practice until the child and you are satisfied with the learning.
That’s it. Isn’t it so easy for you and also for your child to practice Percentage sums?
Basic Percentage Test Sheet
On completion of practice, it is necessary to test the knowledge of the child. A test sheet has been created for this purpose.
For taking a test. Follow the following steps:
- Insert Range of numbers for the macro to generate the sums.
- Click on “New Numbers” button.
- Hide row 38 to Row 47.
As soon as the child completes the test, unhide the rows and it will display the test results.
Printable Basic Percentage Practice Sheet
In case you are a tutor and want to conduct a test for multiple students, then this printable version of the Basic Practice Sheet is a great option.
You can conduct a test in two ways:
- Giving a similar sheet to your students.
- Giving different sheet to each child to avoid copying.
To give a different sheet:
- Take the first print.
- Click on “New Numbers”
- Take another print.
- Repeat the same to the desired number of sheets required.
Before taking the print, make sure you check the print preview.
Advanced Percentage Practice Sheet
This sheet is different from the basic percentage sheet. In basic, your child finds one percentage for all numbers whereas in this sheet it helps to practice a different percentage for each number. This sheet is for students studying in higher grades as it involves odd number percentage calculations.
In this sheet, there are two ranges, one for the percentage and other for the numbers.
Similar to the above sheet, you need to insert the ranges and click on “New Numbers” button. This will generate the percentage of sums from the given percentage range and number range.
Leave the child with the sheet to practice advanced percentage sums. The cell adjacent to the answer displays “Good Job” if the answer is correct and “Try Again!” if the answer is incorrect.
Click on “New Number” button. This will change the question and your child can practice another set of sums for more practice. Your advanced percentage practice is done.
Advanced Percentage Test Sheet
After practice, comes the task of testing the child’s knowledge. As discussed earlier, this sheet is for elder kids as it has hard sums.
To take a test, just follow the below-given steps:
- Insert range for both, Percentage and numbers that you wish to take.
- Click on “New Numbers”.
- Hide Row 41 to Row 52.
Unhide the rows after the test is complete. This will display the test result. No hassle to make test sheets, check them and calculate marks. All is done by itself.
Printable Advanced Percentage Practice Sheet
Similar to the printable basic practice sheet you can take a test in two ways. One is by printing the same sheet multiple times and second by giving a practice sheet with different questions to each student.
To give a different sheet, you just have to take the first print and click on “New Numbers” and then print. Repeat the same for the desired number of sheets.
Tips and Tricks Sheet
In the end, a sheet with some pro tips has been given which will help you to understand the concept of percentage and give you tricks on how to easily find percentage in fractions of seconds.
These tips are given by profound teachers and make the student faster in calculating the percentage.
We thank our readers for liking, sharing and following us on different social media platforms.
If you have any queries please share in the comment section below. We will be more than happy to assist you.