Excel Training Assessment

Name and Email ID

Current release of Microsoft Excel ?

2013

2012

2007

Short cut formula for format cells?

CTRL + 2

CTRL + 1

CTRL + 3

Short cut formula for selecting filtered selection?

ALT + ;

CTRL + ;

Shift + ;

Short cut formula for entering date?

ALT + ;

CTRL + ;

Shift + ;

Short cut formula for charts in another sheet?

ALT + F1

F11

Shift + F2

Function for current date and time?

NOW

CURRENT

TODAY

What to use while navigating through the formulas?

Trace formula above/below

Find formula now

Trace depends/precedents

Important point while using lookups?

The value being searched for should be in the first row or first column

The value being searched for should be in the second row or second column

Trainer : Raghu Mohan T | Date: 27-Jan-2014 | Location : Intense HO Training Room