Wednesday 25 June 2014

General Knowledge Quiz


General Knowledge


0

Points
0
Q.1 Longest River of the world.
Nile       Indus       Amazon       Mississippi  

Tuesday 27 May 2014

ProtoType Self-Driving Car

Google has just unveils Self-Driving car without steering and break paddle.
This Prototype self driving car has two seats and theres no steering either a break paddle.
The roof has light detection and raging sensor on its top same as earlier self-driving cars.
There is a start and stop button and a screen to show routes.
It has maximum speed of 40km/h.
Google said to build 100 such cars in this summer and test them of highways and on local roads.

This will make driving more reliable and safe for all.

Tuesday 29 April 2014

Oscar Wilde



Oscar Fingal O'Flahertie Wills Wilde was born in Dublin, Ireland in 16 October 1854, he became most popular playwrights in London early 1890s.

He regularly written fairy stories for magazines he published The Happy Price and Other Tales in 1888. Then he starts longer prose which were published in major literary-intellectual journals

Wilde died on 30 Nov, 1900, initially burried Cimetiere de Bagneus outside Paris; in 1909 transferred to Pere Lachaise Cemetery inside city.






He is well known for his Poems, fairy stories,essays and dialogues, plays also he wrote a novel. some from his work is.

The Happy Prince and Other Stories

Lord Arthur Savile's Crime and Other Stories

House of Pomegranates

The Picture of Dorian Gray

The Soul of Man under Socialism

The Duchess of Padua







Monday 14 April 2014

Reset PhotoShop to its Default settings.

Sometimes during working we always customizing our work area in Adobe PhotoShop, as we customize most of things, or there are certain settings we changed.
If you want to go back to its standard settings.

Follow bellow simple procedure according to your OS.

For Windows
Before opening Photoshop
Press and hold Left (Ctrl+Alt+Shift)
then open Photoshop.

For Mac
Before opening Photoshop
Press and hold Left (command+Option+shift)

then open Photoshop.


it will prompt to delete Photoshop settings file.

Press "Yes" to proceed or "No" to stay on current settings.

Snapshot Reset PhotoShop

Tuesday 8 April 2014

Find duplicate value in excel through Countif


Find duplicate value in excel through Countif

In latest versions of MS Excel finding duplicate values is very easy by selecting desire column/ range and go to conditional formatting and select duplicate values.

But today I am going to tell you other way to find duplicate values, also it will tell you number of repetition of a value.
If value is single it will display “1” if value is repeat two times it show “2” and number will increased as repetition increased.
It performed with a very simple formula, lets demonstrate it.

Syntax of “countif” formula is

Countif(range, criteria)

Range:            range is a specific row or column/columns, which need to be check for count
Criteria:            Criteria is what to be count.


Now I am going to use same formula to find all duplicate values.

Here I have a sheet with numbers which have multiple values.

In “A2” write formula

=countif($b$2:b2,b2)
Explaination:
“b2:b2” as range and make first value absolute by adding “$” like “$b$2”.
second will not as absolute in range.
Criteria is also “b2”
By doing this it will search in range b2 to b2 and count b2 it will give one.
By copying formula in entire column it will change as
=countif($B$2:B3,B3) and so on.
It means it will search range b2 to b3 and count b3 value in range.

you can also add a simple conditional formatting for values more than one “1” will highlighted and it will ease to find duplicates.
and values greater than 1 will be highlighted red, which means value repeat in 2, 3,4 etc. times.








Tuesday 25 March 2014

Nobel Prize Holder in 2013



Subject Name
Chemistry
Martin Karplus
Michael Levitt
Arieh Warshel
Literature Alice Munro
Peace Organisation for the Prohibition of Chemical Weapons
Physics
Francois Englert
Peter W. Higgs
Physiology,
Medicine
James E. Rothman
Randy W. Schekam
Thomas C. Sudhof
Economics
Eugene Fama
Lars Peter Hansen
Robert J. Shiller