Excel

Excel

University

10 Qs

quiz-placeholder

Similar activities

土木工程施工技術6.

土木工程施工技術6.

University

10 Qs

健康用電腦小知識

健康用電腦小知識

3rd Grade - University

10 Qs

IT2GO

IT2GO

University - Professional Development

10 Qs

数字技术

数字技术

University

9 Qs

CyberLink PowerDirector Test

CyberLink PowerDirector Test

University - Professional Development

5 Qs

第2章 电子商务网络安全技术(1)

第2章 电子商务网络安全技术(1)

University

10 Qs

Python Tuples Quiz

Python Tuples Quiz

University

15 Qs

JAVA_3

JAVA_3

University

10 Qs

Excel

Excel

Assessment

Quiz

Computers

University

Practice Problem

Easy

Created by

Oscar Lam

Used 3+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

a) 圖片上左邊的1-6 於Excel 名為?

b) 圖片上上方的A-E 於Excel 名為?

A) Row

B) Column

A) Column

B) Row

A) Column

B) Numbers

A) Text

B) Row

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Row最多可以拉到去幾多行?

1000-9999

10000-99999

100000-999999

1,000,000+

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

如果要係一堆數字中搵最大既值 應該用以下邊一個Formula?

=SUM()

=MIN()

=VLOOKUP()

=MAX()

4.

MULTIPLE SELECT QUESTION

45 sec • 1 pt

請選出以下正確配對

=SUM() 即把()內既內容做加數

=MAX() 即把()內既內容搵最大既值

=AVERAGE() 即把()內既內容計平均數

=SUM() 即把()內既內容做減數

5.

MULTIPLE SELECT QUESTION

45 sec • 1 pt

Media Image

如要將A2內容乘B2內容, Formula會是..?

=A2xB2

=A2乘B2

=185.6*10

=A2*B2

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

圖中 "This" 的Column位置是?

A7

D7

7D

右下角

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

如要將圖中A1-A6的數字加上dollar sign. 應該點加?

逐個逐個將$輸入

輸入="$"+A1 如此類推

點選A行後按"$" 制 (右上位置)

叫BOH幫忙加

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?

Discover more resources for Computers