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
15 questions
Soal Latihan Teori TIK Ms.Excell Kelas 11 IPA/IPS

Quiz
•
11th Grade
15 questions
WJEC GCSE ICT Unit 3 - Validation and Verification

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

Quiz
•
9th - 12th Grade
10 questions
Kuis ke-2 (sem 2)

Quiz
•
11th Grade
10 questions
Latihan soal kelas 8_Analisis Data (Pencarian Data)

Quiz
•
9th - 12th Grade
8 questions
Vlookup Revision Starter

Quiz
•
9th - 11th Grade
10 questions
MS Excel VLookup

Quiz
•
9th - 12th Grade
10 questions
Logical Function

Quiz
•
9th - 12th Grade
Popular Resources on Wayground
18 questions
Writing Launch Day 1

Lesson
•
3rd Grade
11 questions
Hallway & Bathroom Expectations

Quiz
•
6th - 8th Grade
11 questions
Standard Response Protocol

Quiz
•
6th - 8th Grade
40 questions
Algebra Review Topics

Quiz
•
9th - 12th Grade
4 questions
Exit Ticket 7/29

Quiz
•
8th Grade
10 questions
Lab Safety Procedures and Guidelines

Interactive video
•
6th - 10th Grade
19 questions
Handbook Overview

Lesson
•
9th - 12th Grade
20 questions
Subject-Verb Agreement

Quiz
•
9th Grade
Discover more resources for Computers
40 questions
Algebra Review Topics

Quiz
•
9th - 12th Grade
19 questions
Handbook Overview

Lesson
•
9th - 12th Grade
40 questions
LSHS Student Handbook Review: Pages 7-9

Quiz
•
11th Grade
20 questions
Scalars, Vectors & Graphs

Quiz
•
11th Grade
62 questions
Spanish Speaking Countries, Capitals, and Locations

Quiz
•
9th - 12th Grade
10 questions
Solving Equations Opener

Quiz
•
11th Grade
20 questions
First Day of School

Quiz
•
6th - 12th Grade
21 questions
Arithmetic Sequences

Quiz
•
9th - 12th Grade