Excel
Professional Development
•10 Qs
Similar activities
Alessandro e Vanessa
Professional Development
•10 Qs
AVERAGE ROUND
Professional Development
•10 Qs
Reta numérica
Professional Development
•12 Qs
Teste inicial web Design
Professional Development
•10 Qs
Sai Competitive Institute (SCI) May Current Affairs
Professional Development
•15 Qs
Psychiatry Revision Medication
University - Professional Development
•15 Qs
Angular basics #02
Professional Development
•10 Qs
CT Components
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
12 questions
Reta numérica
Quiz
•
Professional Development
15 questions
Milady ch 9 Nail structure and Growth
Quiz
•
Professional Development
10 questions
Teste inicial web Design
Quiz
•
Professional Development
15 questions
HSSE Monthly Meeting Quiz
Quiz
•
Professional Development
10 questions
AVI - MINI TESTE DE MATEMÁTICA 7° A (MATUTINO)
Quiz
•
Professional Development
10 questions
TOT Lansia - Rehabilitasi medik Lansia
Quiz
•
Professional Development
12 questions
Config Quiz
Quiz
•
Professional Development
10 questions
CT Components
Quiz
•
Professional Development
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
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th 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