NEW
Font size
WorksheetsChristmas Spreadsheets Quiz
Total questions: 70
Worksheet time: 38mins
Which of the following describes a cell reference?
Displaying the data in the cell
Naming a cell with column letter and row number
Gives a cell a specific name
Referring to a cell that is used once
What is an example of a cell reference?
MRG
6A
A6
555
Columns are named with?
Numbers
Letters
Symbols
Rows are named with?
Numbers
Letters
Symbols
A formula starts with?
Equals ( = )
Cell Reference (eg. A6)
Brackets ( )
Colon ( : )
Which symbol allows us to multiply in Excel?
x
+
*
-
/
A white single square is known as?
square
column
reference
cell
row
A SUM function...
Adds values in selected cells
Finds the smallest value
Finds the largest value
Finds the average value
A MAX function...
Adds values in selected cells
Finds the smallest value
Finds the largest value
Finds the average value
A MIN function...
Adds values in selected cells
Finds the smallest value
Finds the largest value
Finds the average value
Subtracts the selected cells from each other (eg. D3-D4)
An AVERAGE function...
Adds values in selected cells
Finds the smallest value
Finds the largest value
Finds the average value
What are functions?
Specific instructions for carrying out a calculation
Built in formula in Excel
What is wrong with this formula?
C4*F4
Missing the equals (=) sign
Missing operation (*, /, +, -)
Missing function
missing a letter (column)
missing a number (row)
What is wrong with this function?
=SUM(C2+C22)
Missing the equals (=) sign
The '+' should be a colon (:)
Nothing is wrong it is correct
missing a letter (column)
missing a number (row)
What is wrong with this function?
=(E5:E20)
Missing the equals (=) sign
Missing a colon (:)
Missing a function
missing a letter (column)
missing a number (row)
Which of these is correct?
SUM(B3:B23)
SUM(B3+B23)
=SUM(B3+B23)
=SUM(B3:B23)
=SUMB3:B23
What is wrong with this formula?
C4*F4
Missing the equals (=) sign
Missing operation (*, /, +, -)
Missing function
missing a letter (column)
missing a number (row)
Which function should I use if I want to find the smallest value?
MIN
MAX
SUM
AVERAGE
Which function should I use if I want to find the biggest value?
MIN
MAX
SUM
AVERAGE
Which function should I use if I want to add the selected cells together?
MIN
MAX
SUM
AVERAGE
Which symbol should I use for absolute referencing?
=
*
$
£
If you copy the formula =$B$3 into another cell, the result will be:
The column part will remain the same
The row part will remain the same
Both the column and row will remain the same
Both will change
What would be a correct formula for a MIN function?
=MIN(B3:B9)
=MINB3-B9
MIN(B3:B9)
=MIN(B3-B9)
What would be a correct formula for a MAX function?
=MAX(B3B9)
=MAXB3-B9
MAXB3:B9
=MAX(B3:B9)
What is one reason to use cell references in a formula?
The answer will change if the numbers in referenced cells change.
You need cell references to use functions.
Only formulas with cell references can be copied and pasted.
You need cell references to use operators.
Which of the following formulas is the best way to add cells A1 to A5?
=SUM(A2+A5)
=A1+A2+A3+A4+A5
=A1:A5
=SUM(A2:A5)
What is the cell reference of the cell containing the value "School"?
B2
D2
B4
D4
What do you think the formula in cell C1 will display?
=A1+B1
15
6
A1B1
What formula should I used to find the MAX from F4 to F45?
MAX(F4:F45)
MAXF4:F45
=MAX(F4:F45)
=MAXF4:F45
Which of these will always divide the value of a cell A1 by 2?
=A1*B1
=A1/B1
=A1*2
=A1/2
Which is NOT a type of chart?
pie
column
bar
axis
A ___________________ is a visual representation of data.
chart
border
spreadsheet
table
Which of the following charts uses vertical bars to display data?
Area
Pie
Bar
Column
SUM, IF, COUNTIF, AVERAGE & MAX are all examples of?
Functions
Formulas
Filters
Validations
MISSING LYRICS:
Rockin' around, the Christmas ___________
House
Santa
Tree
Dinner
What did the Wise Men follow
Donkey
Star
Mr Lines
Moon
Rudolph has a 'what' nose?
Purple
Red
Massive
Small
You could decorate your tree with....
Animals
Roast Potatoes
Baubles
Turkey
Which one is not a reindeer for Santa?
Dasher
Skater
Prancer
Comet
How many reindeer does Father Christmas have?
6
8
9
7
Which of these is not in the '12 days of Christmas' song
Lords Leaping
Kings singing
5 gold rings
Maids Milking
What other name is Father Christmas known as...
St. Nicolas
St. George
St. Michael
St. Santa
What colour suit did Santa originally wear?
Blue
Red
Green
White
Which picture is the film 'The Polar Express'?
Which picture is the film 'The Snowman'?
Which picture is the film 'The Grinch?
Which picture is the film 'Elf?
MISSING LYRICS:
The stars in the _________ sky,
Look down where he ________.
Dark, lay
red, was
Bright, slept
Bright, lay
True or false?
There is a town in the UK named Santa Clause.
True
False
On which day of the week is Christmas Day this year (2020)
Tuesday
Wednesday
Thursday
Friday
In the movie 'How the Grinch Stole Christmas', What is the name of the Grinch's dog?
Mike
Max
Santa
Elf
What type of chart is this?
Donut
Radar
Bar
Pie
In the carol The Twelve Days of Christmas, how many Lords are a-leaping?
9
12
10
6
Traditionally, what is place on top of a Christmas Tree?
Santa Claus
An elf
A fairy
A star
Who usually delivers a televised speech on Christmas Day?
Donald Trump
The Prime Minister
Sir David Attenborough
The Queen
Which is NOT a traditional food served with turkey on Christmas Day?
Roast potatoes
Cranberry Sauce
Bread Sauce
Carrots
Fried eggs
Who redesigned the suit of Father Christmas to match their labelling?
Burger King
McDonalds
Pepsi
Coca-Cola
What is the best-selling Christmas single of all time?
All I Want For Christmas Is You
White Christmas
Last Christmas
Silent Night
