Perfect Computer Notes

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: 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. It will calculate total inquiries by adding the inquiries of the three classe...

Today we will discuss the Excel Worksheet Formulas for recording Monthly House Construction Expense Management . Steps To Create Expense Management Excel Worksheet First of all, start MS Excel with a new workbook. 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 accor...

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

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