Microsoft Excel Tips and Tricks - Computergaga

Home / Archives for Downloads

Christmas Movie Quiz Spreadsheet – Test your Knowledge

Think you know your Christmas movies? Why not try this Christmas movie quiz.

There are 20 movies to recognise from a picture. Select the film from the list below the picture. A running total is kept at the top of the sheet.

Download the Christmas movie quiz spreadsheet.

This spreadsheet can be unprotected as there is no password and the inner workings explored for learning.

Some of the Excel features used in the creating of this spreadsheet include;

[Read more…] about Christmas Movie Quiz Spreadsheet – Test your Knowledge

Excel Fixtures and League Table Generator

Due to popular demand, I have created an Excel fixture and league table generator.

Following on from my fixture list creator and league table generator files, I was asked to create a combined file to create a fixture list and also generate a league table from results entered.

Download the Excel fixtures and league table generator.

To use the file;

  1. Enter the teams competing and how many times they will play each other on the “Teams” sheet
  2. Enter the results from fixtures on the “fixtures” sheet
  3. View the league table on the “League table” sheet