NEW
Font size
WorksheetsExcel
Total questions: 10
Worksheet time: 2mins
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)
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)
Identify the Short Cut Key for fixing values (C4 --> $C$4)
F1
F2
F3
F4
Short Cut Key For
Undo
Ctrl+A
Ctrl+Y
Ctrl+U
Ctrl+Z
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)
Shortcut Key For
PIVOT TABLE
Ctrl+N+V
Alt+N+V
Ctrl+N+P
Alt+N+P
Shortcut To Apply Filter
Ctrl+Shift+A
Ctrl+Shift+F
Ctrl+Shift+L
Ctrl+Shift+Q
Shortcut Key for
AUTOSUM
Alt=
Alt+
Alt*
Alt#
Shortcut Key For
SORT
Alt+H+U+S
Ctrl+S+H+U
Alt+U+ H+S
Alt+H+S+U
Shortcut Key
to select Particular Table
Ctrl + Sift + A
Ctrl + Shift + Spacebar
Alt + Shift + Spacebar
Alt + Ctrl + Spacebar
