Today, we will prepare a

We will open a new Excel worksheet and prepare the basic structure of worksheet according to the given picture of

Attendance Percentage = Lectures Attended / Lectures Delivered * 100

In

Attendance Percentage = =E4/D4*100

As we can see in the Excel worksheet's image provided that Lectures Attended by first student are in the cell with cell reference E4 and Total Lectures Delivered by the teacher are in cell D4, therefore, we divide cell E4 by D4 and multiply by 100 to get the required percentage.

Remarks = Allowed (if Attendance Percentage is greater than or equal to 80 %)

and

Remarks = Rejected (if Attendance percentage is less than 80%)

Remarks = =IF(F4>=80,"Admission Allowed","Admission Rejected")

We will copy the formulas in the remaining cells.

**Microsoft Excel Worksheet For Lectures Attendance Percentage of Students**For__Checking the Eligibility in Appearing in Exams__.Excel Worksheet for Calculating Lecture Attendance Percentage of Students |

We will open a new Excel worksheet and prepare the basic structure of worksheet according to the given picture of

**to enter data of students about**__Excel Worksheet for Calculating percentage of Lectures attended by students__**lectures attended and lectures delivered**. We will also note the Serial number and Students Name also. With the help of two facts that is Lectures Delivered and Lectures Attended,**given below:**__Attendance Percentage will be calculated by the formula__Attendance Percentage = Lectures Attended / Lectures Delivered * 100

In

**Excel Formula, Calculate Percentage of Lectures Attended by Students using Excel Worksheet Formula:**Attendance Percentage = =E4/D4*100

### Explanation of Excel Formula for Calculation of Attendance Percentage

### Calculation of Remarks for Eligibility of a Student to appear in Examination

Similarly, we will calculate the Remarks with the following formula:Remarks = Allowed (if Attendance Percentage is greater than or equal to 80 %)

and

Remarks = Rejected (if Attendance percentage is less than 80%)

__For this purpose we will use IF() logical function.__Remarks = =IF(F4>=80,"Admission Allowed","Admission Rejected")

### Explanation of Excel Formula for Calculation of Remarks Column

As we know that the Percentage of lecture attendance of first student is in cell with reference F4, therefore we will check that if F4>=80 then the text "Admission Allowed" to appear in examination, will be displayed. And if the given condition F4>=80 is false then text "Admission Rejected" will be shown in the Remarks Cell.We will copy the formulas in the remaining cells.

## 0 comments:

Post a Comment