Perfect Computer Notes

Super Easy Short Computer Notes To Improve Computer Literacy and Your IT Skills

Sponsored Links

Sunday, June 17, 2018

Join Pak Army as Captain by Lady Cadet Course LCC-14 Jobs In Pakistan Army

Leave a Comment

Join Pakistan Army as CAPTAIN through LADY CADET COURSE LCC-14


Apply online for the Job of Captain in Pakistan Army, through the link provided below

Join Pakistan Army


Dates of Online Registration: 19 June to 02 July, 2018

Eligibility Conditions for Jobs of CAPTAIN in Pakistan Army 

Eligibility Conditions for Captain - Lady Cadet Course Join Pakistan Army
Eligibility Conditions for Captain - Lady Cadet Course Join Pakistan Army

           Image source as on 17-06-2018, 8:15 AM: https://www.joinpakarmy.gov.pk

Please read final details of Jobs in Pakistan Army as CAPTAIN through Lady Cadet Course LCC-14 on Pakistan Army website, the link is provided above. Thanks

The Advertisement in news papers of Join Pakistan Army as Captain Lady Cadet Course LCC 14


The Advertisement in news papers of Join Pakistan Army as Captain Lady Cadet Course LCC 14



Read More...

Monday, June 11, 2018

Excel Worksheet For Calculating Percentage of Lectures Attended by Students

Leave a Comment
Today, we will prepare a 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
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 Excel Worksheet for Calculating percentage of Lectures attended by students to enter data of students about 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, Attendance Percentage will be calculated by the formula given below:

Attendance Percentage = Lectures Attended / Lectures Delivered * 100

In Excel Formula

Attendance Percentage = =E4/D4*100

Explanation of Excel Formula for Calculation of Attendance Percentage


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.

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.

Read More...

Wednesday, May 30, 2018

Download List of e-Branches For Fresh Currency 2018 By SMS

Leave a Comment
The State Bank of Pakistan has published the list of Branch IDs of all e-Branches for all cities of Pakistan. This is a PDF file.


This pdf file is available on website of the State Bank of Pakistan.

The State Bank of Pakistan has issued a list of 21 e-Branches for Rahim Yar Khan City as shown in the following figure. You can download the complete PDF list of Branch Ids of e-branches for fresh Currency Notes SMS from the link given below.


You can download this list of Branch IDs for e-Branches for issuing Fresh Currency to general public. 


Download List of Branch IDs of e-Branches for Fresh Currency Notes 2018


How To Get New Fresh Currency Notes For Eid 2018


Read More...
Sponsored Links

Featured Post

Remove USB Virus Easily by Free Software SMADAV 2018 USB Antivirus

Download Smadav 2018 Free USB Antivirus and Clean your USB easily from viruses: Smadav 2018 : The Best Free Anti Virus For cleaning USB...

.