Google Sheet Level 1

Google Sheet Level 1

7th - 8th Grade

15 Qs

quiz-placeholder

Similar activities

資訊科技的負面影響與應對

資訊科技的負面影響與應對

8th Grade

15 Qs

Sample Homework Quiz: Mandarin & English

Sample Homework Quiz: Mandarin & English

6th - 12th Grade

11 Qs

五年級數位影像

五年級數位影像

5th - 7th Grade

10 Qs

11302_01_個人資料保護(02)

11302_01_個人資料保護(02)

7th Grade

10 Qs

gimp 操作試題

gimp 操作試題

7th Grade

10 Qs

資訊安全

資訊安全

7th Grade

10 Qs

翻翻看APP

翻翻看APP

8th - 9th Grade

10 Qs

11302_02_資訊合理使用(02)

11302_02_資訊合理使用(02)

7th Grade

10 Qs

Google Sheet Level 1

Google Sheet Level 1

Assessment

Quiz

Computers

7th - 8th Grade

Practice Problem

Hard

Created by

Joe Cheung

Used 16+ times

FREE Resource

AI

Enhance your content in a minute

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

15 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

=SUM(C4:L4) 這個公式可以計算出 ?

平均數

最大值

總和

最小4位數

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

計算平均分應用以下那一個函式?

SUM

Average

Count

Max

3.

MULTIPLE SELECT QUESTION

45 sec • 1 pt

Media Image

圖中使用了以下那些功能?

粗體

斜體

文字改變色彩

底線

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

RANK.EQ 函數是?

幫助處理排名問題

幫助處理總和問題

幫助處理分數高低問題

幫助處理重複出現數字問題

5.

FILL IN THE BLANK QUESTION

1 min • 1 pt

RANK.EQ(D4,$D$4:$D$28)

如何快速加入$

提示: F

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

RANK.EQ(D4,$D$4:$D$28)

$ 這個代號有甚麽作用?

在數字前將會加入$

在大量數據資料中,加快計算速度

鎖定要比較的內容範圍,絕對參照的意思

內容範圍内有$號的會以顏色標示出來

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

圖中的下三角是甚麽功能?

上拉式選單

䦕放選單

下拉式選單

自動計算總和鍵

Create a free account and access millions of resources

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

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?