Skip to main content

ADS

How to use Microsoft Excel?

Microsoft Excel


No matter you require generating reports, compute math or you require maintain records in soft copy, Microsoft Excel is the application that serves all these needs. This application comes loaded with various features that can robust your working needs. The purpose of this article is to discuss how to use this application to its full potential.

How to use filters?

As you can make it from the name itself this function enables users to find out specific data. This function comes very effective to find out specific data while dealing with larger spreadsheets. On the excel dashboard, towards the left-hand corner, there is an icon by the same name. You need to select on any column and then click on the filter icon. It will add filter dropdown. Once the drop-down appears, you can filter the entire spreadsheet as per your criterions.

How to remove duplicate entries?

If you are dealing with larger data sets, there are chances to encounter duplicate data. Hence, you need to have solutions to these problems. Fortunately, you can accomplish this objective in few simple steps. You need to highlight the column or row that features duplicated entries. Subsequently, you need to navigate to the Data Tab and click on Remove duplicate. You will get this function under the Tools menu. Once you make your selection, a pop-up will come up and it will ask you to confirm the data that you need to remove.

How to do mathematical calculations in excel?

This application helps users to accomplish various types of mathematical calculations. You can accomplish computations like addition, multiplication, division, and subtraction. You can use brackets to ensure that specific computations get done before the others. Users can even include formulas to the excel documents that will automatically do the necessary computations.

Steps to do condition formatting

You need to start with highlighting the cells where you aspire to apply this command. Go to the Home tab and select “Conditional Formatting” command. Subsequently, you need to pick your logic. If you want to set some unique logic, you can even do that. A pop-up window comes that asks for further information on the formatting logic. Once done, select “OK” for the coveted results to appear automatically.

How to use the Format Painter in Excel?

You should be familiar as for how to format the spreadsheet cells. Well, organized excel sheet gets a high appreciation as it makes it easier to follow the data as well as to do the calculation. Following are the steps to use the format painter:

·        You need to select the cell that you wish to replicate

·   Go to the Home tab and you require clicking on Format Painter icon. The application will display a painting brush, appearing immediately after the cursor.

·   Once the painting brush appears, you require clicking for applying the entire attributes from the selected cell to the others.

You need to get familiar with the steps mentioned above to ensure that you can reap the optimal benefits from the excel application.  

Comments

Popular posts from this blog

KID S GK FOR STANDARD 2 AND 3 [PAGE NO.4]

INDIA QUIZ
SUPERLATIVES OF INDIA भारत में उत्त्कृष्ट 
1. Which is the longest bridge in India?
Ans.Bhupen Hazarika Setu

भारत में सबसे लंबा पुल कौनसा है?
उत्तर:भूपेन हज़ारिका सेतु

2. Which is the tallest minaret in India?
Ans.Fateh Burj

भारत में सबसे ऊँची ईमारत कौनसी है?
उत्तर:फतेह बुर्ज

3. Which is the biggest mosque in India?
Ans.Jama Masjid

भारत में सबसे बड़ी मस्जिद कौनसी है?
उत्तर:जामा मस्जिद

4. Which is the largest temple in India?
Ans.Srirangam

भारत में सबसे बड़ा मंदिर कौनसा है?
उत्तर:श्रीरंगम

5. Which is the largest sand desert in India?
Ans.Thar

भारत में सबसे बड़ा मरुस्थल कौनसा है?
उत्तर:थार

6. Which is the longest river in India?
Ans.Ganga

भारत में सबसे लम्बी नदी कौनसी है?
उत्तर:गंगा

7. Which city of the Uttar Pradesh has the Taj Mahal?
Ans.Agra

ताजमहल उत्तरप्रदेश के कौनसे शहर में है?
उत्तर:आगरा

8. Where is Dalhousie Hill Station located in India?
Ans.Himachal Pradesh

डलहौज़ी हिल स्टेशन भारत में कहाँ स्थित है?
उत्तर:हिमाचल प्रदेश

9. Who was the first Indian to win Gold Medal at the O…

KID S GK FOR STANDARD 2 AND 3 [PAGE NO. 6]

INDIA QUIZ WOMEN FIRSTS IN INDIA भारत में महिला सर्वप्रथम  1.First woman doctor of India? Ans.Anandi Gopal Joshi
भारत की पहली महिला चिकित्सक? उत्तर:आनंदी गोपाल जोशी 
2.First woman Merchant Navy Officer of India? Ans.Sonali Banerjee
भारत की पहली महिला मर्चेंट नेवी अफसर? उत्तर:सोनाली बनर्जी 
3.First woman teacher of India? Ans.Savitribai Phule
भारत की पहली महिला अध्यापिका? उत्तर:सावित्रीबाई फूल 
4.First woman President of India? Ans.Mrs.Pratibha Patil
भारत की पहली महिला राष्ट्रपति? उत्तर:श्रीमती प्रतिभा पाटिल 
5.First woman Prime Minister of India? Ans.Mrs.Indira Gandhi
भारत की पहली महिला प्रधानमंत्री? उत्तर:श्रीमती इंदिरा गाँधी 
6.First Indian World No.1 woman's tennis sportsperson(doubles)? Ans.Sania Mirja
'विश्व नंबर एक' पहली भारतीय महिला टेनिस खिलाडी (डबल्स में)? उत्तर:सानिया मिर्जा
7.First Indian No.1 women's badminton player? Ans.Saina Nehwal
पहली भारतीय महिला नंबर एक बैडमिंटन खिलाडी? उत्तर:साइना नेहवाल 
8.First woman Chief Minister of India? Ans.Sucheta Kriplani(Utt…
INDIA QUIZTHE FIRSTS IN INDIAभारत में सर्वप्रथम  1. Who was the first President of India?
Ans.Dr.Rajendra Prasad

भारत का पहला राष्ट्रपति कौन था?
उत्तर:डॉ राजेंद्र प्रसाद

2. Who was the first Prime Minister of India?
Ans.Pt.Jawaharlal Nehru

भारत का पहला प्रधानमंत्री कौन था?
उत्तर:पं.जवाहरलाल नेहरू

3. Who was the first Woman President of India?
Ans.Mrs.Pratibha Patil

भारत की पहली महिला राष्ट्रपति कौन थी?
उत्तर:श्रीमति प्रतिभा पाटिल

4. Who was the first woman Prime Minister of India?
Ans.Mrs.Indira Gandhi

भारत की पहली महिला प्रधानमंत्री कौन थी?
उत्तर:श्रीमति इंदिरा गाँधी

5. Who was the first Vice President of India?
Ans.Dr.S.Radhakrishanan

भारत का पहला उपराष्ट्रपति कौन था?
उत्तर:डॉ.एस.राधाकृष्णन

6. Who was the first Deputy Prime Minister of India?
Ans.Sardar Vallabh Bhai Patel

भारत का पहला उप-प्रधानमंत्री कौन था?
उत्तर:सरदार वल्लभभाई पटेल

7. Who was the first Indian Bowler to get a Hat-trick in Test Cricket?
Ans.Harbhajan Singh

टेस्ट क्रिकेट में हैट-ट्रिक पाने वाला पहला भारतीय गेंदबाज़ कौ…