F1 Spreadsheet Quiz

Given that there are values in cells B1 to B3, which of the following formulae work(s) for cell B4 to calculate the remainder of the division of X by Y? (You can choose more than 1 answers)

• =ROUND(B1/B2)

• =B1-B2*INT(B1/B2)

• =B1-B2*B3

Consider the following spreadsheet. The value in cell A5 is calculated by adding cells A1, A2 and A3. What should be the formula in cell A5 which can be copied to cell B5 so that the value of cell B5 become 80?

• A. A1+A2+A3

• B. =SUM(A1:A3)

• C. =A1+$A2+$A3

• D. =A1+A2+$A3

If we type ‘1’ and ‘3’ into cells A1 and A2 respectively, the cell A1 and A2 are selected and then are dragged downward to A3, A4 and A5. What will be the results?

• A. A3=1, A4=1, A5=1

• B. A3=1, A4=3, A5=1

• C. A3=5, A4=7, A5=9

• D. A3=3, A4=3, A5=3

According to the spreadsheet below, which of the following charts is the most suitable for presenting the data in column C without showing the total sales?

• A. Pie chart

• B. Bar chart

• C. Column chart

• D. Line chart

To "freeze" the first 2 rows and the "Student Name" column in a spreadsheet, which cell should Mr. Wong select first?

• A) A3

• B) B2

• C) A2

• D) B3

What formula should be entered into cell F3 to calculate the average mark of each student?

• A) =AVERAGE(B3:E3)

• B) =SUM(C3:E3)/4

• C) =(B3+C3+D3+E3)/4

• D) =SUM(B3:E3)

Which formula is used to find the highest mark of each subject in the spreadsheet?

• A) =MAX(B3:B34)

• B) =MAX(C3:C34)

• C) =MAX(A3:A37)

• D) =MAX(B2:E34)

What formula should be entered into cell G3 to show the position of the average of each student?

• A) =RANK(F3, $F$3:$F$34)

• B) =RANK(F3, F4:F34)

• C) =RANK.EQ(F3, $F$3:$F$34)

• D) =RANK(F3, F3:F34, 1)

To calculate the "No. of Core Subjects Passed" for each student, which formula should be entered into cell H3?

• A) =COUNTIF(C3:E3, ">=50")

• B) =COUNTIF(B3:E3, ">50")

• C) =SUMIF(B3:E3, ">50")

• D) =COUNT(B3:E3, ">50")

What formula should be entered into cell I3 to determine if a student gets a "PASS" or "FAIL" status based on core subjects passed?

• A) =IF(H3>=2, "PASS", "FAIL")

• B) =IF(H3>2, "PASS", "FAIL")

• C) =IF(H3>=3, "PASS", "FAIL")

• D) =IF(H3>1, "PASS", "FAIL")