2023-24 - Y8 - Data Modelling - Quiz 3

What is the cell reference of the green cell?

• C4
• 5C
• C5
• A1

What data format is the value stored in cell E1?

• Number
• Date
• Currency
• Time

What would be the result of the following formula: =C1-B3

• 39
• 45
• 51
• 6

What data format is the value stored in cell A5?

• Date
• Text
• Currency
• Number

What is the cell reference of the cell which contains the text "Hello"?

• A5
• B7
• C1
• D2

What would be the result of the following formula: =D7+C1

• 47.50
• £43.00
• £47.50
• 43.00

What data format is the value stored in cell B7?

• Date
• Time
• Number
• Currency

What data type is the value stored in cell D7

• Currency
• Text
• Number
• Time

What would be the result of the following formula: =SUM(C1,B3,D7)

• 51.50
• 53
• 36.50
• 53.50

What is the colour of the cell shading that has been used in cell D1?

• No fill
• Green
• Red
• Black