How can you use Excel to do these tasks?
1. Find the total number of students admitted in each year,
2. Sort the number of students admitted in ascending order for School C
3. Find the average number of students admitted in each school between 2009 and 2013.
4. Find the year in which the minimum number of students were admitted
in School-B.
5. Count the number of years given.
Answers
Answer:
Planting trees for the environment is good as they are renewable, biodegradable and recyclable. If we plant 20 million trees, the earth will get with 260 million more tons of oxygen. ... During photosynthesis, trees and other plants absorb carbon dioxide and give off oxygen. Trees keep in cheek the air and water pollution.
Answer:
1. To find the total number of students admitted in each year, we can use the SUM( ) function in Excel.
2. In Excel to sort the number of students admitted in ascending order for School-C, we can use the Sort tab. Then, we can use the Ascending order tab in the Sort tab.
3. To find the average number of students admitted in each school between 2009 and 2013, we can use the AVERAGE( ) function in Excel.
4. To find the year in which the minimum number of students were admitted in School-B, we can use the MIN( ) function in Excel.
5. To count the number of years given, we can use the COUNT( ) function in Excel.