WALL STREET PREP EXCEL
Which6of6the6following6keys6IS6NOT6a6way6to6trace6precedent6cells?6-6--Ctrl6Alt6[
Please6select6the6answer6that6best6describes6the6shortcut6to
Split6(not6freeze)6an6excel6sheet6into6just6two6panes6(top6and6bottom)
To6navigate6from6pane6to6pane6-6--
1.6With6the6active6cell6on6any6row6but6in6column6A,6hit6Alt6W6S6to6split6the6panes6to6a6top6
and6bottom.62.6Hit6F66to6jump6from6pane6to6pane6(in6some6versions6of6Excel6you6will6nee
d6to6hit6F66several6times6to6get6from6one6pane6to6the6other).
You6are6in6cell6A16and6start6a6formula6by6typing6=6in6a6worksheet6with6split6top6and6botto
m6panes.6In6order6to6jump6to6the6bottom6pane6while6working6on6the6formula:6-6--Hit6F6
If6I6want6to6add6the6title6"Company6Financials"6in6cell6A16ensure6that6all6columns6are6the6
same6width6across6all6the6worksheets6in6my6workbook,6how6would6I6do6that?6-6--
1.6Group6the6wroksheets6by6hitting6Ctrl6Shift6and6use6the6PageUp/
Down6keys6to6select6the6worksheets.62.6In6the6active6sheet6type6in6"Company6Financials"
6in6A16and6apply6the6desired6width6to6all6columns63.6Remember6to6hit6Ctrl6Pageup6or6Pag
edown6to6make6sure6that6future6edits6only6apply6to6active6sheet.
If6I6want6to6add6the6title6"Company6Financials"6in6cell6A16ensure6that6all6columns6are6the6
same6width6across6all6the6worksheets6in6my6workbook,6how6would6I6do6that?6-6--
1.6Group6the6wroksheets6by6hitting6Ctrl6Shift6and6use6the6PageUp/
Down6keys6to6select6the6worksheets.62.6In6the6active6sheet6type6in6"Company6Financials"
6in6A16and6apply6the6desired6width6to6all6columns63.6Remember6to6hit6Ctrl6Pageup6or6Pag
edown6to6make6sure6that6future6edits6only6apply6to6active6sheet.
What6is6the6keyboard6sequence6to
1)6Group6highlighted6columns6(but6not6to6hide6group)
2)6Hide6the6group6(will6show6a6+6sign6above6the6column)
3)6Show6the6group6(will6show6a6+6sign6above6the6column)6-6--
1.6Shift6Alt6Right6Arrow62.6Alt6a6h63.6Alt6a6j
What6is6the6keyboard6shortcut6to6open6the6paste6special6dialog6box?6-6--
Alt6e6s6or6Alt6h6v6s
What6is6the6keyboard6shortcut6to6freeze6panes6within6a6worksheet?6-6--Alt6W6F6F
Which6of6the6following6keys6IS6NOT6a6way6to6trace6precedent6cells?6-6--Ctrl6Alt6[
Please6select6the6answer6that6best6describes6the6shortcut6to
Split6(not6freeze)6an6excel6sheet6into6just6two6panes6(top6and6bottom)
To6navigate6from6pane6to6pane6-6--
1.6With6the6active6cell6on6any6row6but6in6column6A,6hit6Alt6W6S6to6split6the6panes6to6a6top6
and6bottom.62.6Hit6F66to6jump6from6pane6to6pane6(in6some6versions6of6Excel6you6will6nee
d6to6hit6F66several6times6to6get6from6one6pane6to6the6other).
You6are6in6cell6A16and6start6a6formula6by6typing6=6in6a6worksheet6with6split6top6and6botto
m6panes.6In6order6to6jump6to6the6bottom6pane6while6working6on6the6formula:6-6--Hit6F6
If6I6want6to6add6the6title6"Company6Financials"6in6cell6A16ensure6that6all6columns6are6the6
same6width6across6all6the6worksheets6in6my6workbook,6how6would6I6do6that?6-6--
1.6Group6the6wroksheets6by6hitting6Ctrl6Shift6and6use6the6PageUp/
Down6keys6to6select6the6worksheets.62.6In6the6active6sheet6type6in6"Company6Financials"
6in6A16and6apply6the6desired6width6to6all6columns63.6Remember6to6hit6Ctrl6Pageup6or6Pag
edown6to6make6sure6that6future6edits6only6apply6to6active6sheet.
If6I6want6to6add6the6title6"Company6Financials"6in6cell6A16ensure6that6all6columns6are6the6
same6width6across6all6the6worksheets6in6my6workbook,6how6would6I6do6that?6-6--
1.6Group6the6wroksheets6by6hitting6Ctrl6Shift6and6use6the6PageUp/
Down6keys6to6select6the6worksheets.62.6In6the6active6sheet6type6in6"Company6Financials"
6in6A16and6apply6the6desired6width6to6all6columns63.6Remember6to6hit6Ctrl6Pageup6or6Pag
edown6to6make6sure6that6future6edits6only6apply6to6active6sheet.
What6is6the6keyboard6sequence6to
1)6Group6highlighted6columns6(but6not6to6hide6group)
2)6Hide6the6group6(will6show6a6+6sign6above6the6column)
3)6Show6the6group6(will6show6a6+6sign6above6the6column)6-6--
1.6Shift6Alt6Right6Arrow62.6Alt6a6h63.6Alt6a6j
What6is6the6keyboard6shortcut6to6open6the6paste6special6dialog6box?6-6--
Alt6e6s6or6Alt6h6v6s
What6is6the6keyboard6shortcut6to6freeze6panes6within6a6worksheet?6-6--Alt6W6F6F
