HomeApplicationOffice informationHow to calculate grade point average in Excel fast and

How to calculate grade point average in Excel fast and standard

Calculate the average score in Excel quickly and standardly to serve the documents that need the average calculation. In the following article, TipsMake.com will guide you how to calculate the average score in Excel.

How to calculate grade point average in Excel fast and standard Picture 1

Let's first repeat the definition of the average calculation. An average calculation means that we take the sum of all the elements to average and then divide by the number of elements we have summed.

To calculate the average score, you can also apply that calculation directly to your data, as shown below, you will have to calculate the sum of the three Mathematical Physics Points and divide it by three. From there we have the following calculation for the first line:

= (C2 + D2 + E2) / 3

How to calculate grade point average in Excel fast and standard Picture 2

After using that calculation to average, you can copy that formula down to the average for the following lines.

How to calculate grade point average in Excel fast and standard Picture 3

But if you are a good Excel user, you usually do not use such a direct calculation, simply because it will take time to register the location of the data cell, and you have to count the number of elements. total.

Therefore, to make it simpler, Excel has a separate function for calculating the average score which is AVERAGE function.

The formula of the AVERAGE function is:

= AVERAGE (elements to calculate average score)

In which the elements to calculate the average score may be the elements directly separated by commas or semicolons. Or you can enter the data array containing the elements to calculate the average score.

Accordingly, along with the example that TipsMake gives, we have the formula for calculating the average score as follows:

= AVERAGE (C2: E2)

How to calculate grade point average in Excel fast and standard Picture 4

After pressing Enter you will get the result that is the average of the selected element. Continue to copy the formula in the first line down the back line easily by clicking on the bottom left corner and dragging it down to copy.

How to calculate grade point average in Excel fast and standard Picture 5

You will get the results that are the average points in the data sheet of Excel.

How to calculate grade point average in Excel fast and standard Picture 6

Next to the average score is presented beautifully and neatly with only two numbers after the comma, you click on the comma Style comma icon in the Number section in the Home ribbon of the toolbar.

How to calculate grade point average in Excel fast and standard Picture 7

The average values ​​found will be automatically reduced to only two numbers after the comma.

How to calculate grade point average in Excel fast and standard Picture 8

Thank you for reading the article How to calculate the average score quickly and accurately in our TipsMake.com . Wish you can perform this trick in the most proficient.

4 ★ | 1 Vote

You should read it

May be interested

  • How to remove words Page in Excel, delete sinking text Page 1, Page 2 in ExcelPhoto of How to remove words Page in Excel, delete sinking text Page 1, Page 2 in Excel
    how to remove words page in excel, delete sinking text page 1, page 2 in excel. in fact, the word page in excel is a feature that helps users control spreadsheets as well as pages on excel when you use them. the page break preview feature will help you control the order of spreadsheets when printing.
  • How to copy values ​​in ExcelPhoto of How to copy values ​​in Excel
    how to copy values ​​in excel. in excel, if we use the usual copy-paste method (ctrl + c - ctrl + v), you will copy the entire contents of that cell including the function.
  • How to fix font errors in Word when downloading documents onlinePhoto of How to fix font errors in Word when downloading documents online
    how to fix font errors in word when downloading documents online. after downloading the documents on the internet, there are many cases where the documents have font errors and display difficult characters. so how to fix font errors after downloading documents online? please refer to the following instructions.
  • How to make a border frame in WordPhoto of How to make a border frame in Word
    how to make a border frame in word to increase the professionalism when designing report covers and books, we often add borders to the cover page. in this article, tipsmake.com will guide you how to make a border for the cover.
  • How to put pages in Word, collapse text in WordPhoto of How to put pages in Word, collapse text in Word
    when you want to put text into one or two pages for printing, or when you make a report, there are only a few sentences at the end of the page and it jumps to the next page, the word shrink one page will help you solve that problem. there. in this article, tipsmake.com will show you how to merge pages and collapse text in word with the shrink one page feature.
  • How to number a PDF page, add pages to the PDF filePhoto of How to number a PDF page, add pages to the PDF file
    pdf files are often shared for printing or making various important documents. in this article, the software tips will guide you how to number pdf pages, add pages to the pdf file.

Office information