Perfect Computer Notes

Today, We will discuss the simple and easy way to unsubscribe the Utunes Service of Ufone . Remember, Utunes service will cost you at the rate of  Rs. 1.55 daily. easy way to unsubscribe the Utunes Service of Ufone I was using the mobile phone of my son when I saw an SMS message from Ufone Hisaab SMS. The message was in Urdu language and it was informing the cost of Utunes Service Rs. 1.55 per day. The message of Hisaab SMS is shown in the following figure:  What is Utunes Sevice  With Ufone UTunes service your friends and family can listen to your favorite tunes every time they call you. You can select a UTune from the content library. I think Utunes is one of the most useless services of Ufone that is costly too. So I tried to find the solution for deactivation of Utunes service instantly. How To Unsubscribe / Deactivate Utunes Service Type a new message "UNSUB" and send it to the number 666.  You will recieve a message from Ufone ...

What is a Function in Microsoft Excel? Microsoft Excel provides a large number of Functions for processing data in Excel Worksheets easily. Functions are predefined formulas in Excel. These functions are used in different types of calculations on numerical or other data  quickly. How a Function is Used in Microsoft Excel? There are three popular ways to use built-in functions in Microsoft Excel. 1. Type Functions Manually 2. Use Function Library Commands 3. Use Insert Function Dialogue Box Other Microsoft Excel Topics on www.ComputerGap.com  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 Electricity Bill Calculator Formulas in Excel    Microsoft Office Word Pro...

What are Arithmetic Operators in Excel? Arithmetic Operators are used to perform arithmetic operations like addition, subtraction, multiplication and division etc. There are following arithmetic operators in Microsoft Excel: Using Arithmetic / Mathematical Operators in MS Excel Formulas 1.  + Operator The + arithmetic operator is used to perform addition of numbers. It is used with in formulas along with Cell References normally. For example, to add the number 10 in A1 cell and the number 20 in B1 cell, we can write a formula =A1+B1 in cell C1. After pressing Enter key we will see the answer 30 in the cell C1. Important Points To Write a Simple Formula in Excel Every formula in Microsoft Excel is started with an Equal sign ( = ). Arithmetic operators (+ for addition, - for subtraction, * for multiplication, / for division) are used. Percentage is calculated by % operator. ( =B2*10%       means 10% of the number in cell B2) Pow...

Introduction Using Formulas and Functions in Microsoft Excel is really a tough job for new students. This is a series of tutorials to make the use of Formulas and Functions in worksheets, easy with various real life example worksheets. مائیکروسافٹ ایکسل میں فارمولوں اور فنکشنزکا استعمال نئے طلبا کے لیے ہمیشہ سے ایک مسئلہ رہا ہے۔ میری کوشش ہے کہ فارمولا اور فنکشن کا ٹاپک پریکٹیکلی اور پکچرز کے ساتھ تفصیل سے بیان کروں۔ Let,s start. What is Microsoft Excel? Microsoft Excel is a popular application software used to manage data in the form of rows and columns and using Excel formulas and built-in Excel functions to perform various calculations on these data. Microsoft Excel is a part of Microsoft Office. We can make different types of worksheets in Excel, for example: Employee Pay Sheet Student Test Score Result Sheet with Grades Calculation Simple Electricity Bill Calculation Formula What is an Excel Formula? Excel Formula is a proper combination of operators (like +...

Topic: Advantages and Disadvantages of LAN Local Area Network What is LAN ? - Local Area Network LAN stands for Local Area Network . It normally connects the computers and other devices within one office, building or a group of nearby buildings. Advantages Disadvantages of LAN - Local Area Network Advantages of LAN or Local Area Network 1. Resource Sharing Computer hardware resources like printers, modems, DVD-Rom drives and hard disks can be shared with the help of local area networks. This will reduce cost of hardware purchases. For example, a business organization using a Local Area Network for an office can use a single network printer for the employees of this office. 2. Software Applications Sharing It is cheaper to use same software over network instead of purchasing separate licensed software for each client in a network. It will cost more to purchase a separate licensed software for each computer in a network. 3. Easy and Cheap Communication Spon...

Today, we will discuss How to Create Bar Chart in Excel Easily by Example . A chart is the graphical representation of data. Microsoft Excel provide an easy to use Chart Wizard for this purpose. The Microsoft Excel Chart Wizard guides you on each step to perform the specific tasks and get a brilliant Chart finally. Create Bar Chart in Excel Easily by Example Steps to Create Bar Chart in Excel Easily by Example NOTE: You can chose a chart Type as BAR chart which is on number two in chart type list. For this example, here pictures are provided for the default chart type, the first one, named COLUMN CHART.  as shown in the following picture.   Create Worksheet and enter data to Create Bar Chart in Excel Easily by Example. Select the columns data. If the two columns are adjacent, Select the both columns along with column headings with the help of mouse. If the two columns are not adjacent, select first column by mouse dragging. Now press and hold CTRL button...

Today, we will discuss How to create an Students Test Score Grades Result Sheet in Excel using Formulas / Functions ( IF Function ) . The following formulas will be used in Students Test Score Grades Result Sheet: Q: Prepare the following Students Test Score Grades worksheet in MS Excel. Apply suitable formula and functions: Test Score >=90 A grade, 80-89 B grade, 70-79 C grade, 60-69 D grade, below 60 F grade, as shown in the following table: Roll No. Test Scores Grade 1 90 A 2 80 B 3 75 C 4 60 D 5 50 F Create a worksheet in MS Excel according to the requirements as shown above Enter sample data of Roll No. and Test Score Columns as shown in above table. Apply formula to calculate Grade on the basis of test scores obtained by the student. Grade Formula in Students Test Score Grades Result Sheet Grade Formula=IF(B3>=90,"A",IF(B3>=80,"B",IF(B3>=70,"C",IF(B3>=60,"D","F")))) ...