WorksheetsBinary & Spreadsheet Quiz Revision
Total questions: 31
Worksheet time: 22mins
What is 4 in binary? Use the conversion table for guidance.
111
101
100
1011
What is 5 in binary? Use the conversion table for guidance.
1001
1111
0101
10011
The binary numbering system uses _____ numbers.
one
two
three
four
What are the numbers used in the binary numbering system?
0-10
0-15
0-1
0-5
What numbering system do we use to count in the real world?
Hexadecimal
Base 16
0-15
Decimal
Base 10
0-9
Octal
Base 8
0-7
Binary
Base 2
0-1
What is 0011 in denary? Use the conversion table for guidance.
1
2
3
4
What is 1001101 in denary. Use the conversion table for guidance.
82
24
77
11
What is 00100101 in denary? Use the conversion table for guidance.
36
37
48
27
What is 46 in binary? Use the conversion table for guidance.
00101110
00011111
01000100
00110000
What is 65 in binary? Use the conversion table for guidance.
01100001
00100001
01000001
00100101
What is 11111101 in denary? Use the conversion table for guidance.
(a)
How must a cell containing a formula start?
SUM
=
+
( )
A cell can contain text, values and what else?
Currency
Percentages
Formulae
Dates
The cell reference is the combination of what two things?
column number and row number
column letter and row number
column number and row letter
What is written in cell D4?
4376
Doz
PDA
Web cam
What is written in cell range E4:E7?
The item numbers
The quantities
The unit prices
A spreadsheet package is an application package
which
Enables you to organise data as tables and perform operations on that data using functions and
formulae.
Enables you to produce professional
documents.
Enables the production of presentations to assist teaching and
lectures.
Keeps tables of records of entities in an
organisation.
Labels are used in a spreadsheet to
Give the computer
instructions.
Give information about the data being
displayed.
Set up formulae
complete
calculations.
Complete
calculations.
What is the cell range of the cells highlighted in blue?
(a)
This function is used the find the highest value in a range
(a)
Which what if scenario would you use to check that cell C2 has the correct answer?
=IF(C2="C", "Correct", "Wrong")
IF answer =="London":
print("Correct")
else:
print("Wrong")
=IF(A4="London", "Correct", "Wrong")
=Check(C2="London", "Wrong", "Correct")
What result would =SUM(C4:C7) give me?
4
5
20
An Error
Which formula should be written in cell B3 to calculate the sale price?
=B1 + B2
=B1 - B2
=B3 - B1
=B2 * B1
What is the formula to work out the MAX of the highlighted cells?
=MAX(C1:Q1)
=MAX(C15:R15)
=MAXIMUM(C15:Q15)
=MAX(D2:D9)
What is the formula to work out the AVERAGE of the highlighted cells?
=AVERAGE(C1:Q1)
=AVG(C2:C8)
=AVERAGE(C15:R15)
=C15:Q15
What is the formula to work out the MIN of the highlighted cells?
=MIN(C1:Q1)
=MIN(C15:R15)
=MINIMUM(C15:R15)
+MIN(E15:15)
A formulae that gets the minimum value from a given range of cells.
SUM
AVERAGE
MIN
MAX
A formulae that gets the maximum value from a given range of cells.
SUM
AVERAGE
MIN
MAX
A formulae that adds all the values from a given range of cells.
SUM
AVERAGE
MIN
MAX
A formulae that adds all the values from a given range of cells and divides it by how many numbers there were to get the mean.
SUM
AVERAGE
MIN
MAX
