Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.

1. What is the shortcut to ONLY select the visible cells? Guess, then click 'See Answer' as it can be done.
2. How do you take all the formatting from chart (see 1 below) and PASTE it onto another chart (2)? Guess and then see how it can be done with 'See Answer'

 

 

England to win World Cup (according to Excel)

England to win World Cup (according to Excel)


Update: See all our latest fun office pool sweepstake spreadsheets for sporting events

 

Using the World Cup predictions spreadsheets, we asked Excel to guess the winner of the 2014 Brazilian World Cup and the end result was England to win World Cup by beating Brazil in the finals. The semis had Brazil beating Switzerland and England overcoming Argentina.

Below a video clip of the process and the full list of scores lower down.


Below the Excel predictions for the Group Stages

world-cup-predicted-group-results

After this the group standings are anticipated to be

world-cup-predicted-group-standings

 

Below the results of the knock out stages with the eventual winner. Watch the video clip to understand the decimals as we had to use the RAND function to make sure that there were no draws in the knockout stages.

england-to-win-world-cup