സ്ത്രീകള്‍ എങ്ങിനെ വസ്ത്രം ധരിക്കണം എന്ന് പുരുഷന്‍ നിഷ്ക്കര്‍ഷിക്കുന്നത് ശരിയോ? അല്ലെങ്കില്‍ തിരിച്ചും?

Showing posts with label General Knowledge. Show all posts
Showing posts with label General Knowledge. Show all posts

Wednesday, November 11, 2015

25 Tricky Questions Asked In Microsoft Interviews



Software giant Microsoft is one of the most-sought after tech workplace in the world. But in order to get a job there, you'll have to answer some tricky questions first.

We've compiled some of the toughest Microsoft interview questions available on Glassdoor. Whether you're looking for a programming job or a position doing marketing, Microsoft's interview questions will surely stump you.


Summer intern candidate

“Devise a way to make sure there is always milk in my fridge.”


User Experience Design candidate

“Show us an example with a website with great design.”


Software Development Engineer candidate

“How would you determine if a deck of cards is well or poorly shuffled?”


Senior Business Development Manager candidate

“Why would you not join Google?"


Software Engineer candidate

“Write a program to simulate the writing of a ransom note given a magazine from which letters can be extracted.”


Senior Business Planner candidate

“What did you think about Microsoft's decision to launch Office products on the iPhone?”


Software Development Engineer candidate

"Why are manholes round?”


Program manager candidate

“How do you design a shuttle system to use within the Microsoft campus?"


Software Development Engineer candidate

“The infamous "clock hands" question — how many times do the hour and minute hands of a clock overlap in a 24 hour period?


Senior Consultant candidate

"Situational based: Your sales rep has messed up a sales quote with a long time customer, how will you use your influence to turn things around?"


Customer service advisor candidate

“How would you solve slow start up issues on a laptop/computer?”


Software Engineer candidate

"Explain recursion to a 5-year-old kid."


Program Manager candidate

“Tell me how you would design an airport”


Software Development Engineer candidate

"Given the time, how do you determine the angle between the hour and minute handle of the clock?"


Executive Business Administrator candidate

“How do you form relationships with team members who work out of state or the country?”


Product Manager candidate

“Design a GPS for a 16 year old.”


Senior Program Manager candidate

“Describe a difficult co-worker relationship.”


Software Development Engineer candidate

“Build a list of all words in a novel as well as a count of duplicate words”


Technical Account Manager candidate

“If you were in an elevator with the CEO of a company how would you explain the cloud in 90 seconds?”


Site Manager candidate

“If you were standing in a crowd of people, how would you stand out?”


Mechanical Design Engineer candidate

“Your device has a stylus. How do you store it? How do you charge it? What kind of things can you use it for?”


Design Researcher candidate

“Design the research plan for a brand new wearable product.”


High Level Product Lead candidate

“If you had a choice between two superpowers (being invisible, or flying) which would you choose?”


Program Manager candidate

“The most unexpected questioning was from a female manager who wanted my specific experiences with sexism and misogyny in the workplace. She asked me many variations along this line of questioning.”


Support Engineer candidate

“How would you guide your grandmother if her PC wasn't working?”

Top 25 Microsoft Excel Interview Questions



http://sapost.blogspot.in/

1)  What is Microsoft Excel?
Microsoft excel is an electronic worksheet developed by Microsoft, to be used for organizing, storing and manipulating.
2) What is ribbon?
The ribbon runs on the top of the application and is the replacement for the toolbars and menus.  The ribbons have various tabs on the top, and each tab has its own group of commands.
3) How can I hide or show the ribbon?
Use the  CTRL and  F1 key to toggle &  show or hide the ribbon.
4) How can you wrap the text within a cell?
You have to select the text you want to wrap, and then click wrap text from the home tab and you can wrap the text within a cell.
5) Is it possible to prevent someone from copying the cell from your worksheet?
Yes, it is possible. In order to protect your worksheet from getting copied, you need to go into Menu bar >Review > Protect sheet > Password.  By
entering password, you can secure your worksheet from getting copied by others.
6) How you can sum up the Rows and Column number quickly in the excel sheet?
By using SUM function you can get the total sum of the rows and columns, in an excel worksheet.
7) How you can add a new excel worksheet?
To add a new Excel worksheet you have to insert worksheet tab at the bottom of the screen.
8) How you can resize the column?
To resize the column you have to change the width of one column and then drag the boundary on the right side of the column heading till the width you want.  The other way of doing it is to select the Format from the home tab, and in Format you have to select AUTOFIT COLUMN WIDTH under cell section. On clicking on this the cell size will get formatted.
9) What are three report formats that are available in Excel?
  • Compact
  • Report
  •  Tabular
10) How would you provide a Dynamic range in “Data Source” of Pivot Tables?
To provide a dynamic range in “Data Source” of Pivot tables, first create a named range using offset function and base the pivot table using a named range created in the first step.
11) Is it possible to make Pivot table using multiple sources of data?
If the multiple sources are different worksheets, from same workbook, then it is possible to make Pivot table using multiple sources of data.
12) Which event do you use to check whether the Pivot Table is modified or not?
To check whether the pivot table is modified or not we use “PivotTableUpdate” in worksheet containing the pivot table.
13) What you could do to stop the pivot table from loosing the column width upon refreshing?
Format loss in pivot table can be stopped simply by changing the pivot table options.  Under the “Pivot Table Options” turn on the “Enable Preserve Formatting” and disable “ Auto Format” option.
14) What is IF function in excel?
To perform the logic test IF function is performed. It checks whether certain conditions is true or false. If the condition is true then it will give result accordingly if the condition is false then the result or out-put will be different.
Example: For example, you select the cell and you want to display that cell as “Greater than five”, when value is true (=5 or 5) and “less than five” when value is false( <5 ). For that by using IF condition you can display result.
=IF (Logical test, value if true, value if false)
=IF (A1>5, “Greater than five, “Less than five”)
15) What does a red triangle at the top right of a cell indicates?
A red triangle in the cell indicates the comment associated with the cell.  If you place mouse on it, it will show the comment.
16) To move to the previous worksheet and to next sheet, what keys will you press?
 To move to the previous worksheet you will use the keys Ctrl+PgUp, and to move to the next sheet you will use keys Ctrl+PgDown.
17) What filter will you use, if you want more than two conditions or if you want to analyse the list using database function?
You will use Advanced Criteria Filter, to analyse the list or if more than two conditions should be tested.
18) What is the quick way to return to a specific area of a worksheet?
The quick way to return to a specific area of worksheet is by using name box.  You can type the cell address or range name in name box to return to a specific area of a worksheet.
19) What is the benefit of using formula in excel sheet?
Calculating the numbers in excel sheet, not only help you to give the final ‘sum up’ of the number but, it also calculate automatically the number replaced by another number or digit.  Through excel sheet, the complex calculations becomes easy like payroll deduction or averaging the student’s result.
20) What is the “What If” condition in excel formulas?
The “What If” condition is used to change the data in Microsoft excel formulas to give different answers.
Example: You are buying a new car and want to calculate the exact amount of tax that will be levied on it then you can use the “What If” function.  For instance there is three cells A4,B4 and C4. First cell says about the amount, second cell will tell about the percentage (7.5%)  of tax and final cell will calculate the exact amount of tax.
21) How you can disable the automating sorting in pivot tables?
To disable the automating sorting in pivot tables,
Go to >  “More Sort Options”> Right Click  “Pivot table” > Select “Sort” menu > Select  “ More Options” >  Deselect the “ Sort automatically when the report is created”.
22) What is the AND function does in excel?
Like IF function, AND function also does the logical function. To check whether the output will be true or false the AND function will evaluate at least one mathematical expression located in another cell in the spreadsheet. If you want to see the final result or output of more than one cells in single cell it is possible by using AND function.
Example: If you have two cells, A1 and A2, and the value you put in those two cells are >5 and you want result should display as ‘TRUE’ in cell B1 if value>5,   and ‘False’ if any of those values<5. You can use AND function to do that.
23) How cell reference is useful in the calculation?
In order to avoid writing the data again and again forcalculating purpose, cell reference is used. When you write any formula, for specific function, you need to direct excel the specific location of that data. This location is referred as, cell reference. So, every time a new value added to the cell, the cell will calculate according to the reference cell formula.
24) What is the sequence of operating mathematical operation in Excel?
The order of sequence of operating is BEDMAS
  • Brackets
  • Exponents
  • Division
  • Multiplication
  • Addition
  • Subtraction
25) What does a LOOK UP function searches in the MS Excel?
In Microsoft excel, the LOOKUP function returns a value from a range or from an array.

Wednesday, April 15, 2015

Area calculation and Measurement Chart .


Area calculation and Measurement Chart .

1 hectare = 2 acre 47 cent
1 hectare = 10,000 sq.m.
1 acre = 0.405 hectare
1 acre = 4046.82 sq.m.
1 acre = 43,560 sq.ft.
1 acre = 100 cent = 4840 sq.gejam
1 cent = 435.6 sq.ft.
1 cent = 40.5 sq.m
1 ground = 222.96 sq.m. = 5.5 cent
1 ground = 2400 sq.ft.
1 Veesam = 6*6 sq ft = 36 sq.ft.
1 Kuzhi = 4 Veesams
1 Kuzhi = 12×12 sqfts
1 Kuzhi = 0.331 cents
1 Kāni = 400 kuzhis
1 acre = 436 kuzhi
1 ankanam = 8 Sq. yard/72 Sq. Feet
1 Mā = 100 kuzhi = 10000 sq.ft. (Not 10000 sq.ft. but 14400 sq.ft When 1 Kuzhi = 144 sq.ft)
1 Kāni = 4 Mā = 40000 sq.ft. (Not 40000 sq.ft. but 57600 sq.ft)
1 kāni = 132 cents = 1.32 acre
1 acre = 75.625 kuzhi
1 Veļi = 7 kāni = 6.43 acres = 2.6 hectares ( 1 Veli = 20 Ma = 5 kani only not 7 kani)
1 dismil =2.5 cent
1 furlong = 660 feet = 220 kejam
1 kilometre = 5 furlong
1 link / chain = 0.66 foot = 7.92 inch
1 kejam = 9.075 sq.ft.
1 mile = 8 furlong
1 ares = 1076 sq.ft. = 2.47 cent
1 chain = 22 kejam
1 furlong = 10 chain
1 kejam = 0.9144 metre
1 township = 36 sq.mile
1 sq.mile = 640 acre
1 cent = 48.4 sq.kejam
Share this article :

Monday, December 15, 2014

Union Ministers and their Constituencies as on 14/12/2014 - PDF Download


Friends.. In the recent Bank Exams it is seen that one question related to Union Ministers and their Constituencies is being asked. Hence in this post we are bringing you the list of important Union Cabinet Ministers, their Portfolios and their constituencies. You can download this post as PDF from the print friendly button below. Hope this help you.
1) Narendra Modi- Prime Minister - (Constituency: Varanasi, Uttar Pradesh)
2) Shri Rajnath Singh -Minister of Home Affairs -(Constituency : Lucknow, Uttar Pradesh)
3) Smt. Sushma Swarajy - Minister of External Affairs, Overseas Indian Affairs - (Constituency: Vidisha , Madhya Pradesh)
4) Shri Arun Jaitley - Minister of Corporate Affairs, Finance -(Gujarat Rajya Sabha)
5) Shri M. Venkaiah Naidu- Minister of Urban Development, Housing and Urban Poverty Alleviation, Parliamentary Affairs - (Karnataka Rajya Sabha)
6) Shri Nitin Gadkari - Minister for Road Transport and Highways, Shipping - (Constituency: Nagpur, Maharashtra)
7) Shri D V Sadananda Gowda - Law & Justice - (Constituency: Bangalore North, Karnataka)
8) Sushri Uma Bharati - Minister for Water Resources, River Development and Ganga Rejuvenation - (Constituency: Jhansi, Uttar Pradesh)
9) Dr. Najma A. Heptulla - Minister of Minority Affairs - (Madhya Pradesh- Rajya Sabha)
10) Shri Ram Vilas Paswan - Minister of Consumer Affairs, Food and Public Distribution - (Constituency: Hajipuri, Bihar)
11) Shri Kalraj Mishra - Minister of Micro, Small and Medium Enterprises- (Constituency: Deoria, Uttar Pradesh)
12) Smt. Maneka Gandhi - Minister of Women and Child Development - (Constituency: Pilibhit , Uttar Pradesh)
13) Shri Ananth Kumar - Minister of Chemicals and Fertilizers- (Constituency : Bangalore South, Karnataka)
14) Shri Ravi Shankar Prasad - Minister of Communications & Information Technology- (Constituency: Bihar - Rajya Sabha)
15) Shri Ashok Gajapathi Raju Pusapati - Minister of Civil Aviation - (Constituency: Vizianagaram , Andhra Pradesh)
16) Smt. Harsimrat Kaur Badal - Minister of Food Processing Industries - (Constituency: Bathinda , Punjab)
17) Shri Anant Gangaram Geete - Minister of Heavy Industries and Public Enterprises - (Constituency: Raigad , Maharashtra)
18) Shri Jual Oram - Minister of Tribal Affairs- (Constituency: Sundargarh, Odisha)
19) Shri Radha Mohan Singh - Minister of Agriculture - (Constituency: Purvi Champaran , Bihar)
20) Shri Thaawar Chand Gehlot - Minister of Social Justice and Empowerment - (Madhya Pradesh, Rajya Sabha)
21) Smt. Smriti Zubin Irani - Minister of Human Resource Development - (Gujarat, Rajya Sabha)
22) Shri. Manohar Parrikar - Minister of Defence - (Uttar Pradesh, Rajya Sabha)
23) Shri Suresh Prabhu - Minister of Railways - (Haryana, Rajya Sabha)
24) Shri Jagat Prakash Nadda - Minister of Health & Family Welfare - (Himachal Pradesh, Rajya Sabha)
25) Shri Narendra Singh Tomar - Minister of Mines, Steel - (Constituency: Gwalior, Madhya Pradesh)

Sunday, November 16, 2014

Important Portals and their Founders

Important Portals and their Founders


1. Google— Larry Page & Sergey Brin

2. Facebook— Mark Zuckerberg

3. Yahoo— David Filo & Jerry Yang

4. Twitter— Jack Dorsey & Dick Costolo

5. Internet— Tim Berners Lee

6. Linkdin— Reid Hoffman, Allen Blue& Koonstantin Guericke

7. Email— Shiva Ayyadurai

8. Gtalk— Richard Wah kan

9. Whatsup— Brian Acton and Jan Koum

10. Hotmail— Sabeer Bhatia

11. Orkut— Buyukkokten

12. Wikipedia— Jimmy Wales

13. You tube— Steve Chen, Chad Hurley & JawedKarim

14. Rediffmail— Ajit Balakrishnan

15. Nimbuzz— Martin Smink & Evert Jaap Lugt

16. Myspace— Chris Dewolfe & Tom Anderson

17. Ibibo— Ashish Kashyap

18. OLX— Alec Oxenford & Fabrice Grinda

19. Skype— Niklas Zennstrom,JanusFriis & Reid Hoffman

20. Opera— Jon Stephenson von Tetzchner & Geir lvarsoy

21. Mozilla Firefox— Dave Hyatt & Blake Ross

22. Blogger— Evan Willam
s

Wednesday, November 12, 2014

Latest updated list of new Union Ministers and their Portfolios as on 10.11/2014 - PDF Download


Prime Minister Narendra Modi expanded his team on 09 November 2014 (Sunday) by appointing 21 new ministers, four of them in the Cabinet and three others as ministers of state with independent charge. Manohar Parrikar, Suresh Prabhu, J P Nadda and Birendra Singh have been inducted into the Cabinet, while health minister Harsh Vardhan and railway minister Sadanand Gowda have been replaced and given lesser portfolios. Here is the complete updated list of ministers and their portfolios.

1.
Shri Narendra Modi
Prime Minister
Personnel, Public Grievances and Pensions; Department of Atomic EnergyDepartment of Space; All important policy issues and all other portfolios not allocated to any Minister
CABINET MINISTERS

1.
Shri Raj Nath Singh
Home Affairs
2.
Smt. Sushma Swaraj
External Affairs
Overseas Indian Affairs
3.
Shri Arun Jaitley
Finance, Corporate Affairs, Information & Broadcasting
4.
Shri M. Venkaiah Naidu
Urban Development, Housing and Urban Poverty Alleviation, Parliamentary Affairs
5.
Shri Nitin Jairam Gadkari
Road Transport and Highways, Shipping
6.
Shri Manohar Parrikar
Defence
7.
Shri Suresh Prabhu
Railways
8.
Shri D.V. Sadananda Gowda
Law & Justice
9.
Sushri Uma Bharati
Water Resources, River Development and Ganga Rejuvenation
10.
Dr. Najma A. Heptulla
Minority Affairs
11.
Shri Ramvilas Paswan
Consumer Affairs, Food and Public Distribution
12.
Shri Kalraj Mishra
Micro, Small and Medium Enterprises
13.
Smt. Maneka Sanjay Gandhi
Women and Child Development
14.
Shri Ananthkumar
Chemicals and Fertilizers
15.
Shri Ravi Shankar Prasad
Communications and Information Technology
16.
Shri Jagat Prakash Nadda
Health & Family Welfare
17.
Shri Ashok Gajapathi Raju Pusapati
Civil Aviation
18.
Shri Anant Geete
Heavy Industries and Public Enterprises
19.
Smt. Harsimrat Kaur Badal
Food Processing Industries
20.
Shri Narendra Singh Tomar
Mines, Steel
21.
Shri Chaudhary Birender Singh
Rural Development, Panchayati Raj, Drinking Water and Sanitation
22.
Shri Jual Oram
Tribal Affairs
23.
Shri Radha Mohan Singh
Agriculture
24.
Shri Thaawar Chand Gehlot
Social Justice and Empowerment
25.
Smt. Smriti Zubin Irani
Human Resource Development
26.
Dr. Harsh Vardhan
Science and Technology, Earth Sciences
Check out the list of Ministers of State with Independent charge and Ministers of State from the below link.

Download full list as PDF: Click Here