A2資訊處理:試算表操作

A2資訊處理:試算表操作

9th - 12th Grade

8 Qs

quiz-placeholder

Similar activities

每日一ICT 14/11/2022-27/11/2022

每日一ICT 14/11/2022-27/11/2022

10th Grade

10 Qs

系統軟件mc

系統軟件mc

9th - 12th Grade

10 Qs

All Hands Meeting_July

All Hands Meeting_July

1st - 10th Grade

11 Qs

chapter7 電子商務的架構與模式

chapter7 電子商務的架構與模式

10th - 12th Grade

10 Qs

演算法

演算法

7th - 9th Grade

10 Qs

第二章 互联网

第二章 互联网

12th Grade

13 Qs

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

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

9th - 12th Grade

6 Qs

2223_S4_ICT_T2_exam_exercise_41-50

2223_S4_ICT_T2_exam_exercise_41-50

9th - 12th 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(_______)"