The list of nine most common excel errors are - #DIV/0, #N/A, #NAME?, #NULL!, #NUM!, #REF!, #VALUE!, #, Circular Reference. For the last two students (Gulp and Ganapathi), the formula returns “#DIV/0!” error Excel Error Errors in excel are common and often occur at times of applying formulas. Step 2: Format column D to obtain the efficiency levels in percentage. Step 1: Apply the formula “sales/target.” The steps to calculate the efficiency level are listed as follows: We want to determine the efficiency level (percentage) of every student. Their task is to sell products based on pre-defined targets. The following table consists of students who undertake internship in an organization. Select column I and press “Ctrl+Shift+%.” Alternatively, select “%” in the “number” group of the Home tab. For percentage values (shown in the succeeding image), change the cell formatting. Since the number of subjects is 6, the maximum marks are 600 (100*6=600). The values of the “total marks” column become the numerator. The output is shown in the following image. Drag the formula of cell H2 to get the total marks obtained by all students.For this, the marks of every subject are added.

Calculate the total marks obtained by the students.The steps to calculate percentages in Excel are listed as follows:

How to do quick analysis in excel 2010