IT Tools in Management
ict-trainer.pl - © 2019 - Grzegorz Szyjewski
Exercise 3 - Excel Christmas tree

Create Christmas tree in Excel!
 
1. Draw a Christmas tree using cell fill color.

Resize cells (width) to be able to draw it.

2. Use conditional formatting for some cells to create lights.

Use any sign or number as a condition to change fill to red or yellow

3. Use IF function to relate all "lights" to one cell (to create a switch).

Use IF function in each light to check if value in switch cell

4. In Excel display "developer" toolbar and add form control (Check Box).

Use customize the Ribbon function to display additional menu

5. Connect inserted control with switch cell to be able to turn on/off light with the checkbox.

Each form control may be connected to any spreadsheet cell and change its value

6. Use the same functions to add presents under the tree.