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
10 questions
Weekly Quiz 1

Quiz
•
4th Grade - Professio...
15 questions
Assesmen TIK

Quiz
•
9th - 12th Grade
12 questions
V-Hlookup (Kiểm tra kiến thức BT P84)

Quiz
•
11th Grade
10 questions
Quiz Fungsi Excel

Quiz
•
9th Grade - University
10 questions
Excel Data Validation Quiz

Quiz
•
9th - 12th Grade
12 questions
COMPUTACION APLICADA 4TO BACO

Quiz
•
9th - 12th Grade
10 questions
Kuis_ Informatika_SMA KELAS X

Quiz
•
9th - 12th Grade
15 questions
Database Features

Quiz
•
11th Grade
Popular Resources on Wayground
10 questions
SR&R 2025-2026 Practice Quiz

Quiz
•
6th - 8th Grade
30 questions
Review of Grade Level Rules WJH

Quiz
•
6th - 8th Grade
6 questions
PRIDE in the Hallways and Bathrooms

Lesson
•
12th Grade
10 questions
Lab Safety Procedures and Guidelines

Interactive video
•
6th - 10th Grade
10 questions
Nouns, nouns, nouns

Quiz
•
3rd Grade
25 questions
Multiplication Facts

Quiz
•
5th Grade
11 questions
All about me

Quiz
•
Professional Development
15 questions
Subtracting Integers

Quiz
•
7th Grade
Discover more resources for Computers
20 questions
Lab Safety and Lab Equipment

Quiz
•
9th - 12th Grade
7 questions
EAHS PBIS Lesson- Bathroom

Lesson
•
9th - 12th Grade
57 questions
How well do YOU know Neuwirth?

Quiz
•
9th - 12th Grade
20 questions
Getting to know YOU icebreaker activity!

Quiz
•
6th - 12th Grade
6 questions
Secondary Safety Quiz

Lesson
•
9th - 12th Grade
4 questions
Study Skills

Lesson
•
5th - 12th Grade
15 questions
Let's Take a Poll...

Quiz
•
9th Grade - University
20 questions
Points, Lines & Planes

Quiz
•
9th - 11th Grade