Google Sheet Level 1
Quiz
•
Computers
•
7th - 8th Grade
•
Practice Problem
•
Hard
Joe Cheung
Used 16+ times
FREE Resource
Enhance your content in a minute
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
計算平均分應用以下那一個函式?
SUM
Average
Count
Max
3.
MULTIPLE SELECT QUESTION
45 sec • 1 pt
圖中使用了以下那些功能?
粗體
斜體
文字改變色彩
底線
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
圖中的下三角是甚麽功能?
上拉式選單
䦕放選單
下拉式選單
自動計算總和鍵
Create a free account and access millions of resources
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
10 questions
演算法
Quiz
•
7th - 9th Grade
20 questions
109資訊科技大挑戰
Quiz
•
7th - 8th Grade
10 questions
Input/Output Devices
Quiz
•
7th Grade
10 questions
資安素養3~網路行為的法律責任
Quiz
•
3rd - 12th Grade
17 questions
生成式人工智能-實作1-文本生成
Quiz
•
8th Grade - University
20 questions
通信技术知识点测验
Quiz
•
KG - Professional Dev...
15 questions
閱讟競賽_高級組_3
Quiz
•
6th - 8th Grade
15 questions
閱讀競賽_高級組_1
Quiz
•
6th - 8th Grade
Popular Resources on Wayground
5 questions
This is not a...winter edition (Drawing game)
Quiz
•
1st - 5th Grade
15 questions
4:3 Model Multiplication of Decimals by Whole Numbers
Quiz
•
5th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
10 questions
The Best Christmas Pageant Ever Chapters 1 & 2
Quiz
•
4th Grade
12 questions
Unit 4 Review Day
Quiz
•
3rd Grade
10 questions
Identify Iconic Christmas Movie Scenes
Interactive video
•
6th - 10th Grade
20 questions
Christmas Trivia
Quiz
•
6th - 8th Grade
18 questions
Kids Christmas Trivia
Quiz
•
KG - 5th Grade
