Perfect Computer Notes

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 ...

Difference between Compiler and Interpreter The Compiler and Interpreter are the two main types of Language Translator or Language Processor Explain some important differences between Compiler and Interpreter or Differentiate between Interpreter and Compiler Compiler                                    Interpreter                              1.    Compiler   converts   a   source program   into machine code as a whole.                                 1.  Interpreter    converts    a    source program    into machine code one statement at a time.            2. Compiler after translating whole...

Sometimes, a person needs the exact age calculation from his / her date of birth to a specific date, for example when he / she applies for a job. The employer demands the required age must not be more that 21 years on the given last date for submitting job application. Calculate your age from your date of birth in MS Excel with Datedif() function             In such situation,  we need to calculate exact date in years, months and days. Because the difference of  a single day will also be considered.            Today, we will learn, how to prepare Microsoft Excel Worksheet for calculating Age in Years, Months and Days with the help of formulas and functions provided in MS Excel. We will also find and display the actual day of birth from the given date of birth for a person. Age Calculator Designed in Microsoft Excel Using DATEDIF Function Preparation Of MS Exce...

Here is a simple Microsoft Office tutorial using Microsoft Excel to create a 3-D Line Chart. You just need some sample data entered into a Microsoft Excel Worksheet and acting upon the steps provided in this Microsoft Excel Tutorial on Developing a 3-D Line Chart . The procedure is simple and explained with the help of clear and big images so that you can understand easily How to create a 3-D Line chart. Step 1: Start MS Excel Start Microsoft Excel with a new blank Excel Workbook. You will use the very first Microsoft Excel Worksheet for entering data and creating a 3-D Line chart . Step 2: Type Sample Data for 3D Line Chart in Excel Worksheet Type data of two cricket teams as shown in the figure. Type data in 3 columns, Overs, Scores Team A, and Scores Team B. Create 3 D line Chart in Microsoft Excel Easy Steps Step 3: Select Data for 3D Line Chart Select all data including the three columns from Overs to Score Team B. Select Data Create 3 D line Chart in Microso...

What is a Computer Security Threat? A computer security threat may be defined as any action or event that may cause damage to any part of a computer system. Computer System Security Threats  How Does Computer Security Threat Cause Damage? A Computer security threat may cause damage to hardware, software, data , information or processing capability of a computer system. Different Types of Computer System Security Threat There are many different types of security threats to computer systems as follows: Hacker Virus Worm Adware Tech support scams Ransomware  PUP Potentially Unwanted Software Hacker  Hacker is a person who uses computer system to access private data of illegally. Hackers access a computer network and its resources illegally. Hacker - Security Threats To Computer Systems and Networks Hackers have a vast knowledge of computer science and are computer experts. They may have deep knowledge of  high level programming lan...