國中科技1下2-4

國中科技1下2-4

7th - 9th Grade

6 Qs

quiz-placeholder

Similar activities

重溫諾規銘

重溫諾規銘

5th - 12th Grade

10 Qs

2021牛气冲天之培志线上新春团拜——新春问答题

2021牛气冲天之培志线上新春团拜——新春问答题

1st - 10th Grade

10 Qs

September Vocabulary

September Vocabulary

3rd - 10th Grade

11 Qs

key&pin

key&pin

KG - Professional Development

10 Qs

五年级华文修辞1

五年级华文修辞1

1st - 12th Grade

10 Qs

雅各的回转

雅各的回转

7th - 12th Grade

11 Qs

华文语法练习

华文语法练习

7th - 8th Grade

10 Qs

hanyu 3 chapter 9

hanyu 3 chapter 9

8th Grade

10 Qs

國中科技1下2-4

國中科技1下2-4

Assessment

Quiz

Fun

7th - 9th Grade

Practice Problem

Easy

Created by

Tang Da

Used 4+ times

FREE Resource

AI

Enhance your content in a minute

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

6 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

使用試算表軟體時,若要計算表中50個數值的總和,可以選用下列哪個函式?

SUM
COUNT
LARGE
AVERAGE

2.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Media Image

一試算表的資料如附圖所示,若有一公式為「=SUM(A1:B2)」,則其計算的結果為何?

3

5

6

12

3.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

試算表中,若C7儲存格的值為(C1+C2+C3+C4+C5+C6)/6,則C7的公式可以使用下列函數取代?

=AVERAGE(C1:C6)
=SUM(C1:C6)
=AVERAGE(C1:C7)
=SUM(C1:C7)

4.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

小揚利用Google試算表來計算實驗數據。若表中有100個數值,要計算全部數值的總和,除了一一加總外,還可以選用下列哪個函式?

SUM
RAND
LARGE
VALUE

5.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Media Image

小明利用試算表記帳,如附圖。若某儲存格的公式為「=SUM(B4:E4)」,則此公式計算的是什麼?

統計四天中早餐的總支出

統計四天中午餐的總支出

統計四天中晚餐的總支出

統計第三天的總支出

6.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Media Image

附圖中,若想知道「四天中,每日的平均總花費」,應使用下列哪一公式?

SUM(B2:E4)/4

SUM(B2~E4)/4

=SUM(B2:E4)/4

=SUM(B2~E4)/4

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?