Identify the formula for
VLOOKUP
Excel
Professional Development
•10 Qs
Similar activities
Yellow Belt Quiz 1
Professional Development
•10 Qs
WB_Tally Quiz 2
Professional Development
•15 Qs
TI CEDENORTE
10th Grade - Professional Development
•14 Qs
Microsoft Excel (Post Test)
Professional Development
•10 Qs
Trucos de PowerPoint
Professional Development
•10 Qs
Photoshop для начинающих
Professional Development
•10 Qs
EVALUACIÓN MENSUAL FEBRERO - CRA
Professional Development
•8 Qs
SDSC BASIC COMPUTER OPERATIONS
4th Grade - Professional Development
•10 Qs
Excel
Quiz
•
Other, Mathematics, Fun
•
Professional Development
•
Hard
Shreshtha Jain
Used 39+ times
FREE Resource
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
=VLOOKUP(table_array, lookup_value, col_index_num, [range_lookup])
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
=VLOOKUP(table_array, col_index_num, lookup_value,[range_lookup])
=VLOOKUP(lookup_value, table_array, [range_lookup], col_index_num)
2.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
Identify the formula for
INDEX
=INDEX(array, row_num, [column_num])
=INDEX(row_num, array, [column_num])
=INDEX( [column_num], row_num, array)
=INDEX(array, [column_num], row_num)
3.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
Identify the Short Cut Key for fixing values (C4 --> $C$4)
F1
F2
F3
F4
4.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
Short Cut Key For
Undo
Ctrl+A
Ctrl+Y
Ctrl+U
Ctrl+Z
5.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
Identify the formula for
IF
=IF(logical_test, [value_if_true], [value_if_false])
=IF(logical_test, [value_if_true], [value_if_true])
=IF(logical_test, [value_if_false], [value_if_false])
=IF([value_if_true], [value_if_false], logical_test)
6.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
Shortcut Key For
PIVOT TABLE
Ctrl+N+V
Alt+N+V
Ctrl+N+P
Alt+N+P
7.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
Shortcut To Apply Filter
Ctrl+Shift+A
Ctrl+Shift+F
Ctrl+Shift+L
Ctrl+Shift+Q
Create a free account and access millions of resources
Create resources
Host any resource
Get auto-graded reports
Microsoft
Apple
Others
Similar Resources on Quizizz
10 questions
Discover Graduate Connect
Quiz
•
Professional Development
10 questions
EXAMEN 3 - OPERADOR JUNIOR - CRA
Quiz
•
Professional Development
12 questions
Excel Challenge
Quiz
•
Professional Development
10 questions
Review Week 1
Quiz
•
Professional Development
10 questions
Basic JavaScript (Henry)
Quiz
•
Professional Development
15 questions
Повышаем качество 4.0
Quiz
•
Professional Development
10 questions
Excel Básico
Quiz
•
Professional Development
15 questions
Python Skills
Quiz
•
1st Grade - Professio...
Popular Resources on Quizizz
15 questions
Character Analysis
Quiz
•
4th Grade
17 questions
Chapter 12 - Doing the Right Thing
Quiz
•
9th - 12th Grade
10 questions
American Flag
Quiz
•
1st - 2nd Grade
20 questions
Reading Comprehension
Quiz
•
5th Grade
30 questions
Linear Inequalities
Quiz
•
9th - 12th Grade
20 questions
Types of Credit
Quiz
•
9th - 12th Grade
18 questions
Full S.T.E.A.M. Ahead Summer Academy Pre-Test 24-25
Quiz
•
5th Grade
14 questions
Misplaced and Dangling Modifiers
Quiz
•
6th - 8th Grade