Wall Street Prep Excel Questions With
Correct Answers.
Which kof kthe kfollowing kkeys kIS kNOT ka kway kto ktrace kprecedent kcells? k- k k k kcorrect kanswer.Ctrl kAlt k[
Please kselect kthe kanswer kthat kbest kdescribes kthe kshortcut kto
Split k(not kfreeze) kan kexcel ksheet kinto kjust ktwo kpanes k(top kand kbottom)
To knavigate kfrom kpane kto kpane k- k k k kcorrect kanswer.1. kWith kthe kactive kcell kon kany krow kbut kin kcolumn kA,
khit kAlt kW kS kto ksplit kthe kpanes kto ka ktop kand kbottom. k2. kHit kF6 kto kjump kfrom kpane kto kpane k(in ksome
kversions kof kExcel kyou kwill kneed kto khit kF6 kseveral ktimes kto kget kfrom kone kpane kto kthe kother).
You kare kin kcell kA1 kand kstart ka kformula kby ktyping k= kin ka kworksheet kwith ksplit ktop kand kbottom kpanes. kIn
korder kto kjump kto kthe kbottom kpane kwhile kworking kon kthe kformula: k- k k k kcorrect kanswer.Hit kF6
If kI kwant kto kadd kthe ktitle k"Company kFinancials" kin kcell kA1 kensure kthat kall kcolumns kare kthe ksame kwidth
kacross kall kthe kworksheets kin kmy kworkbook, khow kwould kI kdo kthat? k- k k k kcorrect kanswer.1. kGroup kthe
kwroksheets kby khitting kCtrl kShift kand kuse kthe kPageUp/Down kkeys kto kselect kthe kworksheets. k2. kIn kthe
kactive ksheet ktype kin k"Company kFinancials" kin kA1 kand kapply kthe kdesired kwidth kto kall kcolumns k3.
kRemember kto khit kCtrl kPageup kor kPagedown kto kmake ksure kthat kfuture kedits konly kapply kto kactive ksheet.
If kI kwant kto kadd kthe ktitle k"Company kFinancials" kin kcell kA1 kensure kthat kall kcolumns kare kthe ksame kwidth
kacross kall kthe kworksheets kin kmy kworkbook, khow kwould kI kdo kthat? k- k k k kcorrect kanswer.1. kGroup kthe
kwroksheets kby khitting kCtrl kShift kand kuse kthe kPageUp/Down kkeys kto kselect kthe kworksheets. k2. kIn kthe
kactive ksheet ktype kin k"Company kFinancials" kin kA1 kand kapply kthe kdesired kwidth kto kall kcolumns k3.
kRemember kto khit kCtrl kPageup kor kPagedown kto kmake ksure kthat kfuture kedits konly kapply kto kactive ksheet.
What kis kthe kkeyboard ksequence kto
1) kGroup khighlighted kcolumns k(but knot kto khide kgroup)
Correct Answers.
Which kof kthe kfollowing kkeys kIS kNOT ka kway kto ktrace kprecedent kcells? k- k k k kcorrect kanswer.Ctrl kAlt k[
Please kselect kthe kanswer kthat kbest kdescribes kthe kshortcut kto
Split k(not kfreeze) kan kexcel ksheet kinto kjust ktwo kpanes k(top kand kbottom)
To knavigate kfrom kpane kto kpane k- k k k kcorrect kanswer.1. kWith kthe kactive kcell kon kany krow kbut kin kcolumn kA,
khit kAlt kW kS kto ksplit kthe kpanes kto ka ktop kand kbottom. k2. kHit kF6 kto kjump kfrom kpane kto kpane k(in ksome
kversions kof kExcel kyou kwill kneed kto khit kF6 kseveral ktimes kto kget kfrom kone kpane kto kthe kother).
You kare kin kcell kA1 kand kstart ka kformula kby ktyping k= kin ka kworksheet kwith ksplit ktop kand kbottom kpanes. kIn
korder kto kjump kto kthe kbottom kpane kwhile kworking kon kthe kformula: k- k k k kcorrect kanswer.Hit kF6
If kI kwant kto kadd kthe ktitle k"Company kFinancials" kin kcell kA1 kensure kthat kall kcolumns kare kthe ksame kwidth
kacross kall kthe kworksheets kin kmy kworkbook, khow kwould kI kdo kthat? k- k k k kcorrect kanswer.1. kGroup kthe
kwroksheets kby khitting kCtrl kShift kand kuse kthe kPageUp/Down kkeys kto kselect kthe kworksheets. k2. kIn kthe
kactive ksheet ktype kin k"Company kFinancials" kin kA1 kand kapply kthe kdesired kwidth kto kall kcolumns k3.
kRemember kto khit kCtrl kPageup kor kPagedown kto kmake ksure kthat kfuture kedits konly kapply kto kactive ksheet.
If kI kwant kto kadd kthe ktitle k"Company kFinancials" kin kcell kA1 kensure kthat kall kcolumns kare kthe ksame kwidth
kacross kall kthe kworksheets kin kmy kworkbook, khow kwould kI kdo kthat? k- k k k kcorrect kanswer.1. kGroup kthe
kwroksheets kby khitting kCtrl kShift kand kuse kthe kPageUp/Down kkeys kto kselect kthe kworksheets. k2. kIn kthe
kactive ksheet ktype kin k"Company kFinancials" kin kA1 kand kapply kthe kdesired kwidth kto kall kcolumns k3.
kRemember kto khit kCtrl kPageup kor kPagedown kto kmake ksure kthat kfuture kedits konly kapply kto kactive ksheet.
What kis kthe kkeyboard ksequence kto
1) kGroup khighlighted kcolumns k(but knot kto khide kgroup)
