Free Printable A2資訊處理：試算表操作

Free Printable Worksheets

Worksheets

A2資訊處理：試算表操作

Total questions: 8

Worksheet time: 24mins

Name

Class

Date

1.

a)

A

b)

B

c)

C

d)

D

2.

a)

凍結至第一欄

b)

凍結至第二欄

c)

凍結至第一列

d)

凍結至第二列

3.

a)

A

b)

B

c)

C

d)

D

4.

a)

A

b)

B

c)

C

d)

D

5.

a)

公式運算

b)

自動填滿

c)

等差輸入

d)

數值估算

6.

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

7.

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

8.

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

Reset

Similar Resources on Wayground

10 questions

computer science

Worksheet

•

10th - 11th Grade

13 questions

認識Quizizz

Worksheet

•

KG - University

13 questions

RAM&HDD/SSD

Worksheet

•

10th - 12th Grade

11 questions

How2Excel 1 - Data types and basic formulae

Worksheet

•

9th Grade

10 questions

统考电脑上册（29/9）

Worksheet

•

12th Grade

10 questions

Computer Network

Worksheet

•

10th Grade

10 questions

認識電腦平台

Worksheet

•

10th - 11th Grade