Excel

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