V/Hlookup, Data validation, and Sumif

V/Hlookup, Data validation, and Sumif

11th Grade

13 Qs

quiz-placeholder

Similar activities

B061 Revision

B061 Revision

11th Grade

14 Qs

BTEC Digital Information Technology: Component 2 - Learning Aim A

BTEC Digital Information Technology: Component 2 - Learning Aim A

9th - 11th Grade

15 Qs

Excel Data Validation

Excel Data Validation

6th Grade - Professional Development

10 Qs

Network Topology and excel IF function

Network Topology and excel IF function

9th - 12th Grade

15 Qs

Ethics in Conducting Online Research

Ethics in Conducting Online Research

11th Grade

17 Qs

MS Excel VLookup

MS Excel VLookup

9th - 12th Grade

10 Qs

VLOOKUP/HLOOKUP IGCSE Grade 11

VLOOKUP/HLOOKUP IGCSE Grade 11

10th - 11th Grade

17 Qs

Vlookup Revision Starter

Vlookup Revision Starter

9th - 11th Grade

8 Qs

V/Hlookup, Data validation, and Sumif

V/Hlookup, Data validation, and Sumif

Assessment

Quiz

Computers

11th Grade

Hard

Created by

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

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?