Datesheet MCS Semester III Session 2016 2018 Affiliated Colleges IUB

Download Datesheet of MCS (Third Term)Semester III Final Term, Session 2016-2018 for students of Affiliated Colleges with Islamia University of Bahawalpur - ( IUB Bahawalpur )

Datesheet of MCS Semester III Session 2016-2018 for students of Affiliated Colleges with Isamia University of Bahawalpur - ( IUB Bahawalpur )

According to the Date sheet issued by the Islamia University of bahawalpur, the Final term examination of MCS Third Term (3rd Semester)session 2016-2018 will start from Monday, 23 April, 2018.

Timings of the papers will be in evening from 2:30 PM to 4:45 PM. The center for all students of Rahim yar khan city is Khawaja Farid Govt. Postgraduate College, Rahim Yar Khan. For details check the image of date sheet of Masters in Computer Science:

Use of Power and Sqrt Function in Excel Worksheet

Today, we will discuss the use of POWER( ) function and SQRT( ) function in Microsoft Excel Worksheets. We will prepare  a worksheet to practically learn the use of Power () function and Sqrt() function

as shown in the following figure:

Use of POWER( ) function and SQRT( ) function in Microsoft Excel Worksheets

The Use of POWER( ) function in MS Excel Worksheet

POWER function may be used to raise a number to a certain power. For example, to calculate number 2 raise to the power of 3, we will type the power function as:
    =POWER(2,3)
which will return the result 8. If the number is in cell B3, we will type the power function as follows:
  =POWER(B2,3)

Steps To Create an Excel Worksheet To Demonstrate Use of Power() and Sqrt() Function

1. Start Microsoft Excel with a new blank workbook.

2. Type the data as shown below in the first worksheet.

3. Perform formatting in Excel worksheet as shown in the following figure.

4. Type data in Column A and Column B of worksheet.

5. In cell C3 of column C , we will type a formula using Power() function to calculate Square of given number.

6. Type = in cell with reference C3.

7. Type POWER(B3,2) and press Enter.

8. Since we have entered number 4 in B3 cell so Power(B3,2) will return 16 in cell C3.

  

The Use of POWER( ) function in MS Excel Workshee

The Use of SQRT( ) function in MS Excel Worksheet

The Excel function SQRT is used to calculate the square root of any number given as its argument.
For example, if you use wish to calculate square root of 4, you will type SQRT function as follows:
  =SQRT(4)   
which will give 2 as a result.

9.   In cell D3 of column D , we will type a formula using Power() function to calculate Cube of given number.

10. Type = in cell with reference D3.

11. Type POWER(B3,3) and press Enter.

12. Since we have entered number 4 in B3 cell so Power(B3,3) will return 64 in cell D3.

The Use of SQRT( ) function in MS Excel Worksheet

13. In cell with reference E3  , we will type a formula using Sqrt() function to calculate Square root of given number.

14. Type = in cell with reference E3.

15. Type SQRT(B3) and press Enter.

16. Since we have entered number 4 in B3 cell so SQRT(B3) will return 2 in cell E3.

We have completed the task of creating a worksheet in MS Excel using Power function and SQRT() function.

Excel Worksheet Student Absence Fine Calculation Formulas

Today, we will discuss how to create an Excel Worksheet that helps calculate Students Absence Fine Calculation on basis of Total Lectures Delivered and Total Lectures Attended (Presence) of the student.

Excel Worksheet Student Absence Fine Calculation Formulas

Steps To Prepare an Excel Worksheet for Student Absence Fine Calculation

1. Start MS Excel with a blank workbook option.

2. Type sample data in first Excel worksheet as shown in the given image.

3. Type formula for calculation of number of absence of a student.

    Place cursor in Cell with reference E3.

    Type = sign in E3

    Type C3-D3 and press Enter

Steps To Prepare an Excel Worksheet for Student Absence Fine Calculation

4. Copy the formula of cell E3 in all lower level cells with the help of Fill Handle in 

    lower right corner of Cell E3.

5. Type formula for calculation of fine by multiplying cell E3 with 50.

6. Type formula of fine calculation =E3 * 50 and press enter in cell referenced by F3.

7. Copy the fine calculation formula downward in all required cells of column F.

8. Congratulations you have successfully prepared Excel Worksheet for Absence Fine calculation of         students. 

9. Please, do not forget to save file.

How to Create College Admission Inquiry Report in Excel

Today, we will discuss how to prepare an Excel worksheet for Admission Inquiry in a College. Actually the management of the college wishes to monitor the Performance of the marketing and advertising staff. The advertising and publicity staff of the college is responsible for taking steps to better publicize the good reputation of the college and attract new  students for admission in college classes.

Excel Worksheet For College Admission Inquiries Performance Report

The Excel worksheet about Admission inquiries performance report will perform the following tasks:

1. It will record Serial No., Date, Inquiries for ICS, B.Sc.(ACS) and MCS

       Note: ICS stands for Intermediate in Computer Science, ACS stands for Advanced Computer                         studies and MCS stands for Master in Computer Science.

2. It will calculate total inquiries by adding the inquiries of the three classes.
3. It will output a message in Performance column as given below:

• Show a message "Excellent"  for inquiries greter than or equal to 100
• Show a message "Good"  for inquiries greter than or equal to 80
• Show a message "Satidfactory"  for inquiries greter than or equal to 40
• Show a message "Unsatisfactory"  otherwise, that is when inquiries are less than 40 per day.

Steps to create Admission Inquiries of a College Worksheet in Excel

1. Prepare the basic admission inquiries worksheet with proper formatting

Guidelines for Formatting the Admission Inquiries Performance Report Worksheet

Type necessary headings in the worksheet. If you wish to merge cells, perform the steps as shown in the figure below:

Apply Merge and center option in Excel worksheet

You can apply middle align options as shown in the figure below:

Apply middle align option in Excel worksheet

You can increase font size of the text in cells:

You can apply borders option to selected cells in the worksheet as shown in the following picture:

You can insert word art in Excel worksheet as shown in the image below:

You can insert word art in Excel worksheet

2. Enter sample data in worksheet as shown in the figure.

3. Enter necessary formulas and predefined functions
4. First of all, when you start work on the worksheet, save the workbook with a proper name as College Admissions Inquiries Report Worksheet. During your work, press CTRL + S from keyboard to save changes, often.

How To Use Necessary Formulas and Functions

In this worksheet, we will use two functions according to the requirements
     1. SUM function
     2. IF function

Using SUM function to get Total Inquiries

Place cursor in cell referenced by F4.
Type  =
Type name of function that is SUM
Type address of ICS cell referenced by C4
Type a colon :
Type address of cell MCS referenced by address E4
Press enter
The total of inquiries will be shown in cell F4.

Apply Sum function in Excel worksheet

Using Logical IF Function To Show Suitable Message according to Total Inquiries

We will use IF function as following:

=IF(F4>=100,"EXCELLENT",IF(F4>=80,"GOOD",IF(F4>=40,"SATISFACTORY","UNSATISFACTORY")))

Syntax of IF logical function is:

IF(Logical-Test, Value-If-True, Value-If-False)

Example of IF Function is

=IF(F4>=40,"Satisfactory","Unsatisfactory")

It will give Satisfactory if cell F4 contains a number greater than or equal to forty or it will return Unsstisfactory otherwise, when less than forty.

Apply Logical IF function in College Admission Inquiries Report Excel worksheet

House Building Expenses Formulas in Excel

Today we will discuss the Excel Worksheet Formulas for recording Monthly House Construction Expense Management.

Steps To Create Expense Management Excel Worksheet

1. First of all, start MS Excel with a new workbook.
2. Merge required number of cells in first row of worksheet.

       

      3. Insert Word Art and type a suitable title heading in worksheet.

      4. Enter heading row.

      5. Enter data in worksheet.

      6. Apply the formulas and functions in worksheet as explained later.

       

Here is the list of expenses we have considered to be recorded.

Sr. No	Item
1	Cement (Bags)
2	Bricks(Trolly)
3	Sand(Trolly)
4	Gravel(Truck)
5	Iron (Kg)
6	Marble(Square Feet)
7	Electricity Bill
8	Labour
9	Miscelleaneous

You can increase this list of expenses according to your wish. The Excel worksheet formulas are provided for the worksheet as shown in the figure below:

Monthly House Building Expenses Calculator Formulas in Excel

If you change the worksheet, it is not difficult to change the construction management formulas in Excel according to your expense list.

The formulas used in Construction Expense Management Excel Worksheet

The formulas used in Construction Expense Management Excel Worksheet are given as follows:

Excel Formula No. 1:

Amount = C3 * D3

Explanation:

First formula will be used to multiply Rate per Item Column Cell with Quantity Column Cell. We can easily check from the above figure of home expenses worksheet that the related column cells are C3 and D3. We use multiplication operator * to multiply these cell values. Don't forget to place = operator before typing the formula. We will insert formula by typing =C3 * D3 in cell E3. Remember that cell E3 is in the Amount (E) column.

Excel Formula for Calculation of Amount

 = C3 * D3

How To Copy Formula in the Cells Below

• Type the formula in cell E3. 
• Point to the lower right corner of this selected cell E3.

• The cursor will take the Plus sign shape.
• Now keeping the left button pressed, drag the mouse downward selecting the cells you wish to copy formula in.

       

• Release the left button of mouse.
• You will see that formula has been copied and the results of formula appeared in the cells.

Calculate Monthly Building Expenses by Formulas in Excel Worksheet

Excel Formula for Calculating Total Amount of All Expense

Type   = SUM(E3 : E11) in cell E12 and press Enter key. The formula will produce the resultant value. This result gives us the total monthly expense during a given month.

Total Expenses during month by excel formulas

The total monthly expense  is shown below:

Download Free Top Antivirus Program - Avast Antivirus of 2018

Let us discuss Why Avast is Number One Free Antivirus Software Solution of  2018. By downloading and installing Avast Antivirus you can get the best virus free working environment in your PC as well as Android Smart Phone.

Why Avast is Number One Free Antivirus Software of 2018

Main Features of AVAST Free Antivirus are discussed here while describing the Top 10 reasons to select AVAST free Antivirus as Number One in 2018:

1. AVAST in 2018 is More Efficient

   New Avast software is more efficient and lighter because of less consumption of critical system resources.

2. AVAST is More Powerful

Avast is more powerful for detecting and removing a vast range of security threats trying to attach on your PC.

3. AVAST is with Pleasant Look and Feel

AVAST provides easy to use graphical User Interface which is attractive and eye catching as well as easier to use effectively. A layman or new computer users can easily use Avast antivirus software.

4. Avast is Easy To Install

AVAST antivirus comes with an easy to install complete setup program. The installer is completely configurable. You can skip the installation of unnecessary third-party components.

5. AVAST Provides different scan mode Options

AVAST provides a QUICK SCAN mode to perform a quick scan in areas where malware is known to hide. By seleting complete scan mode, you can get searched and analyzed  your entire computer system. AVAST also provides a boot time scan to check autostart processes and services.

6. Efficient AVAST Quarantine System

Suspected infections may be sent to the quarantine for deciding later to keep or eliminate them.

7. Auto Check for Virus Definition Updates

AVAST provides an excellent virus definition updater system when you are connected with internet.

8. Avast comes with Extra security tools

Avast provides the security tools including browser protection and cleanup for top web browsers e.g. Internet Explorer, Google Chrome, Mozilla Firefox. Avast provides a software updater for other programs installed.

9. Avast's Transparent Policy for Private Data Collection

Avast software will tell you whenever it wants to gather anonymized usage data which may be useful for further and better development of the antivirus software. You can disable this data collecting function from privacy settings.

10. AVAST is Totally Free Anti-malware Software

And above all, AVAST is a totally free antivirus protection software for your PC and Android Smart Phones. AVAST provides antivirus solution for Personal Computers as well as for Android Smart Phones.

How To Download and Install Avast Free Antivirus

Sponsored Links

You can download AVAST Free Antivirus from AVAST website link.

How To Create Income Tax Calculation Excel Worksheet

Microsoft Excel may be used to prepare employee pay sheet with Basic pay, medical allowance, conveyance allowance, house rent and income tax entries. Each of the mentioned entries in worksheet will be calculated automatically using functions and custom formulas applied to required cells in worksheet.

Income Tax calculation Formulas Calculate pay of employee using income tax in Excel

After entering the sample data in the worksheet, following formulas will be applied:

Q: Create an MS Excel Worksheet to calculate Net Pay of Employees. Input is EmpID, Name, Job
 and Basic Pay. Fill sample data in it as shown in the figure. Calculate Medical Allowance 10% of basic pay, House Rent 50% of basic Pay and Conveyance Allowance 30% of basic pay. Deduct income tax 5% of basic pay if basic pay is less than 30000 and income tax 10% otherwise.
BASIC FORMULAS:
Medical Allowance = D3 * 10%
House Rent                = D3 * 50%
Conveyance Allowance = D3 * 10%
Income Tax   = IF(D3<30000,D3*5%,D3*10%)
Net Pay  = SUM(D3:G3)-H3

You would like to :

EXPLORE  more Microsoft Excel Formulas for Worksheets and downloads

Electricity Bill Calculator Formulas in Excel 

Microsoft Excel Formulas and Functions Fast and Easy Way -1

Using Simple Formulas in Excel With Arithmetic Operators 2

How Functions are Used in Excel Fast and Easy Way 3

Create Bar Chart in Excel Easily by Example

Employee Pay sheet Formulas in Microsoft Excel 

Students Test Score Grades Result Sheet in Excel

Microsoft Office Word Processing Practicals