A2資訊處理:試算表操作

A2資訊處理:試算表操作

9th - 12th Grade

8 Qs

quiz-placeholder

Similar activities

2223_S4_ICT_T2_exam_exercise_1-10

2223_S4_ICT_T2_exam_exercise_1-10

9th - 12th Grade

10 Qs

資安檢測_7

資安檢測_7

7th Grade - University

12 Qs

規範化反思題

規範化反思題

11th - 12th Grade

3 Qs

Operation System

Operation System

10th - 12th Grade

10 Qs

C++ 變數/輸入/輸出

C++ 變數/輸入/輸出

11th Grade

10 Qs

運算思維三

運算思維三

7th - 9th Grade

10 Qs

scratch

scratch

11th - 12th Grade

10 Qs

運算思維

運算思維

8th - 9th Grade

10 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(_______)"