S4 ICT online quiz 7
Quiz
•
Computers
•
10th Grade
•
Practice Problem
•
Hard
Au CK
Used 3+ times
FREE Resource
Enhance your content in a minute
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
1. 下列哪項公式是正確的?
(1) =SUM(A1:B1)
(2) =SUM(A1+B1)
(3) =SUM(A1,B1)
A. 只有 (1)
B. 只有 (1) 和 (2)
C. 只有 (2) 和 (3)
D. (1)、(2) 和 (3)
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
2. 下列哪項公式會導致「#VALUE!」錯誤?
(1) =VALUE(123)
(2) =VALUE(“123”)
(3) =VALUE(“123A”)
A. 只有 (1)
B. 只有 (3)
C. 只有 (1) 和 (3)
D. (1)、(2) 和 (3)
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
3. 下列哪項公式所得的結果是「Hell」?
(1) =LEFT(“HelloWorld”, 4)
(2) =MID(“HelloWorld”, 4, 1)
(3) =“He”+“ll”
A. 只有 (1)
B. 只有 (2)
C. 只有 (1) 和 (3)
D. (1)、(2) 和 (3)
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
4. 儲存格A1 內的數值是3.48,下列哪項公式的結果是3?
(1) =INT(A1)
(2) =ROUND(A1,0)
(3) =MOD(A1,3)
A. 只有 (1)
B. 只有 (3)
C. 只有 (1) 和 (2)
D. (1)、(2) 和 (3)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
5. 下列哪項陳述是正確的?
(1) 自動填滿可以在複製和貼上時使用。
(2) 自動填滿可以用於擴展數字序列。
(3) 自動填滿可以用於擴展由用戶預設的不規則文本樣式。
A. 只有 (1)
B. 只有 (2)
C. 只有 (1) 和 (3)
D. (1)、(2) 和 (3)
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
6. 下列哪項陳述是正確的?
(1) 絕對儲存格參照只可用於正數。
(2) 絕對儲存格參照必須最少包含一個「$」字符。
(3) 在試算表中,$A$1可以被 $(A1) 取代。
A. 只有 (1)
B. 只有 (2)
C. 只有 (2) 和 (3)
D. (1)、(2) 和 (3)
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
7. 下列哪項關於的假設分析的陳述是正確?
(1) 假設分析可用於查考變量數值的改變對結果所產生的影響。
(2) 樞紐分析表可以用於進行假設分析。
(3) 商業公司可以使用假設分析以求取利潤的最大值。
A. 只有 (1)
B. 只有 (2)
C. 只有 (1) 和 (3)
C. 只有 (1) 和 (3)
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
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
Similar Resources on Wayground
15 questions
Входной тест по информатике_1 курс
Quiz
•
9th - 10th Grade
10 questions
Microsoft Excel
Quiz
•
10th Grade
10 questions
Truy tìm Anh tài ( Bài 2 Tin 4)
Quiz
•
4th Grade - University
10 questions
ExamenHojasdecalculo
Quiz
•
10th Grade
11 questions
Youtube
Quiz
•
4th Grade - University
10 questions
Perkembangan Teknologi Pada Sistem Sensor
Quiz
•
10th - 12th Grade
10 questions
BÀI KIỂM TRA GIỮA KÌ 2 - LỚP 3
Quiz
•
1st - 10th Grade
14 questions
Pre-test: On Online searching by Innovative Teaching Ideas)
Quiz
•
6th - 12th Grade
Popular Resources on Wayground
10 questions
Honoring the Significance of Veterans Day
Interactive video
•
6th - 10th Grade
9 questions
FOREST Community of Caring
Lesson
•
1st - 5th Grade
10 questions
Exploring Veterans Day: Facts and Celebrations for Kids
Interactive video
•
6th - 10th Grade
19 questions
Veterans Day
Quiz
•
5th Grade
14 questions
General Technology Use Quiz
Quiz
•
8th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
15 questions
Circuits, Light Energy, and Forces
Quiz
•
5th Grade
19 questions
Thanksgiving Trivia
Quiz
•
6th Grade
