Parts of Bow

Parts of violin

How to add Google Search Engine to Blogger Blog

What is Google Custom Search Engine (CSE) 
Google provides its own custom search engine which helps users or visitors to search and find the contents of Blog or website.

How to add CSE in Blogger?

here are steps to set up Google custom search engine in Blogger

Step-1

Login into Google Account, Type 'Google Custom Search Engine' in Google search and select the results 

Select the  result  as shown in figure below

Step-2

Select 'New search engine' from left hand side 

Step-3

Continue in filling your Blog name and other entries

 Step-4

Customize the appearance, color and other theme options of your search engine.

Step-5

Get copy of code of Google custom search engine and login into Blogger, Switch to Layout option as shown below

Step-6

 Choose add gadget, 

 select HTML/JAVA from list

.

 Paste copied code and click on save button. Your Google Custom Search Engine is ready 

TIME AND WORK

2) A takes 10 days to complete a work. B takes 15 days to complete the same work. How many days need to complete the same work by A and B together ?

Trick :  (Let x be the Unknown Value)
A = 10 =  T1
B =  x = T2

A + B = T1 X T2 / T1 + T2 = 6
6 = 10 X x / 10 + x ; 6 (10 + x) = 10x
60 + 6x  =  10x ; 60 = 10x – 6x
60 = 4x  ; x = 60/4 = 15 Days

 

3) A takes 10 days to complete a work. B takes 15 days to complete the same work. How many days need to complete the same work by A and B together ?

Trick :
A = 10 = T1

B = 15 = T2

A + B = T1 X T2 / T1 + T2
= 10 X 15 / 10 +15
= 6 Days

TIME AND WORK

1) 5 People take 8 days to finish a work. How many days need finish the same work by 4 people?
in Trick :
People         Days
5        -        8
4        -        x
X = 5 X 8 / 4  =  10 Days

2) 10 people take 15 days to finish a work. How any days need to finish the same work by 6 people?
People         Days
10      -        15
6        -        x
X = 10 X 15 / 6  =  25 Days
 

HOW TO SUM OF ALL ODD NUMBERS

Trick : just follow the rule that n X n = result, square the quantity of numbers in the series.

Example: 1) Calculate the sum of all ODD numbers in the group 1 to 90

Count the total ODD numbers in 1 to 90, i.e = 45
Multiply 45 X 45 = 2025

So the sum of all ODD numbers in the group 1 to 90 is  2025

Example: 2) Find the sum of all ODD numbers in the group 1 to 30

Count the total ODD numbers in 1 to 30, i.e = 15
Multiply 15 X 15 = 225

So the sum of all ODD numbers in the group 1 to 30 is  225

HOW TO ADDING CONSECUTIVE NUMBERS

Trick : First multiply the sum of given numbers then divide that number by two
Formula : [(N₁+N₂) X N₂] / 2

Example: 1) Sum of all consecutive numbers from 1 to 50
Calculate total number of integers in the series. In this example it is 50.
Multiply total count with count +1  i.e 50+1=51
50 X 51 = 2550
Divide the result by 2 i.e : 2550 / 2 = 1275
The sum of all consecutive numbers starting from 1 to 50 is 1275
Example: 2) Sum of all consecutive numbers from 1 to 71
71+1=72, 71 X 72 = 5112, 5112 / 2 = 2556

-----------------------------------------------------------------------------------

Trick : Do summation of Smallest and Largest Numbers of given series, then multiply the result with total numbers of series, then divide result by 2
Formula : [(N₁+N₂) X n₂] / 2

Example: Find the Sum of all consecutive numbers from 23 to 29
Smallest no N1 = 23, Largest no N2= 29
Total numbers of series = 7
Add largest and smallest numbers of given series I,e 23+29 = 52
Multiply the result with the total numbers of series i.e 52 X 7 = 364
Divide the result by 2 i.e 364 / 2 = 182
The sum of all consecutive number from 23  to 29  is 182

-----------------------------------------------------------------------------------

How to calculate the values of table in Word

Its easy to calculate the sum of two cells in excel. But how about word? MS word has a special feature to calculate the sum f two cells in a table

Almost we use table for entry of numbers and other calculations in MS Word software.

Here I have taken an example of some persons salary and incentive. I need to take sum of two cells i.e salary and incentive to Total payable column.

Here is how to calculate or sum the values of two cells of a table in word

Place Cursor in Total Payable column

Then go to Layout Menu à  select Formula option as shown in figure.

Select the formula and check in dialog box should be like [=SUM(LEFT)] to add left columns values.

And [=SUM(ABOVE)] to add above rows values.

You need not to do for each row / columns . once just press crtl+y for repeat same for more times.

Your Calculated Table is ready 

Google Custom search engine

Merge Cells without losing data in Excel (Concatenate)

Merging Cells or Adding two columns data in single column without losing data in Excel. Merging of of tow or more cells data in a single cell is called CONCATENATE in Excel

Let take an example i have prepared a data sheet like address of person like Mr, Mrs etc and Name of person. I need to merge data of two columns in a single column. 

Here i have taken this data. I need to merge Column 1 and Column 2 into Column 3. 

The formula for merging cells without losing data is 

=CONCATENATE(CN, CN, CN) [where CN is reffers Cell number such as A2, B2 etc,.]

After entering formula followed by is equal to (=) press enter key. the cell will be filled by the data of two cells in a single cell. then copy and paste same formula for other cells also 

Then Your Merged Content into a single cell will be ready like this 

Google Drive is The Versatile Cloud Service.

Google Drive is a cloud based versatile storage service by Google launched on 24-04-2012. It allows user to store and access files online and also offline. We can store all type of file formats like Office files, videos, images, PDF files and all other format files. Google Drive allows users to create New Folders to organize Files and data. 

How to get into Google Drive?

All Google account holder can sign in into Google Drive. It is Free of cost and comes with 15 GB of space. To own Google Drive Google Account is Compulsory. 

Click here to create your Google Account

Click here to sign in Google Drive 

Google Docs, Slides and Sheets

Google Drive allows users to edit online such as Microsoft word or any Documents and Power Point Presentation Slide shows and Excel sheets for calculation. Google drive allows users view and edit files offline also.

Know more about how to make a power point presentation 

Google drive available in Desktop, Web and Mobile App

 User can download Desktop app to connect Desktop computer folders and files to sync into Google Drive. Google Drive available for Windows and for Mac OS also.   The best way is adding Google Drive extension to Chrome. Usually most of the users were using web access initially but now Google drive available in app store. By installing mobile app we can store mobile data online and ease to sync and access.

Click here to get Google Drive Mobile app

Other interesting Features of Google Drive are

• Google Drive has a folder called Recent. It stores the recent activity of user and user can continue where he/she left!

• Google Drive allows users can store Layer of Google Map!

Click here to locate your home on Google Map

• Google Drive allows Files and Folder Sharing. User can share files with other users and can customize restrictions to the shared files through Google Drive!

• User can give different color and stars to folder according to priority

• Google Drive is a best tool for Google Forms. User can make Google Form by using Drive Storage and All the reply of Google form stores in spread sheet format which is easy to download in excel format. 

 Know more how to create Google Form and Launch?

• By sharing Docs and Sheets of Drive, we can monitor and manage other to add data and edit gently!

• Google Drive supports all types of files. All types of files open in Google Drive!

• Drive Tunes is a best feature of Google drive which we can arrange all our music files!

• We can get sharable link of drive files easily and the length of link will be in very short and sweet!

• It allows embed your folder to your site so that it can be seen by your visitors too!

• Backup photos files and all type of data easily!

• Google Drive deals with large files too!

Know more about Google Drive with Illustration

Learn HTML and JAVA by Your Own

Learn HTML and Java by Yourself

using this website. its cool and very interesting. you can learn coding in hyper text markup language and also in Java. this web helps you learn own the coding languages like C++, HTML and java.




https://www.sololearn.com is a free learning website helps learning C++, HTML and JAVA and also Python

some interesting codes and programs are loaded that user can copy and paste in their own pages.

you need to just click on run menu to run the code or program

It helps in college projects for which students are in same platform

Sample codes

Know your accurate age

Birthday Gifts

and more codes

Advanced Image Search in Google

Taking Copyright free images from google image search 


go to google search type the image name in search 

here i am taking nature images for example. 


copyright images are not free for and even commercially so go to settings option appears just below google search 



in settings menu select advance search option as shown below 

then select option from usage rights select 'free to use or share, even commercially'

its easy to share free and upload free so why don't you try !!!

The best search engine of web world

Google is the best search engine in the world 

you can search images, maps, videos, news and all things to do 
having better calender feature supports local geo.

www.google.com

Using Mail Merge in Excel

Easy way using Mail Merge in Excel

Why mail merge ?
Mail merge is used to send same letter or information for different persons at a time
Mail merge is very useful and time saving for Excel users 

Here are the steps how to use Mail merge

i am using a data sheet to illustrate the mail merge process in excel 

above data sheet has the name address, cheque number amount and contact number etc,.

if your data is ready then easy to mail merge 

go to micro soft word program to do mail merge in the sense of making letter to different persons at a time. for the mail merge you have to maintain both excel and word files should be in same folders like this.

After ready of excel file start word file. then write letter. i have shown an example below

while typing letter use blank for address name and other factors which is ready in excel file.then go to mail merge option

select step by step mail merge wizard option shown in figure below

the wizard dialog box asks you to choose excel file from brows windows. then select the excel file from the same directory as before we stored by typing data. select sheets having data to mail merge .

then confirm the data and select ok from dialog box

then put cursor on the space given while typing letter then go to the insert field option 

then complete the insert field and then click the preview button 

you can confirm the fields are correct in preview option. then go to print option in right panel of mail merge option shown in figure below. 

print using giving range shown in figure below 

the mail merge is ready 

About Gmail

     Gmail of Google mail launched on 01-04-2004 by the remarkable programmer called Paul Buchheit but Gmail became public available on 07-02-2007. The secret behind its user friendly secret is Ajax. Ajaxz is web development technique. Gmail has 15 GB cloud storage capacity and its free of cost. Gmail became the first mobile app on Google Play store to hit 1 billion installations on Android devices. Gmail or Google Mail completes 13 years of service. Since its inception, Gmail has captured most of the world's email network and monopolized the industry. Its rivals are no way near to its popularity as Gmail rockets towards new heights in the years to come.

Salient features of Gmail are

• Gmail is the best webmail services among all webmail services. The main thing of Gmail to popularize is the Google search engine. It’s free of cost and storage also free up to 15 GB. For Gmail Superior spam protecting technology developed by Google. Gmail interface is available in more than 35 language approx 39 languages. Free automatic forwarding, POP3 access and IMAP access but Java script and cookies must be enabled.
• Gmail offers an app called Boomerang with this feature, you can choose to have an email pop up in an hour, a day, or even at a chosen time.

·         Turn on chat or mail notifications in your settings under “Desktop Notifications”, and every time you receive an email labeled as important it will pop up on your screen no matter what you are doing!

• Gmail offers to deleted files to store in trash until we delete them from trash permanently.
• We can use more Gmail account from one browser by adding account which shown in aviator. 

 

• A star feature comes in different color to add favorite mails like friends office and etc,.
• Easy to search the mails by typing the little memorable content of mail. Easy to navigate and find the older mails.
• Easy labeling and maintaining feature of Gmail is positive point to users who knows the basic of internet.
• The services of Gmail are quite better for basic users like calendar and easy to track our notifications.

• Google’s email service is especially helpful in organizing multiple email accounts. They make it possible to connect each of your email accounts, making it simple to have separate accounts for work, personal, shopping, etc. There is also a way to alter your settings to see new emails from all, or some, of these accounts simultaneously.

•  No need of only password entry!! Gmail opens with device connected with user by more options. Easy to recover and backup.

Link for create Google account 

Direct link for create Gmail account