answersLogoWhite

0


Best Answer

The VLOOKUP function would be the best one to use. You need to set up a table with the name of the grade and the range of marks for that grade. You then compare each score against the range in the table and it will read off the apporpriate grade. Do some research on the VLOOKUP function and that will help.

User Avatar

Wiki User

10y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is the most efficient Excel function to use in assigning grades to students based on their final percentage?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How do you use taxon in a sentence?

The students had difficulty assigning the creature to an appropriate taxon.


Would this way of assigning roles be an example of a function if there are 20 students and 20 available roles and each student is assigned exactly one role in the play to be played by only one student?

Yes, it would.


What is the percentage of students are male?

It is not specified how many students there are in total, so it is not possible to calculate the percentage of male students without that information.


What has the author James S Terwilliger written?

James S. Terwilliger has written: 'Assigning grades to students' -- subject(s): Educational tests and measurements, Grading and marking (Students)


If Randomly assigning students to two different groups in an experiment on memory would be?

An important measure for controlling bias (APEX)


What percentage of college students are non-traditional students?

89 percent


What percentage of students change their mind about college during a gap?

the percentage of students change their mind about college during a gap is 50%


How many students bring in a weapon each year?

what percentage of students bring drugs to school each yearwhat percentage of students bring weapons to school each year


What is the function of students in education?

Students are the consumers of an enterprise called the education.


What is the function of classroom?

the function of a classroom is to hold the students, so they can learn


What is a good closing sentence for a debate on should homework be banned?

In conclusion, the evidence presented clearly demonstrates the potential benefits of banning homework for students. By eliminating this burden, we can prioritize well-being, quality family time, and a more efficient learning experience. It is time to reevaluate the purpose and effectiveness of assigning homework in our education system.


What percentage of college students drive a luxury car?

There is no specific data on the exact percentage of college students who drive a luxury car. It is likely a very small percentage as luxury cars are expensive and not typically affordable for most college students.