Brain Teasers

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
.............
There are nine identical-looking balls, but one is either heavier or lighter than the other eight. How can you determine which is the odd ball and find out whether this ball is heavier or lighter than the others using only two weighings with a balance?

Divide the nine balls into 3 sets of 3 balls each. Lets call them A, B & C.

Using the weighing scale compare the weights of A & B.

Two outcomes are possible:

1. The heavier ball is present in one of the sets and hence that set will tip. Once we have identified the set which contains the heavier ball, compare 2 balls from the set. Either one of the 2 is the heavier one... or the 3rd one is.

2. Both A & B have the same weight and hence the scales don't tip. So now we know that the heavier ball is in the 3rd set (C). Compare two balls from C like we did in point 1 and either one of the 2 is heavy or the remaining one is heavy.


<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">
 
A set of very simple - but at times confusing - questions.

<!--[if !supportLists]-->1.Some months have 30 days, some months have 31 days. How many months have 28 days?<!--[endif]-->
<!--[if !supportLists]-->2.If a doctor gives you 3 pills and tells you to take one pill every half hour, how long would it be before all the pills had been taken?<!--[endif]-->
<!--[if !supportLists]-->3.I went to bed at eight 8 o’clock in the evening and wound up my clock and set the alarm to sound at nine 9 o’clock in the morning. How many hours sleep would I get before being awoken by the alarm?<!--[endif]-->
<!--[if !supportLists]-->4.Divide 30 by half and add ten. What do you get?<!--[endif]-->
<!--[if !supportLists]-->5.A farmer had 17 sheep. All but 9 died. How many live sheep were left?<!--[endif]-->
<!--[if !supportLists]-->6.If you had only one match and entered a COLD and DARK room, where there was an oil heater, an oil lamp and a candle, which would you light first?<!--[endif]-->
<!--[if !supportLists]-->7.Take 2 apples from 3 apples. What do you have?<!--[endif]-->
<!--[if !supportLists]-->8.How many animals of each species did Moses take with him in the Ark ?<!--[endif]-->
<!--[if !supportLists]-->9.If you drove a bus with 43 people on board from Chicago and stopped at Pittsburgh to pick up 7more people and drop off 5 passengers and at Cleveland to drop off 8 passengers and pick up 4 more and eventually arrive at Philadelphia 20 hours later,What is the name of the driver?<!--[endif]-->
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden"><input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden"><input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">
 
Last edited:
1. all months have 28 days
2. 1.5 hours seems tooooooo...logical
3. 13 hours
4. 12
5. 9
6. the match
7. 2 apples
8. 2
9. <insert my name here>
 
Some...blank...in a big wet sea?

i see "a big wet c." lol

two spills in a big wet sea?

I give already.
 
1. all months have 28 days
2. 1.5 hours seems tooooooo...logical
3. 13 hours
4. 12
5. 9
6. the match
7. 2 apples
8. 2
9. <insert my="" name="" here="">

You got 5 correct and 4 wrong... :biggrin:
</insert><input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">
 
You got 5 correct and 4 wrong... :biggrin:
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">
2 = 1 hour
3 = not possible to set a wind up clock for '9 in the morning' - so would be woken after 1 hour if you went to sleep at 8.
4 = 70
8 = trick question, none
 

Forum statistics

Threads
1,223,737
Messages
6,174,204
Members
452,551
Latest member
croud

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top