ICC Cricket World Cup 2019 and India ‘s Matches in World Cup 2019

The biggest carnival of cricket, ICC World Cup 2019 has been started. All people were excited to see their favorite teams in fire. The battle has begun. This event has begun on May 30, 2019 and will end on July 14, 2019. 10 teams are participating in this big fight: England, India, South Africa, New Zealand, Australia, Pakistan, Sri Lanka, West Indies, Bangladesh and Afghanistan. There will be 48 matches in this tournament. This huge event has been hosted by England this time.

Now without delay we talk about Indian team. You all know that Indian team is in terrific and superb form. India gears up to play young brigade. Team India is considered a major claimant of World Cup 2019.  India has already won 2 matches. Both matches were neck to neck tussle with 2 champion teams. India has defeated South Africa in its first match. In second match, India beat Australia. Team India has started its winning cycle in this prominent tournament. Every team is fighting with spirit to win this prestigious and splendid award. As we often listen this slogan, ‘picture abhi baaki hai mere dost’. So the acme of entertainment and excitement is much awaited because India Vs Pakistan match will be held on June 16. Indians and Pakistanis will never lose the chance to watch this match till last ball.

We wish best for India. We wish India win World Cup 2019. The list of matches in ICC World Cup 2019 is given below:

India’s match schedule in ICC Word Cup 2019

Date: 5 June, 2019 [WEDNESDAY]

Teams: India Vs South Africa [3:00 PM India time]

Venue:  Rose Bowl, Southampton

Result:  India has defeated South Africa by 6 wickets

 

Date: 9 June, 2019 [SUNDAY]

Teams: India Vs Austraila [3:00 PM India time]

Venue:  Kennington Oval, London

Result:  India beat Australia by 36 runs

 

Date: 13 June, 2019 [THURSDAY]

Teams: India Vs New Zealand [3:00 PM India time]

Venue:  Trent Bridge, Nottingham

Result:  yet to play

 

Date: 16 June, 2019 [SUNDAY]

Teams: India Vs Pakistan [3:00 PM India time]

Venue:  Emirates Old Trafford, Manchester

Result:  yet to play

 

Date: 22 June, 2019 [SATURDAY]

Teams: India Vs Afghanistan [3:00 PM India time]

Venue:  Rose Bowl, Southampton

Result:  yet to play

 

 

Date: 27 June, 2019 [SATURDAY]

Teams: India Vs West Indies [3:00 PM India time]

Venue:  Emirates Old Trafford, Manchester

Result:  yet to play

 

Date: 30 June, 2019 [SUNDAY]

Teams: India Vs England [3:00 PM India time]

Venue:  Edgbaston, Birmingham

Result:  yet to play

 

Date: 2 July, 2019 [SUNDAY]

Teams: India Vs Bangladesh [3:00 PM India time]

Venue:  Edgbaston, Birmingham

Result:  yet to play

 

Date: 6 July, 2019 [SUNDAY]

Teams: India Vs Sri Lanka [3:00 PM India time]

Venue:  Headingley, Leeds

Result:  yet to play

 

 

 

 

 

Advertisements

MS Excel Formula List and How to Use these formula..Learn with Examples !!

With more than 30 million users, Ms Excel is famous and very usable software developed by Microsoft. The Code name of MS Excel is Odyssey. Excel is a software program from Microsoft that from Microsoft Office suite of productivity software. Released in September 1985, Microsoft Excel is software for creating and editing spreadsheets which are saved with .xls or .xlsx file extension.

MS Excel is basically used for calculation, pivot tables and other graphics representations. You can keep number record of any data. You can keep monthly budget, salary, expenses and other calculations in Excel. It is very useful software. Excel contains a spreadsheet that has columns and rows. The intersection of columns and rows make cells. We keep data in cells.  There is no restriction to keep only numeric data; you can add text data too. There is a set of formulas to ease your calculation in Excel. It is different from Ms Word. The formulas are very helpful to reduce your calculation work. You can do addition, subtraction, multiplication, division and many more functions within typing a few keys. You will enjoy most sorted browsing experience with MS Excel formulas. Sharp your math with Excel.

Today here we will share information about MS Excel formulas and MS excel shortcut keys:

 

All excel formulas begin with Equal to sign (=) and followed by specific text tag that will denote the formula.  We are sharing some formula here:

1. SUM

Sum means addition of numbers, we can feel comfortable while putting numbers in Excel. No matter what numbers of excel you fill in excel and now looking for total of those numbers. There is a formula there.  = SUM (number 1, number 2, number 3….). The solo aim of Sum is add numbers together. Sum function sums values supplied as arguments; these can be up to 255 arguments. Sum function ignores text values.

Example

 

You can add cell number here too. Even you can add range of cells too. Here you can see sum of cell range.

Example

 

 

2. Average 

Average function in Excel does exactly as its name shows. Average function is used to find average or arithmetic mean of numbers. This work like Sum formula. You can find average of multiple numbers.
=AVERAGE(number1, [number2], …)

Example

Let’s have an example of the formula in Excel software

 

 

3. MAX and MIN 

The MAX and MIN formulas in Excel are used to find the largest and smallest number in a set of numbers, respectively. The use of this formula is very easy.

= MAX (number1, [number2], …)

=Min (number1, [number2], …)

Example

Let’s learn with an example given below:

 

 

4. COUNT & COUNTA

If you have curiosity to find the cells in a given range contain numeric values, you can save your time by using COUNT function. This will count all instantly as you apply the formula.

=COUNT(value1, [value2], …)
In COUNTA function, we can find all cells that are not blank, even they have contained numbers, letters, errors, text, dates, times, values, logical values (True/False), text strings etc.
=COUNTA (value1, [value2], …)

Example

Let’s apply both formula, watch following example please.

 

5. LEN

You often need a perfect formula to count the number of characters in a cell. Yes, LEN is suitable for you needs. You can easily count number of characters in a cell through using it.
=LEN(text)
=LEN (cell no.)

Example

Examples in Excel sheet given below:

 

6. TRIM

TRIM is extremely useful formula in Excel. You can remove extra spaces in text with it. You can get rid of unwanted spaces in text with TRIM formula. There may be multiple methods to avoid extra spaces but you will find TRIM formula, a cool one.
=TRIM(text)

Example

 

7. IF Formula

When we face ‘IF’ anywhere, we suddenly think about logic. It is very popular formula in Excel. It is used to test a specific condition and return a value or do a calculation if condition is met, and if the condition is not met, another value or calculation.
IF(logical_test, [value_if_true], [value_if_false])

Example

For example, the following IF statement command Excel to check the value in B3 and returns “OK” if it’s less than or equal to 10, “Not OK” if it’s less than 10:

=IF(B3>=10, “OK”, “Not OK”)

 

8. AND & OR

These are two very famous logical functions in Excel. These are used to check multiple criteria. Now, you may be eager to know different between both formulas. Let’s talk main difference between both functions:

AND returns TRUE if all conditions are met, otherwise FALSE

OR returns TRUE if any of conditions is met, otherwise FALSE

These formula are not often used as they are but both are massively used as a part of large formulas.

Example

we are using here IF formula with And. We will apply it for 2 columns. It returns “Best” if both values are greater than 2

=IF(AND(A2>1, B2>1), “Best”, “”)

In text of OR formula, you are satisfied with one value greater than 1 then it returns “Best”, you should use OR formula.

=IF(OR(A2>1, B2>1), “Best”, “”)

9. Today and Now

One amazing thing, you can watch current date and time without manually update daily. This magic begins with Today and Now function in Excel. This is also a popular formula in Excel.
=TODAY()            [current date]

=NOW()            [current date and time in a cell.]

Example

=TODAY()            [current date]

=NOW()            [current date and time in a cell.]

10. CONCATENATE

This formula is used in that condition where you want to take values from two or more cells and combine them into one cell; use the CONCATENATE function:
CONCATENATE(text1, [text2], …)

Example

For example, to combine the values from cells B4 and C8, just enter the following formula in a different cell:
=CONCATENATE(B4, C8)

Instagram Shortcuts that may be beneficial for you!

There are massive number of people are using Instagram daily. It is brand hub and business enhancer for various companies. Celebrities have also active accounts on Instagram.  More than 1 billion people use Instagram every month. Instagram has 3rd rank after Facebook and YouTube on the web. Over half billion people use Instagram daily.

Why should we use shortcuts to access a social networking site? Have you thought about it? You may answer it saves our efforts and time. It is correct? How much time? As per experience of other people, I found it saves more than 7 working days in a year. Can you imagine? That’s why shortcuts keys are used widespread by people.

Instagram is a mobile app. There is no keyboard shortcut for it. There are some shortcuts to access Instagram on mobile. These shortcuts are extremely useful to render you better experience. These will definitely work for you.

For iphone6 or later versions: If you press app icon longtime, it will give you a shortcut to create a new post, direct message, search view activities.

  • Tap and hold a post in grid view, it will expand the post.
  • Tap on profile long time will help you to switch between your other Instagram accounts.
  • Tap on profile or hashtag (#) will allow you to see recent posts.

 

Kindly reply in comments, if any shortcut is not found in this list; we will definitely add them in our list here. To know about Facebook keyboard shortcuts, click on this link: Facebook keyboard shortcuts. In the same way, you can use Gmail keyboard shortcuts to reduce your emailing work tension, visit here:  Gmail keyboard shortcuts. To know wordpress shortcuts click here: WordPress shortcut keys on keyboard.

 

35+Twitter Keyboard Shortcuts for Twitter Fans

 

Twitter is another powerful social networking site. Over 320 million people are using Twitter per month. Twitter is effective social networking site and it is very important platform for politician, celebrities and businessmen. Twitter is a very popular social networking site. Twitter fans regularly tweets and retweets and reply others. It is laborious work to use open tweet and other activities on Twitter. Twitter becomes easy to use, if you have shortcuts to use twitter. Accessing Twitter account through website feels time consuming often. We are trying to reduce your hard work with this post. It will especially assist those who access Twitter account on mobile devices. We have collected a dozen of Twitter keyboard shortcuts to make your Twitter experience better. Here is collection of Twitter shortcut keys:

 

Create a new tweet- N

Post a Tweet:  Ctrl+Enter

Send message directly: M

Escape from any popup window: Esc

Favorite a tweet: F

Reply a tweet: R

Retweet: T

 

Mute and Block a User

Mute: U

Block: B

Open Tweet description: Enter

Close all open tweets: L

Navigation keys

Move down a page: space

Move to up page: shift+space

Reach at Previous Tweet: K

Reach at Next Tweet: J

Page down: Space

Load New tweet:  . (dot)

Search bar: /

 

G+ key shortcuts

Activity: G+A

Discover: G+D

Favorites: G+F

Homepage: G+H

Lists: G+L

Messages: G+M

Notifications: G+N

Profile: G+P

Mentions: G+ R

Settings: G+S

Go to user: G+U

 

Kindly reply in comments, if any shortcut is not found in this list; we will definitely add them in our list here. To know about Facebook keyboard shortcuts, click on this link: Facebook keyboard shortcuts. In the same way, you can use Gmail keyboard shortcuts to reduce your emailing work tension, visit here:  Gmail keyboard shortcuts. To know wordpress shortcuts click here: WordPress shortcut keys on keyboard.

 

 

 

what is Option Key on Keyboard?

Perhaps you have heard about option key. But some of us exactly don’t know about option key. In many keyboard shortcuts, option key is used. So we are going to define option key. Option key is related with keyboard on Apple computers. It is used to create a special character and as a modifier for other commands. It is called a modifier key too. It is found on keyboard of Apple computers. The location of option key is between Control and Command keys on a Mac keyboard. Option key is presented on keyboard with “Alt” on it.