Excel Crash Course Questions With
Correct Answers.
All gof gthe gfollowing gare gkeyboard gshortcut gthat gallow gthe guser ginput gto gadd gmore gsheets gto ga
gworkbook gEXCEPT:
Alt gi gw
Alt gh gi gs
Shift gF11
Alt gShift gF1
Alt gh gi gw
Incorrect g- g g g gcorrect ganswer.Alt gi gw, gAlt gh gi gs, gShift gF11 gand gAlt gShift gF1 gare gall gkeyboard gshortcuts
gfor gadding gmore gsheets gto ga gworkbook.
Alt gh gi gw gis gnot ga gvalid gshortcut.
What gis ga gkeyboard gshortcut gto gopen ga gfile?
Ctrl go
Ctrl gf
Alt go
Ctrl gn g- g g g gcorrect ganswer.The gcorrect ganswer gis gCtrl go.
Ctrl gf gis gthe gshortcut gto gfind, gor gfind gand greplace, gtext gon gthe gworksheet. gAlt go gis gnot ga gcommand.
gCtrl gn gis gthe gshortcut gto gopen ga gnew gworkbook.
What gis gthe grecommended gworkbook gcalculation gsetting gfor gExcel?
Automatic
Manual
Automatic gexcept gfor gData gTables
Iterate g- g g g gcorrect ganswer.The gcorrect ganswer gis g"Automatic gexcept gfor gData gTables".
, Data gtables gcan gsignificantly gslow gdown gExcel gand gother gprograms. g"Automatic", gthe gdefault
gsetting, gwill gautomatically gcalculate geverything gin gthe gworkbook, gincluding gdata gtables, gwhich gwill
gmake gthe gprogram grun gmore gslowly. gThe gManual gsetting gwill grequire gthe guser gto gfrequently
grecalculate gthe gworkbook gin gorder gto gdisplay gcorrectly. g"Iterate" gis gnot ga gsetting gfor gworkbook
gcalculation gin gExcel; giterative gcalculation gis ga gtoggle gfor gusers gto gset gfor gworkbooks gthat gmay ghave
gcircular gcalculations.q
To gadd ga gcell greference gfrom ga gdifferent gworksheet ginto gan gexisting gformula gwith gyour gkeyboard,
gyou gshould gfollow gthe gfollowing gsteps:
1. gHit gF2 gto gget ginto gthe gexisting gformula; gdelete gany gincorrect gformulas gor goperators g2. gHit gF2
gagain gto genable g"Enter" gmode gon gthe gbottom-left gcorner gof gthe gExcel gsheet g3. gHolding gdown gCtrl,
guse gPageUp gor gPageDown gto gfind gthe gdesired gworksheet g4. gLet ggo gof gthe gCtrl gand gPageUp/Down
gkeys g5. gUse gthe garrow gkeys gto glocate gthe gdesired gcell greference g6. gHit gEnter
1. gHit gF2 gto gget ginto gthe gexisting gformula; gdelete gany gincorrect gformulas gor goperators g2. gHit gF2
gagain gto genable g"Enter" gmode gon gthe gbottom-left gcorner gof gthe gExcel gsheet g3. gHolding gdown gAlt,
guse gPageUp gor gPageDown gto gfind gthe gdesired gworksheet g4. gLet ggo gof gthe gCtrl gand gPageUp/Down
gkeys g5. gUse gthe garrow gkeys gto glocate gthe gdesired gcell greference g6. gHit gEscape g- g g g gcorrect
ganswer.The gcorrect ganswer gis:
Hit gF2 gto gget ginto gthe gexisting gformula; gdelete gany gincorrect gformulas gor goperators
Hit gF2 gagain gto genable g"Enter" gmode gon gthe gbottom-left gcorner gof gthe gExcel gsheet
Holding gdown gCtrl, guse gPageUp gor gPageDown gto gfind gthe gdesired gworksheet
Let ggo gof gthe gCtrl gand gPageUp/Down gkeys
Use gthe garrow gkeys gto glocate gthe gdesired gcell greference
Hit gEnter
In gthe gincorrect goption, g3. gAlt gPage gUp g/ gDown gwill gnot gallow gthe guser gto gnavigate gto ga gdifferent
gworksheet; g6. gHit gEscape gwill gnot gsave gany gcell greferences, gbut gwill gdelete gany gnew gdata gor
gformula gthat ghas gbeen gentered ginto gthe gcell.
What gis gthe gkeyboard gcommand gto gautofit gthe grow gheight?
Alt go gc ga
Alt go gc gw
Alt gh go gh
Alt gh go ga g- g g g gcorrect ganswer.The gcorrect ganswer gis g"Alt gh go ga"
Correct Answers.
All gof gthe gfollowing gare gkeyboard gshortcut gthat gallow gthe guser ginput gto gadd gmore gsheets gto ga
gworkbook gEXCEPT:
Alt gi gw
Alt gh gi gs
Shift gF11
Alt gShift gF1
Alt gh gi gw
Incorrect g- g g g gcorrect ganswer.Alt gi gw, gAlt gh gi gs, gShift gF11 gand gAlt gShift gF1 gare gall gkeyboard gshortcuts
gfor gadding gmore gsheets gto ga gworkbook.
Alt gh gi gw gis gnot ga gvalid gshortcut.
What gis ga gkeyboard gshortcut gto gopen ga gfile?
Ctrl go
Ctrl gf
Alt go
Ctrl gn g- g g g gcorrect ganswer.The gcorrect ganswer gis gCtrl go.
Ctrl gf gis gthe gshortcut gto gfind, gor gfind gand greplace, gtext gon gthe gworksheet. gAlt go gis gnot ga gcommand.
gCtrl gn gis gthe gshortcut gto gopen ga gnew gworkbook.
What gis gthe grecommended gworkbook gcalculation gsetting gfor gExcel?
Automatic
Manual
Automatic gexcept gfor gData gTables
Iterate g- g g g gcorrect ganswer.The gcorrect ganswer gis g"Automatic gexcept gfor gData gTables".
, Data gtables gcan gsignificantly gslow gdown gExcel gand gother gprograms. g"Automatic", gthe gdefault
gsetting, gwill gautomatically gcalculate geverything gin gthe gworkbook, gincluding gdata gtables, gwhich gwill
gmake gthe gprogram grun gmore gslowly. gThe gManual gsetting gwill grequire gthe guser gto gfrequently
grecalculate gthe gworkbook gin gorder gto gdisplay gcorrectly. g"Iterate" gis gnot ga gsetting gfor gworkbook
gcalculation gin gExcel; giterative gcalculation gis ga gtoggle gfor gusers gto gset gfor gworkbooks gthat gmay ghave
gcircular gcalculations.q
To gadd ga gcell greference gfrom ga gdifferent gworksheet ginto gan gexisting gformula gwith gyour gkeyboard,
gyou gshould gfollow gthe gfollowing gsteps:
1. gHit gF2 gto gget ginto gthe gexisting gformula; gdelete gany gincorrect gformulas gor goperators g2. gHit gF2
gagain gto genable g"Enter" gmode gon gthe gbottom-left gcorner gof gthe gExcel gsheet g3. gHolding gdown gCtrl,
guse gPageUp gor gPageDown gto gfind gthe gdesired gworksheet g4. gLet ggo gof gthe gCtrl gand gPageUp/Down
gkeys g5. gUse gthe garrow gkeys gto glocate gthe gdesired gcell greference g6. gHit gEnter
1. gHit gF2 gto gget ginto gthe gexisting gformula; gdelete gany gincorrect gformulas gor goperators g2. gHit gF2
gagain gto genable g"Enter" gmode gon gthe gbottom-left gcorner gof gthe gExcel gsheet g3. gHolding gdown gAlt,
guse gPageUp gor gPageDown gto gfind gthe gdesired gworksheet g4. gLet ggo gof gthe gCtrl gand gPageUp/Down
gkeys g5. gUse gthe garrow gkeys gto glocate gthe gdesired gcell greference g6. gHit gEscape g- g g g gcorrect
ganswer.The gcorrect ganswer gis:
Hit gF2 gto gget ginto gthe gexisting gformula; gdelete gany gincorrect gformulas gor goperators
Hit gF2 gagain gto genable g"Enter" gmode gon gthe gbottom-left gcorner gof gthe gExcel gsheet
Holding gdown gCtrl, guse gPageUp gor gPageDown gto gfind gthe gdesired gworksheet
Let ggo gof gthe gCtrl gand gPageUp/Down gkeys
Use gthe garrow gkeys gto glocate gthe gdesired gcell greference
Hit gEnter
In gthe gincorrect goption, g3. gAlt gPage gUp g/ gDown gwill gnot gallow gthe guser gto gnavigate gto ga gdifferent
gworksheet; g6. gHit gEscape gwill gnot gsave gany gcell greferences, gbut gwill gdelete gany gnew gdata gor
gformula gthat ghas gbeen gentered ginto gthe gcell.
What gis gthe gkeyboard gcommand gto gautofit gthe grow gheight?
Alt go gc ga
Alt go gc gw
Alt gh go gh
Alt gh go ga g- g g g gcorrect ganswer.The gcorrect ganswer gis g"Alt gh go ga"
