V/Hlookup, Data validation, and Sumif
11th Grade
•13 Qs
Similar activities
PS10 Data Validation
9th Grade - University
•10 Qs
Information Technology Acronyms for GenCyber
6th - 12th Grade
•15 Qs
Unit 6: Quality Control
10th - 12th Grade
•15 Qs
Defensive Design
KG - University
•11 Qs
Quiz on Security, Privacy, and Data Integrity
11th Grade
•15 Qs
LOOKUP_EXCEL
11th Grade
•10 Qs
WJEC GCSE ICT Unit 3 - Validation and Verification
10th - 11th Grade
•15 Qs
Ulangan Harian Analisis Data (Perbaikan dan Susulan)
9th - 12th Grade
•15 Qs
V/Hlookup, Data validation, and Sumif
Quiz
•
Computers
•
11th Grade
•
Hard
Khuon Ratha
Used 6+ times
FREE Resource
13 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
Data Validation ស្ថិតនៅផ្ទាំងមួយណា?
Home
Insert
Data
Formula
2.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
Data Validation បង្កើតដើម្បីគ្រប់គ្រងយ៉ាងជាក់លាក់នូវអ្វីដែលអ្នកប្រើក្នុង____
ក្រឡា
ប្រអប់
រូបមន្ត
Excel
3.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
______ស្វែងរកទិន្នន័យក្នុងជួរឈនឹងកំណត់ទិន្នន័យនៅជួដេក
=HlookUP()
=VlookUP
Data Validation
Pivot Table
4.
MULTIPLE SELECT QUESTION
45 sec • 5 pts
ជ្រើសចម្លើយខុស៣៖ _______ស្វែងរកទិន្នន័យក្នុងជួរដេកនឹងកំណត់ទិន្នន័យនៅជួរឈរ
=HlookUP()
=VlookUP
Data Validation
Pivot Table
5.
MULTIPLE SELECT QUESTION
45 sec • 5 pts
ជ្រើសចម្លើយខុស៣៖ រូបមន្ត =Vlookup()៖
=VLOOKUP(Products!A2:C20, G5, 3, FALSE)
=VLOOKUP(G5, Products!A2:C20, 3, FALSE)
=VLOOKUP(G5=3, TRUE, FALSE)
=VLOOKUP(G5, 3, FALSE)
6.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
ជ្រើសរូបមន្ត =Hlookup()៖ អោយបានត្រឹមត្រូវ
=HLOOKUP(Products!A2:C20, G5, 3, FALSE)
=HLOOKUP(G5, Products!A2:C20, 3, FALSE)
=HLOOKUP(G5=3, TRUE, FALSE)
=HLOOKUP(G5, 3, FALSE)
7.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
ដើម្បីទំលាក់ឈ្មោះនៅពេលដែលបង្កើត Data Validation សញ្ញា_____
ព្រួញទំលាក់ចុះ
បូក
ទ្រង់ជ្រូក
សញ្ញាផ្កាយ
Create a free account and access millions of resources
Similar Resources on Wayground
15 questions
Assesmen TIK
Quiz
•
9th - 12th Grade
10 questions
Database
Quiz
•
8th - 12th Grade
10 questions
DA02: Sheet 1
Quiz
•
9th - 12th Grade
11 questions
The system life cycle
Quiz
•
9th - 12th Grade
10 questions
Kuis_ Informatika_SMA KELAS X
Quiz
•
9th - 12th Grade
15 questions
Access Basics
Quiz
•
9th - 12th Grade
10 questions
Excel conditional and look up formulas
Quiz
•
9th - 12th Grade
12 questions
validation and verification
Quiz
•
3rd - 12th Grade
Popular Resources on Wayground
10 questions
Video Games
Quiz
•
6th - 12th Grade
20 questions
Brand Labels
Quiz
•
5th - 12th Grade
15 questions
Core 4 of Customer Service - Student Edition
Quiz
•
6th - 8th Grade
15 questions
What is Bullying?- Bullying Lesson Series 6-12
Lesson
•
11th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
15 questions
Subtracting Integers
Quiz
•
7th Grade
22 questions
Adding Integers
Quiz
•
6th Grade
10 questions
Exploring Digital Citizenship Essentials
Interactive video
•
6th - 10th Grade