Excel
Professional Development
•10 Qs
Similar activities
FinTech 10-1 Time Series
Professional Development
•10 Qs
Ostomias Respiratórias
Professional Development
•13 Qs
Atividade Interativa- Fortaleza
Professional Development
•7 Qs
Current affairs and GK
Professional Development
•10 Qs
Blender 3D
Professional Development
•15 Qs
Tema 1 Estadística Bàsica
Professional Development
•10 Qs
CURSO BÁSICO EXCEL
Professional Development
•14 Qs
Proporcionalidade Direta
1st Grade - Professional Development
•10 Qs
Excel
Quiz
•
Other, Mathematics, Fun
•
Professional Development
•
Practice Problem
•
Hard
Shreshtha Jain
Used 40+ times
FREE Resource
Enhance your content in a minute
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
Identify the formula for
VLOOKUP
=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
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
15 questions
Theodolite Surveying
Quiz
•
Professional Development
10 questions
KPI's
Quiz
•
1st Grade - Professio...
10 questions
Kuis IHT E-RMIK
Quiz
•
Professional Development
15 questions
A casa
Quiz
•
5th Grade - Professio...
10 questions
Matemática ENEM - Competência 1
Quiz
•
Professional Development
10 questions
TS EN ISO 17020 STANDARDI
Quiz
•
Professional Development
10 questions
Pelatihan Office Batch 6
Quiz
•
Professional Development
10 questions
Java Strings
Quiz
•
1st Grade - Professio...
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
20 questions
Figurative Language Review
Quiz
•
6th Grade