Excel
Authored by Oscar Lam
Computers
University
Used 3+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
如要將A2內容乘B2內容, Formula會是..?
=A2xB2
=A2乘B2
=185.6*10
=A2*B2
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
圖中 "This" 的Column位置是?
A7
D7
7D
右下角
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
如要將圖中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
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?
