V/Hlookup, Data validation, and Sumif
Authored by Khuon Ratha
Computers
11th Grade
Used 6+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
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 សញ្ញា_____
ព្រួញទំលាក់ចុះ
បូក
ទ្រង់ជ្រូក
សញ្ញាផ្កាយ
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?
Similar Resources on Wayground
12 questions
ICT Computer Basics pt1
Quiz
•
10th - 12th Grade
12 questions
PF 4.01 and 4.02
Quiz
•
9th - 12th Grade
15 questions
Environmental Impacts
Quiz
•
9th - 12th Grade
10 questions
Parts of a Computer
Quiz
•
9th - 12th Grade
10 questions
Photoshop Layers Review
Quiz
•
9th - 12th Grade
10 questions
INTERNET AND INTRANET
Quiz
•
9th - 11th Grade
14 questions
Introduction to Microsoft Word
Quiz
•
10th - 12th Grade
10 questions
Google Docs Basics
Quiz
•
7th Grade - University
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
10 questions
Probability Practice
Quiz
•
4th Grade
15 questions
Probability on Number LIne
Quiz
•
4th Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
6 questions
Appropriate Chromebook Usage
Lesson
•
7th Grade
10 questions
Greek Bases tele and phon
Quiz
•
6th - 8th Grade
