Key Stage 3 (KS3) Spreadsheet Modelling Practice Test

The formula =IF(A1>10, "Yes", "No") is a logical function that evaluates a condition and returns one of two values based on whether that condition is true or false. In this case, the condition being evaluated is whether the value in cell A1 is greater than 10.

Since A1 contains the value 15, the condition 15 > 10 evaluates to true. Therefore, the formula will return the first specified value, which is "Yes". This makes it clear that when the condition is satisfied, the output reflects the affirmation of the statement being tested.

The alternative options do not apply to this scenario because they either represent outputs that would occur under different conditions or present outcomes that are not relevant to the logical evaluation being made by this formula. Thus, "Yes" is indeed the correct result when A1 contains 15.