word2010 how to calculate with the formula
Methods/Steps
First of all, in Word2010 to establish a table of student results, and use the formula to calculate the total score of each student’s grades and grade point average, but also need to calculate the total score of each course and grade point average,:
Calculation of the total number of students’ grades: the mouse cursor will be moved to the table. Menu bar will appear on the [Layout] button, click [Layout] menu under the [Formula] button, pop-up formula settings dialog box, the default formula is [= SUM (LEFT)], the meaning of the formula is relatively simple, that is, it means to take the left side so the total value of the figures, click on the [OK] button to calculate the total value of the student’s grades,
Calculation of the average score of the student’s grades: Move the mouse cursor to the form, the menu bar will appear [Layout] button, click [Layout] menu under the [Formula] button, pop-up formula settings dialog box, delete the default formula, in the [Paste Function] in the choice of [AVERAGE], the formula is set to [= AVERAGE (B2: F2)], the formula means to take the average of the numbers from B2 to F2, click [OK] button to calculate the average of students’ grades,
Calculate the average of student grades: Move the mouse cursor to the form, the menu bar will appear [Layout] button, click [OK] button calculate the average of student grades Achievement of the average,
Calculation of the average value of the language: the mouse cursor to move to the form, the menu bar will appear on the [Layout] button, click on the [Layout] menu under the [Formulas] button, the pop-up formula setup dialog box, delete the default formula, in the [Paste Function] in the [AVERAGE], the formula is set to [= AVERAGE (B2: B6)], the formula means to take the average of B2 to B6 figures, click [OK] button to calculate the average language results,
5
Calculate the total value of the language: the mouse cursor to move to the table, the menu bar will appear on the [Layout] button, click on the [Layout] menu under the [Formulas] button, the pop-up dialog box for formula settings, the formula is set to [= SUM (B2) :B6)]], the formula means to take the total value of B2 to B6 figures, click [OK] button to calculate the total value of the language results,