V/Hlookup, Data validation, and Sumif

V/Hlookup, Data validation, and Sumif

11th Grade

13 Qs

quiz-placeholder

Similar activities

San Isidro ES LAC on MS Excel

San Isidro ES LAC on MS Excel

KG - University

9 Qs

Defensive Design

Defensive Design

10th - 11th Grade

16 Qs

LOOKUP_EXCEL

LOOKUP_EXCEL

11th Grade

10 Qs

WJEC GCSE ICT Unit 3 - Validation and Verification

WJEC GCSE ICT Unit 3 - Validation and Verification

10th - 11th Grade

15 Qs

COMPUTACION APLICADA 4TO BACO

COMPUTACION APLICADA 4TO BACO

9th - 12th Grade

12 Qs

Assesmen TIK

Assesmen TIK

9th - 12th Grade

15 Qs

Fungsi Dasar pada Microsoft Excel

Fungsi Dasar pada Microsoft Excel

11th Grade

15 Qs

Laporan Keuangan Spreadsheet

Laporan Keuangan Spreadsheet

KG - Professional Development

10 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?