answersLogoWhite

0


Best Answer

There are several ways you can use Excel to determine grades. One method is to find the maximum grade within a list of grades.

EXAMPLE:

  • You have a range of grades in C3 through C125.
  • You want to find the highest grade in the list.
  • Use the forumua =MAX(C3:C125) to find the highest grades.
User Avatar

Wiki User

14y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

9y ago

You can't average actual letters. So you would have to use values and average those and then work to the nearest value. So A could be 1, B could be 2, C could be 3 and so on. To get numbers instead of letters, you could create a formula like this, where A2 stores your letter grade:

=MATCH(A2,{"A","B","C","D",E","F"})

Copy that down and you have a list of numbers. Then you would average those numbers and round the value to get a whole number. Whichever number you get would stand for the letter grade. So if the average of the numbers was 4.25, you could use the 4 to indicate a D grade. You could even use a lookup function, like VLOOKUP, or the CHOOSE function to read off the number, and display the letter. So for example, say all your grade numbers that were got by the MATCH formula above were in cells C2 to C50, you could have a formula at the end like this to get the average letter grade:

=CHOOSE(AVERAGE(C2:C50),"A","B","C","D","E","F")

This answer is:
User Avatar

User Avatar

Wiki User

11y ago

(A/100)*90

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What Excel functions could be used to help determine grades?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What functions can an accountant use in Excel?

There is a specialised category of Financial functions that an accountant could use, but they would use all sorts of different Excel functions besides the Financial functions. So regular ones like SUM and MAX and so on.


What are the types of formula in Microsoft Excel?

You could not really classify formulas into types as the amount of formulas are infinite and you can have a variety of things happening in a formula. Functions come in categories, and that is maybe what you mean. It will depend on which version of Excel you have, but these are the categories available in later versions: Cube functions Database functions Date and time functions Engineering functions Financial functions Information functions Logical functions Lookup and reference functions Math and trigonometry functions Statistical functions Text functions


Which facility of MS Excel automatic rules can be made?

Rules can be made in Conditional Formatting. Some kinds of formulas could be said to have rules. All functions have a syntax, which are the rules that determine how they have to be used. The IF function can be used to define rules to get a calculation to happen.


What type of research could allow you to determine whether students' grades accurately predict later income?

Correlation


Do you have experience in Excel such as VLOOKUP and other more advanced features?

This is a question that could be asked at an interview. To answer yes, you would need to have a good knowledge of Excel. There are a lot of specialised functions, such as VLOOKUP, that more advanced users can work with. For a job that has a lot of Excel involved it would be a good idea to look at the more advanced features, such a VLOOKUP and many other functions that a lot of ordinary users know little about. Excel has hundreds of functions and most people only know a small amount of them.


Do radiological technician use Microsoft Excel?

Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.


What is the difference between logical functions and statistical functions in Excel?

They are completely different. Statistical functions are based on numbers for things like averages, highest, lowest, count and many other functions that statisticians use. Logical functions are based on logic, comparing values to each other and doing things like finding if things are less than or equal to each other. The IF function allows you to make decisions based on conditions. You could use it to determine if someone has passed an exam or not, depending on whether their marks have reached the pass mark or not. Some statistical functions have logical elements to them, such as the COUNTIF function.


Why do we use function in excel?

Functions are like built-in formulas for Excel. They let you do some actions that could be quite complicated in a much easier way. The user does not have to think as much about how to do something when they have a function to do the calculations for them. Excel has many specialised functions, such as ones for financial or statistical purposes that very simply do something that is much more complex. This makes things easier for the user and reduces the amount of errors that they can make. Functions are one of the major advantages of using an electronic spreadsheet, compared to having to work things out manually on paper.


How do you create more slots in the if function on Excel?

You could use more IF functions, stringing them together or nesting them, which means put If functions inside other IF functions. You could also include other functions within the IF, like the AND function. It all depends on specifically what it is you are actually trying to do. There are different solutions for each problem. See more details about the IF function, including examples of nested IFs in the question below.


Can the IF function in Excel be use to calculate future revenue?

Potentially it could be used that way, depending on what data you had and how you were calculating the future revenue. If the revenue is conditional on something, then it could be used. There are lots of financial functions that could be used in relation to revenue.


What are the two components that functions generally consist of in Excel?

All functions have a name and have brackets just after them. So they could be said to be the two main components. For some functions it is mandatory to have something inside the brackets. These are usually known as arguments. For functions that do have them, there are some arguments that are mandatory.


What is the most useful function in Excel?

There is no simple answer to that question. Excel has hundreds of functions. Some are used very frequently, like the the SUM function, so that could be the most useful. Then there are others that are very powerful, like the IF function, which enables Excel to make decisions. It is very useful. A lot of users have specialised areas that they work in, so they might make use of functions in a particular category, like the financial functions. For those users, functions in those categories might be very useful. A lot of formulas have a combination of functions, and lots of functions work together with other ones. So it is very hard to pick a single function and say it is the most useful, as there are lots of opinions.