What is the use of the sorting feature in Excel?

Asked by Last Modified  

1 Answer

+1

Follow 1
Answer

Please enter your answer

Sorting in Excel is similar to sorting in real life. For example, if we want to sort a bunch of 100 marbles in a bag(considering the bag is opaque), on the basis of their colour, then it is quite impossible. But, if we drop the marbles on the ground and sort them based on their colour, then it would...
read more
Sorting in Excel is similar to sorting in real life. For example, if we want to sort a bunch of 100 marbles in a bag(considering the bag is opaque), on the basis of their colour, then it is quite impossible. But, if we drop the marbles on the ground and sort them based on their colour, then it would be easy. In the same way, we can sort the data by grouping them into similar categories. Sorting allows you to rearrange the list of data in a convenient fashion. For instance, if you're using a spreadsheet to maintain all the employee database, and you have to sort them in alphabetical order, you might choose to sort it alphabetically in order to be able to find an employee's phone number quickly. The Sort and Filter button will give you a number of different choices for sorting, based on the information you're tracking the selected cell. read less
Comments
Dislike Bookmark

Related Questions

How do I rename a worksheet in MS Excel?
Double click the worksheet name, then replace the existing name with a new name and press the enter key
Dhanshri
1 0
7
Are there any excel and VBA coaching centres at As Rao Nagar?
nope
V
How to write macros in excel?
1) you record a macro 2) macro programming:- macro is type of a sub procedure to perform some task. sub is a keyword. the set of program statements you have to write between the two lines syntax:- sub macroname statements ----------- end sub
Vidyarajeev
Can you make a Software Base On Excel, that records Automatic Billing Information Just Like A POS System. Suppose our Customer requires following: An Excel Software for POS, with following functionalities: It should have an "Open List" for capturing product related information. It should have automatic bill numbering It should have Printable bill It should have a customer database form and recording It should take not more than 30 minutes of training to learn and operate Can you make that? How much time will it take to you to make it completely?
Maybe yes! I'll require a bit more information to deep dive in it.
Bikram Jeet
0 0
9
Hi All, My question is how to define age calculation in excel by formula?
Enter DOB in one cell. For example in Cell A1. Then in the cell where you want to calculate Age there write as =(TODAY()-A1)/365.25 .25 has been added to the 365 because to accommodate the leap year days in between.
BINAYAK

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

Learning Tip
1. The foundation: a productivity systemLet’s face it, without a solid foundation there is no way you can expect to build new skills and form new habits. My first tip therefore is to adopt a productivity...

Pankaj Kumar Jha

0 0
0
Advanced Excel - Excel What-If Analysis Goal Seek !

Amey Vidvans

0 0
0
VBA Tip: Repeating Emp Names N number of times using 4 different loops
Hi All,This is a requirement from one of our student and here we are posting the question along with solution (this can be achieved using 4 different loops). In Column “J” there are few employee...

Naga Satyanarayana Anantapalli

2 0
0
What is Baseline and what is the use of baseline in MSP (Microsoft Project)
What is baseline - The baseline in MSP (Microsoft project) management refers to the first version of the schduled project (after approval on draft version) timelines (duration), cost, resource and scope....

Vikas Chauhan

0 0
0
Early Binding vs Late Binding
Binding is a process of matching function calls written by the programmer to the actual code (internal or external) that implements the function. All functions called in code must be bound before the code...

Umasankar Natarajan

0 0
0

Recommended Articles

Learn Microsoft Excel

Microsoft Excel is an electronic spreadsheet tool which is commonly used for financial and statistical data processing. It has been developed by Microsoft and forms a major component of the widely used Microsoft Office. From individual users to the top IT companies, Excel is used worldwide. Excel is one of the most important...

Read full article >

Top 5 Skills Every Software Developer Must have

Software Development has been one of the most popular career trends since years. The reason behind this is the fact that software are being used almost everywhere today.  In all of our lives, from the morning’s alarm clock to the coffee maker, car, mobile phone, computer, ATM and in almost everything we use in our daily...

Read full article >

Why Should you Become an IT Consultant

Information technology consultancy or Information technology consulting is a specialized field in which one can set their focus on providing advisory services to business firms on finding ways to use innovations in information technology to further their business and meet the objectives of the business. Not only does...

Read full article >

Make a Career in Mobile Application Programming

Almost all of us, inside the pocket, bag or on the table have a mobile phone, out of which 90% of us have a smartphone. The technology is advancing rapidly. When it comes to mobile phones, people today want much more than just making phone calls and playing games on the go. People now want instant access to all their business...

Read full article >

Find MS Office Software Training near you
MS Office Software Training in Delhi
MS Office Software Training in Hyderabad
MS Office Software Training in Mumbai
MS Office Software Training in Bangalore
MS Office Software Training in Chennai
MS Office Software Training in Pune
MS Office Software Training in Kolkata
MS Office Software Training in Ahmedabad
MS Office Software Training in Gurgaon
MS Office Software Training in Jaipur

Looking for MS Office Software Training ?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you