- Data Structure
- Networking
- RDBMS
- Operating System
- Java
- MS Excel
- iOS
- HTML
- CSS
- Android
- Python
- C Programming
- C++
- C#
- MongoDB
- MySQL
- Javascript
- PHP
- Physics
- Chemistry
- Biology
- Mathematics
- English
- Economics
- Psychology
- Social Studies
- Fashion Studies
- Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Pradeep Kumar has Published 1236 Articles
Pradeep Kumar
1K+ Views
A protected workbook is one that cannot be edited without authenticating the person who created it. But we can also allow certain users to edit cells in Excel without entering the password for the workbook. For allowing certain users to edit cell ranges in Excel, we can use a simple ... Read More
Pradeep Kumar
2K+ Views
When we have data with a column of numbers and the $ symbol, it is critical that all of the dollar symbols align to the left of the data. Aligning the data means simply keeping the dollar signs of all values in the column on top of each other; aligning ... Read More
Pradeep Kumar
496 Views
When we type or copy the data that contains floating-point numbers or decimal numbers, the default alignment makes the data look very messy, and it is a very complex process to understand the data. It also looks very ugly in Excel. There is a solution for this problem. The solution ... Read More
Pradeep Kumar
6K+ Views
A bubble chart in Excel is one of the types of scatter charts used in Excel. The bubble chart represents the data points in the form of bubbles, and the size of the bubble depends on the occupancy we mentioned in the data set. In a bubble chart, the graph ... Read More
Pradeep Kumar
11K+ Views
In Excel, a bar graph is a type of chart that represents data by placing bars vertically in the graph. We can analyse the difference between the many values using the bar graphs. We occasionally believe that the width of the bar graph is too narrow and wish to change ... Read More
Pradeep Kumar
183 Views
When we want to combine the data of many cells into one cell, we can use the concept of formulas in Excel. We can add the data of two or more cells into one cell in one of two ways: by using the keyword CONCAT or by using the "&" ... Read More
Pradeep Kumar
18K+ Views
A unit is a measure of any value. For example, we measure mass in units of grams or kilobars. For each measure, there can be multiple units to measure it. We can't specify the measure for any value unless we have units. In general, we will try to represent every ... Read More
Pradeep Kumar
12K+ Views
Trailing zeroes are the zeroes that can be added after the number, which do not affect the value of the number. Some of the cases where we use trailing zeroes are when we calculate the mathematical values. In these cases, we can add the trailing zeroes after the dot in ... Read More
Pradeep Kumar
5K+ Views
Sometimes we may have to copy the data from an Excel sheet to a Notepad file. If we directly copy the data in Excel into Notepad, the whole thing will look very clumsy. So, before copying the data, we have to add trailing spaces for every cell in excel, then ... Read More
Pradeep Kumar
6K+ Views
A stacked column chart in Excel is a basic chart that allows part-to-whole comparisons at one time. In this type of chart, the data labels are kept on top of each other to form a single bar for each graph data variable. A stacked column chart helps to understand the ... Read More