- Trending Categories
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
Namita Aggarwal has Published 114 Articles
![Namita Aggarwal](https://www.tutorialspoint.com/assets/profiles/640588/profile/60_610176-1681714605.jpg)
Namita Aggarwal
11K+ Views
Random data is a type of data generated randomly. For this article, the focus is to generate random date. Random data can be either created in between a specified range or can be generated abstractly to demonstrate some data to the user. In this article, two examples are used to ... Read More
![Namita Aggarwal](https://www.tutorialspoint.com/assets/profiles/640588/profile/60_610176-1681714605.jpg)
Namita Aggarwal
367 Views
Random data is a type of data generated randomly. For this tutorial the focus is to generate random even and odd numbers. Random data can be used to many purpose such as creating a sample data set, or to evaluate results on the based on the dataset. In this tutorial, ... Read More
![Namita Aggarwal](https://www.tutorialspoint.com/assets/profiles/640588/profile/60_610176-1681714605.jpg)
Namita Aggarwal
153 Views
Excel is a famous spreadsheet-based tool, used to manipulate and process the available data. For this provided scenario, user need to evaluate the prime number between the two provided numbers. This tutorial includes two examples, first example is based on the user define formula. For this example, user need to ... Read More
![Namita Aggarwal](https://www.tutorialspoint.com/assets/profiles/640588/profile/60_610176-1681714605.jpg)
Namita Aggarwal
5K+ Views
In this article, the user will learn the process of sorting rows by matching the data with another column. Sorting rows to match the content of another column in Excel can be a powerful technique whenever a user needs to organize and align data efficiently. Whether the user has a ... Read More
![Namita Aggarwal](https://www.tutorialspoint.com/assets/profiles/640588/profile/60_610176-1681714605.jpg)
Namita Aggarwal
533 Views
Sorting IP addresses from low to high in Excel can be useful for the below-provided reasons: It is useful to identify the network ranges. It allows the identification of the contiguous network ranges. It helps in detecting duplicate ... Read More
![Namita Aggarwal](https://www.tutorialspoint.com/assets/profiles/640588/profile/60_610176-1681714605.jpg)
Namita Aggarwal
2K+ Views
Identifying the expired or upcoming dates can be useful for cases such as understanding the project’s last date, the last date for some important activities, and many others. In the food and medicine industry expiration dates are important as companies need to dispose of their products according to the date ... Read More
![Namita Aggarwal](https://www.tutorialspoint.com/assets/profiles/640588/profile/60_610176-1681714605.jpg)
Namita Aggarwal
6K+ Views
This article illustrates the proper way to identify that the provided string is an uppercase, lower, or proper case. To do so simply use three formulas: upper(), lower(), and proper(). To understand more thoroughly consider the below provided explanation more precisely. This article describes three examples, here each example illustrates ... Read More
![Namita Aggarwal](https://www.tutorialspoint.com/assets/profiles/640588/profile/60_610176-1681714605.jpg)
Namita Aggarwal
2K+ Views
Sometimes Excel contains data with missing numbers which creates difficulty and inconsistency in the data. Two methods are described in this article to obtain the missing series of numbers. After identification of the missing series, users may fill the gap by using the Autofill method or by utilizing the VBA ... Read More
![Namita Aggarwal](https://www.tutorialspoint.com/assets/profiles/640588/profile/60_610176-1681714605.jpg)
Namita Aggarwal
147 Views
In this article, users will understand how to identify and select all merger cells in Excel. This article contains three examples, first example is based on the process of using the VBA code, the second process allows user the to find and select a method, and finally, the third option ... Read More
![Namita Aggarwal](https://www.tutorialspoint.com/assets/profiles/640588/profile/60_610176-1681714605.jpg)
Namita Aggarwal
79 Views
Locking a cell is important. It allows the user to preserve the integrity of certain cells that contain important formulas, data, or formatting. On the other hand, when a cell is unlocked, it means that it can be edited even when the worksheet is locked. This is typically done for ... Read More