There are few Full-Forms for important words used in the Computer world. These short words are also known as Abbreviations. An individual should know at least these terms if want to learn Computers. Abbreviations to Full-Forms Abbreviation Full-Form .com Commercial Internet Site .edu Education Site .gov Government Site .in India .net Internet Administrative Site .orgRead More
Computer
Computer Basics -13 || Creating pivot charts/tables in Excel.
In our last chapter we have learnt the Adavantages of the Pivot charts/tables over the regular charts in Excel spreadsheets. Creating Pivot Charts Creating a Pivot Charts is as simple as we used to generate regular charts in excel. For this, we have to first collect the data in tabular format in an excel sheetRead More
Computer Basics -12 || Advantages of PivotCharts over Simple Charts in Excel.
PivotCharts are the basically extended version of the simple charts like Column, Line or Pie Charts. PivotCharts provides a customized functionality to handle normal charts. In my previous blog, I had described how to implement, a different type of charts in Microsoft Excel. So, I would recommend before moving ahead just have a look atRead More
Computer Basics -11 || Using Charts in place of Data Tables in Excel.
Charts are the graphical representation of the data. Using Charts in place of Data Tables are more realistic than tables or any other mode of presenting data. This is a very attractive feature of Excel, which is used by each professional to create their presentations, reports, data collection, etc. Note: A table should have atRead More
Computer Basics -10 || How to apply Filter in a data set in Excel?
Simple meaning of Filter is to get only relevant information from the heap of data. Data and Information Before moving ahead I just wanted to make you understand the difference between Data and Information. Data is a collection of lots of content in the form of Numbers, characters, images etc. On the other hand, identifyingRead More
Computer Basics -9 || Understand and Implement Data Validation in Excel.
Data Validation is the feature to restrict the end user to enter incorrect or invalid data in a particular cell or report. Data Validation Data Validation can be used for a range, specific list of values, formula-based condition etc. based on the requirement. There are multiple scenarios where we need to restrict the user, fewRead More
Computer Basics -8 || Let’s learn the usage of MS-Excel.
Excel is mainly used to do accounts related work and to maintain huge record like we do in databases. When we open the Excel application and create a new file it looks like the Math Copy, we have used in our school during the study. These files contain grids to store data and records. ExcelRead More
Computer Basics -7 || Important Features of MS-Word.
MS-Word is a desktop application provided by the Microsoft. It is a part of the Office suite. Microsoft has already launched an office suite which contains all the important applications which have been used in our day to day life. However, there are three main applications which have been used all over the world. ThisRead More
Computer Basics -6 || Understanding MS-DOS Commands.
MS-DOS stands for Microsoft Disk Operating System. It was the first command based operating system. There are two types of Operating System available. CUI(Command User Interface) and GUI(Graphical User Interface). GUI (Graphical User Interface) The normal operating systems like Windows 7, 8, 10, MAC OS are the GUI based OS. Benefits of GUI based OS:Read More
Computer Basics -5 || Understanding of Number System.
All the processes in the digital world are the game of numbers. To manage all this process and providing the information is called the Number System. Most commonly used number system is the Decimal Number System (base 10). Which we have used in general life also. Other major number systems are the Binary Number System(baseRead More