Quiz#3 NOT(Rubik's Cube)

drsarao

Well-known Member
Joined
Sep 9, 2009
Messages
1,146
Office Version
  1. 2007
Platform
  1. Windows
A cube is painted Red, Green and Blue with opposing faces having same colour. The cube is now sawed with 3 cuts in each plane resulting in 64 equal cubes.

How many of following would you find?

Cubes with at-least TWO sides of different color.
Cubes with paint on ONE face only.
Cubes without ANY paint.
Cubes with ONE side without paint.
Cubes with THREE painted surfaces.
Cubes with RED and BLUE paints only.

Bonus question:
In the original uncut cube, how many SQUARES can you count?

Quiz#1 The-age-of-three-daughters

Quiz#2 Johnny-come-early
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
Here is what I came up with, although I have some reservations on the accuracy of some of my responses (as noted)

Cubes with at-least TWO sides of different color: 32 (2*12 edges on the opposite sides + 4*2 non-corner edges on each of the adjacent sides [24+8])
Cubes with paint on ONE face only: 24 (the 4 interior non-edge cubes from all 6 sides [4x6])
Cubes without ANY paint: 8 (the 2x2x2 cube in the center)
Cubes with ONE side without paint: 64 (all of the cubes would have at least one side without paint so perhaps I don't understand the question)
Cubes with THREE painted surfaces: 8 (the corners of the original cube [1*8])
Cubes with RED and BLUE paints only: 8 (the non-corner edges of the 2 common sides [2+2+2+2])

Bonus question:
In the original uncut cube, how many SQUARES can you count?
I would think 6 (each of the sides of the cube), however, that seems too simplistic so perhaps I don't understand the question.
 
Last edited:
Biocide,
You are right on all counts.

Two questions were wrongly worded by me. (Hence the ambiguity). Should be read as:
Cubes with exactly ONE side without paint.
In the original uncut cube (after the cut lines are marked), how many SQUARES can you count?

(I typed instead of copy-pasting to make it more difficult for a google-solution! But then Lost in Translation)
 
Cubes with exactly ONE side without paint: 0 (at most a cube could have 3 sides painted if it was a corner of the original cube)
In the original uncut cube (after the cut lines are marked), how many SQUARES can you count?
I believe it would be 126. (16:1x1 squares + 9:2x2 squares + 4:3x3 squares + 1:4x4 square = 21 squares on a face * 6 faces to a cube = 126.
 
I have moved this quiz to the Lounge. Please post all the quizzes there.
(With less traffic in the Lounge too, they will stay up on the front page longer;))
 
Last edited:
Thanks Joe!:)

I believe it would be 126. (16:1x1 squares + 9:2x2 squares + 4:3x3 squares + 1:4x4 square = 21 squares on a face * 6 faces to a cube = 126.

Biocide,
I can't believe, you were done in by simple sum in the end! The answer is 30*6=180.

I created a general formula using SUMPRODUCT() with segments for chessboard filled-in: (This is for ONE face only)
(Not at all elegant:crash: and limited to SUMPRODUCT() range)
Next iteration will be better.
Anybody else give it a try?
For other conditions also?
Excel Workbook
ABCDEFGHIJ
1
2Segments on one side876543210
3
4Total Nos of Squares204
Sheet12
Excel 2003
Cell Formulas
RangeFormula
C2=IF(B2>1,B2-1,0)
D2=IF(C2>1,C2-1,0)
E2=IF(D2>1,D2-1,0)
F2=IF(E2>1,E2-1,0)
G2=IF(F2>1,F2-1,0)
H2=IF(G2>1,G2-1,0)
I2=IF(H2>1,H2-1,0)
J2=IF(I2>1,I2-1,0)
B4=SUMPRODUCT(B2:J2,B2:J2)
 
Last edited:
:oops:
Oops... Not exactly sure how I did that. especially since I had the right numbers in my explanation... 16+9+4+1 = 30 like you said.
I think there is a life lesson here. When you focus so hard on the difficult parts you are prone to overlook the obvious, simple things that are staring you right in the face.
 
A better formula for 'squares within squares':
Excel Workbook
AB
1Segments on one side200
2Total Nos of Squares2686700
Sheet12
Excel 2003
Cell Formulas
RangeFormula
B2=SUMPRODUCT(ROW(INDIRECT("$A$1:$A$" & B1)),ROW(INDIRECT("$A$1:$A$" & B1)))
 
Array Entered:
=SUM(POWER(ROW($A$1:INDEX(A:A,B1)),2))
OR
=SUM(ROW($A$1:INDEX(A:A,B1))^2)
 
Taurean,
Crisp!
I could also shorten my formula based on it:

=SUMPRODUCT(ROW(INDIRECT("$A$1:$A$" & B1))^2)

(I had thought of it. But there was a mental block to putting only one argument in SUMPRODUCT()!)

Here is the complete generalized Excel solution. (I think it is correct. Submitted for peer review.)
Excel Workbook
AB
1CUBE Quiz
2No of cuts2
3No of segments3
4Total resulting cubes27
5
6Atleast 2 different colours20
7Exactly 2 different colours8
8Exactly 2 specific colours4
9Atleast 3 different colours8
10Only one face painted6
11No paint at all1
12Total Nos of Squares84
Sheet12
Excel 2003
Cell Formulas
RangeFormula
B3=B2+1
B4=B3^3
B6=B4-B11-B10
B7=(B3-2)*8
B8=(B3-2)*4
B9=1*8
B10=(B3-2)*(B3-2)*6
B11=(B3-2)^3
B12=SUMPRODUCT(ROW(INDIRECT("$A$1:$A$" & B3))^2)*6
 

Forum statistics

Threads
1,222,622
Messages
6,167,104
Members
452,094
Latest member
Roberto Saveru

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