Excel Crash Course Questions With Correct Answers.

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"