← Unit 67
Latihan · Teroka Ria
Latihan

Latihan tambahan

2 soalan untuk mengukuhkan unit Teroka Ria. Jika salah, baca petunjuk dan cuba lagi.

Soalan 1 / 2Latihan tambahan
Formula manakah menjumlahkan sel C2 hingga C6?
求和公式 = formula jumlah 在电子表格里,求一列连续几格的总和,要用 =SUM,括号里写第一格和最后一格,中间用冒号,冒号表示“从……到……”。逗号只是把几个格子分开列出,减号是做减法。判断公式时,想一想它会把哪几格算进去。 例子:要把 A1 到 A4 四格加起来,写 =SUM(A1:A4)。 注意:公式一定用等号开头;括号里的格子名称要写对列字母和行数字。
a sum formula = formula jumlah To add a run of cells in one column, use =SUM with the first and last cell in the brackets joined by a colon, which means 'from … to …'. A comma only lists separate cells, and a minus sign subtracts. To judge a formula, think about which cells it will include. Example: to add the four cells A1 to A4, type =SUM(A1:A4). Watch out: a formula starts with an equals sign, and each cell name needs the right column letter and row number.
Soalan 2 / 2Latihan tambahan
Dalam hamparan Hana, sel B8 = RM40 (jumlah dapat wang) dan sel D8 = RM23.75 (jumlah belanja). Apakah nilai yang dipaparkan oleh formula =B8-D8?
读公式 = baca formula 公式 =B8-D8 的意思是:用 B8 格里的数减去 D8 格里的数,也就是得到的总数减去花掉的总数,得出剩下的钱(余额)。整数金额写成点零零,仙不够减就向令吉借一。 例子:B8 = RM30,D8 = RM12.40,=B8-D8 显示 RM17.60。 注意:公式里是减号,不是加号;借位以后令吉那一位要少一。
read the formula = baca formula The formula =B8-D8 means the number in B8 minus the number in D8: the total received minus the total spent, which is the money left (the balance). Write the whole amount with .00 and borrow RM1 when the sen are too small. Example: B8 = RM30 and D8 = RM12.40, so =B8-D8 shows RM17.60. Watch out: the formula has a minus sign, not a plus sign, and the ringgit place goes down by 1 after borrowing.

Tahniah! Kamu telah menyelesaikan latihan.

Kembali ke Wang