Perfect Computer Notes

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 Sponsore

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 from key

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"))))