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
14 questions
KTGK II tin7

Quiz
•
7th Grade
14 questions
S1 Spreadsheets Functions/Formulae

Quiz
•
7th - 11th Grade
15 questions
Year 8 Homework 3 - HT2

Quiz
•
7th Grade
10 questions
Post Tes Quiz Pembuatan Tabel dan Fungsi Dasar MS.Excel

Quiz
•
7th Grade
10 questions
Informatika - Analisis Data

Quiz
•
7th Grade
10 questions
kiểm tra 15 phút tin 7

Quiz
•
6th - 9th Grade
10 questions
TIN 7 KIEM TRA THƯỜNG XUYÊN LẦN 2

Quiz
•
7th Grade
10 questions
Excel Mastery Challenge

Quiz
•
7th Grade
Popular Resources on Wayground
18 questions
Writing Launch Day 1

Lesson
•
3rd Grade
11 questions
Hallway & Bathroom Expectations

Quiz
•
6th - 8th Grade
11 questions
Standard Response Protocol

Quiz
•
6th - 8th Grade
40 questions
Algebra Review Topics

Quiz
•
9th - 12th Grade
4 questions
Exit Ticket 7/29

Quiz
•
8th Grade
10 questions
Lab Safety Procedures and Guidelines

Interactive video
•
6th - 10th Grade
19 questions
Handbook Overview

Lesson
•
9th - 12th Grade
20 questions
Subject-Verb Agreement

Quiz
•
9th Grade
Discover more resources for Computers
11 questions
Standard Response Protocol

Quiz
•
6th - 8th Grade
11 questions
Hallway & Bathroom Expectations

Quiz
•
6th - 8th Grade
10 questions
Lab Safety Procedures and Guidelines

Interactive video
•
6th - 10th Grade
20 questions
One Step Equations All Operations

Quiz
•
6th - 7th Grade
24 questions
Flinn Lab Safety Quiz

Quiz
•
5th - 8th Grade
22 questions
Figurative Language

Quiz
•
7th Grade
10 questions
Essential Lab Safety Practices

Interactive video
•
6th - 10th Grade
30 questions
Lufkin Road Middle School Student Handbook & Policies Assessment

Quiz
•
7th Grade