2024-25 - 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
• 47.5
• 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: =C1+B3*D7)

• 30

• 47.4

• 127.5

• 60

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

• No fill
• Green
• Red
• Blue