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 .org …
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 sheet …
Computer Basics -13 || Creating pivot charts/tables in Excel. Read More »
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 at …
Computer Basics -12 || Advantages of PivotCharts over Simple Charts in Excel. Read More »
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 at …
Computer Basics -11 || Using Charts in place of Data Tables in Excel. Read More »
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, identifying …
Computer Basics -10 || How to apply Filter in a data set in Excel? Read More »
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, few …
Computer Basics -9 || Understand and Implement Data Validation in Excel. Read More »
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. Excel …
Computer Basics -8 || Let’s learn the usage of MS-Excel. Read More »
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. This …
Computer Basics -7 || Important Features of MS-Word. Read More »
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: …
Computer Basics -6 || Understanding MS-DOS Commands. Read More »
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(base …
Computer Basics -5 || Understanding of Number System. Read More »
Ashok Kumar is working in an IT Company as a QA Consultant. He has started his career as a Test Trainee in manual testing in August 2010. Then he moves towards the automation testing after 4 years. He started learning JAVA and Selenium by self to get the knowledge of automation.
While learning these tools and working on multiple projects, he found that sometimes people get stuck in live scenarios in their project and they have to do lots of RnD to get out of it. So he decided to start blogging only for such scenarios, where anyone facing any problem in their project, can ask any question or give a solution or you can say an alternate solution to achieve the goal successfully.
Later on, he observed that some people want to learn Java but they have few questions in their mind like how to start Java, whether we should go for the online or offline course. So he started writing tutorials on Java, Jira, Selenium, Excel etc.
