
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
9 questions
Computer Care
Quiz
•
3rd - 12th Grade
15 questions
Ipad
Quiz
•
1st Grade - Professio...
15 questions
Imaging and Design
Quiz
•
11th - 12th Grade
14 questions
Windows
Quiz
•
1st - 12th Grade
15 questions
Language translators
Quiz
•
11th Grade
14 questions
1.8 Issues Quiz
Quiz
•
9th - 11th Grade
18 questions
GCSE OCR Python Paper 2 Basics
Quiz
•
11th Grade
10 questions
C++ quiz
Quiz
•
10th Grade - Professi...
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
29 questions
Alg. 1 Section 5.1 Coordinate Plane
Quiz
•
9th Grade
22 questions
fractions
Quiz
•
3rd Grade
11 questions
FOREST Effective communication
Lesson
•
KG
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
Discover more resources for Computers
20 questions
-AR -ER -IR present tense
Quiz
•
10th - 12th Grade
22 questions
El Imperfecto
Quiz
•
9th - 12th Grade
15 questions
ACT Reading Practice
Quiz
•
11th Grade
20 questions
SSS/SAS
Quiz
•
9th - 12th Grade
20 questions
verbos reflexivos en español
Quiz
•
9th - 12th Grade
14 questions
Making Inferences From Samples
Quiz
•
7th - 12th Grade
23 questions
CCG - CH8 Polygon angles and area Review
Quiz
•
9th - 12th Grade
8 questions
Momentum and Collisions
Lesson
•
9th - 12th Grade