A2資訊處理:試算表操作

A2資訊處理:試算表操作

9th - 12th Grade

8 Qs

quiz-placeholder

Similar activities

2223_S4_ICT_T2_exam_exercise_41-50

2223_S4_ICT_T2_exam_exercise_41-50

9th - 12th Grade

10 Qs

2223_S4_ICT_T2_exam_exercise_21-30

2223_S4_ICT_T2_exam_exercise_21-30

9th - 12th Grade

10 Qs

Python_基礎觀念

Python_基礎觀念

9th Grade

12 Qs

S5 Programming Quiz

S5 Programming Quiz

10th Grade

7 Qs

演算法

演算法

7th - 9th Grade

10 Qs

S07.2 常见的应用软体

S07.2 常见的应用软体

10th Grade

12 Qs

mBot Q&A1-循序+重複結構

mBot Q&A1-循序+重複結構

9th - 12th Grade

6 Qs

第二章 互联网

第二章 互联网

12th Grade

13 Qs

A2資訊處理:試算表操作

A2資訊處理:試算表操作

Assessment

Quiz

Computers

9th - 12th Grade

Hard

Created by

Ka Lap WONG

Used 8+ times

FREE Resource

8 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

3 mins • 1 pt

Media Image

A

B

C

D

2.

MULTIPLE CHOICE QUESTION

3 mins • 1 pt

Media Image

凍結至第一欄

凍結至第二欄

凍結至第一列

凍結至第二列

3.

MULTIPLE CHOICE QUESTION

3 mins • 1 pt

Media Image

A

B

C

D

4.

MULTIPLE CHOICE QUESTION

3 mins • 1 pt

Media Image

A

B

C

D

5.

MULTIPLE CHOICE QUESTION

3 mins • 1 pt

Media Image

公式運算

自動填滿

等差輸入

數值估算

6.

FILL IN THE BLANK QUESTION

3 mins • 1 pt

Media Image

已知儲存格E1的公式是"=SUM(A1:B1)"。若將E1向右填入至F1,F1的公式是"=SUM(_______)"

7.

FILL IN THE BLANK QUESTION

3 mins • 1 pt

Media Image

已知儲存格E2的公式是"=SUM(A$2:$B2)"。若將E2向右填入至F2,F2的公式是"=SUM(_______)"

8.

FILL IN THE BLANK QUESTION

3 mins • 1 pt

Media Image

已知儲存格E2的公式是"=SUM(A$2:$B2)"。若將E2向下填入至E3,E3的公式是"=SUM(_______)"