Friday, November 23, 2012

Fun Friday: Spreadsheet Fill Puzzle

This puzzle uses the fill feature of any spreadsheet application. Simply start a new workbook and fill in the listed cells with the indicated color to create a picture.

Before you begin, adjust the cell widths so that each cell is a square. Click the blank space above the first row’s 1 and to the left of the first column’s A. This will select the entire spreadsheet. Then click on the divider between column A and column B and drag until the cells are squares.

To read the codes below and find out which cells to fill:
C2 à means find the square in column C and row 2, click on that cell, then click on the fill color.
C2:D2 à means click and drag to select cells C2 through D2 and then click on the fill color.

Hint: The first part of a cell code is always a letter. So if it looks like a zero, it is really the letter “O”. The same goes for the number one and the letter “I”.

                O11 is the letter “O” and the number 11. (column O, row 11)
                I16 is the letter “I” and the number 16. (column I, row 16)

Now click in the indicated cells and fill with each color to form a picture.

Yellow: C2:D2, F2:H2, C3:J3, D4:K4, C5:L5, B6:M7, B8:N8, B9:P9, C10:T10, C11:O11, P12:M12, D13:K13, E14:J14, E15:I15, F16:H16, F17:G17, F18, E19:F19

Orange: D6:D10, E11:E12, F13:F14, G15, L13, K14:M14, J15:M15, K16:L16, T11:T13, S14, R15, Q16, P17, O18, N19, E20, L20:M20, F21:K21

Gray:  P11:S11, N12:S12, M13:S13, N14:R14, N15:Q15, I16:J16, M16:P16, H17:O17, G18:N18, G19:M19, F20:K20

Good luck and have fun!!

No comments:

Post a Comment