Tag: knowledge

6-1×0+2÷2

This one has shown up online (facebook) again, with people getting confused over simple math and even arguing over it. 

It’s just a simple order of operations trick – PEMDAS if you recall, but let’s make it easier. 

Multiplication and division go first, so: 

6-1×0+2÷2

becomes: 

6-0+1  (because 1×0 = 0 and 2÷2 = 1)

Addition and subtraction work left to right, so just work the rest to get: 7

postnote: people seem to be searching for these-

6 1×0 2 2 answer
6 1×0 2 2 antwoord
6 1×0 2 2 mấy
6 1×0 2 2 resposta
6-1×0+2/2=bodmas
and best of all: Please Excuse My Dear Aunt Sally

Pasting into Excel splits data into columns

I noticed this week that every time I past  URL into excel, it would split it on the first colon (i.e. after the http portion) and split it across two cells. Obviously I don’t want it to do this, and I recalled this happening with some other data in the paste as well. Trying to format the columns didnt change anything, so why is this happening? 

The fix is this: paste something into a cell, then to the “text to columns” operation. Look at the delimiters specified for this feature- in my case, I had apparently entered a “:” earlier that I was using to try to parse some data. Apparently every time you paste text into excel, it tries to use these rules to determine if the data should be split across multiple columns or not. This is also the reason you can usually paste tab delimited text and it splits it out the way you want it- the tab is usually selected as a delimiter in the text to columns configuration. 

Hope this can help ease someone else’s frustration.