Excel - Hàm

Quiz
•
Computers
•
7th Grade
•
Medium
Le Ha
Used 233+ times
FREE Resource
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Nếu A1 = 10 thì hàm IF sau trả về kết quả bao nhiêu? =IF(A1>5,"Vui quá", "Buồn quá")
Vui quá
Buồn quá
5
10
2.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Trong Microsoft Excel, câu lệnh =MIN(6, 5,- 1, 2, 10, -4, 3, 1, -8) có kết quả là:
10
1
-1
-8
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Trong Excel, câu lệnh sau cho kết quả bao nhiêu =AVERAGE(1,2,3,4)
2
2.5
3
4
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Trong Microsoft Excel, câu lệnh =MAX(6, 10, -3, 5, 9, -6, 13) có kết quả là:
6
10
-6
13
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Để chuyển dữ liệu sang kiểu % ta thực hiện?
Click phải chọn Format Cells/Number/Percentage
Click phải chọn Format Cells/Number/Special
Home/Format Cells/Number/Percentage
Home/Format Cells/Number/Special
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Trong Excel, câu lệnh sau cho kết quả bao nhiêu =AVERAGE(5,6,7,8)
5
6
6.5
7
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Thứ tự của các hàm trên là
Max-Min-Average-Sum
Sum-Average-Max-Min
Sum-Average-Min-Max
Sum-Min-Max-Average
Create a free account and access millions of resources
Similar Resources on Wayground
11 questions
Функції Excel

Quiz
•
7th Grade
10 questions
BAI TAP - BAI 10 - TIN 7

Quiz
•
6th - 8th Grade
10 questions
MS Excel

Quiz
•
5th - 8th Grade
15 questions
Spreadsheet Formulas

Quiz
•
7th - 8th Grade
10 questions
Funciones de Excel para estudiantes

Quiz
•
7th Grade - University
15 questions
REVIEW QUIZ

Quiz
•
7th Grade
14 questions
Spreadsheet Basics & Formula

Quiz
•
6th - 8th Grade
15 questions
Bài tập Excel cơ bản

Quiz
•
7th Grade
Popular Resources on Wayground
50 questions
Trivia 7/25

Quiz
•
12th Grade
11 questions
Standard Response Protocol

Quiz
•
6th - 8th Grade
11 questions
Negative Exponents

Quiz
•
7th - 8th Grade
12 questions
Exponent Expressions

Quiz
•
6th Grade
4 questions
Exit Ticket 7/29

Quiz
•
8th Grade
20 questions
Subject-Verb Agreement

Quiz
•
9th Grade
20 questions
One Step Equations All Operations

Quiz
•
6th - 7th Grade
18 questions
"A Quilt of a Country"

Quiz
•
9th Grade