100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
Previously searched by you
Excel Crash Course Exam|| All Questions And Correct Answers|| Latest And Complete Update 2024 With Expert Solutions|| Complete A+ Guide$16.49
Add to cart
Excel Crash Course Exam|| All Questions And Correct Answers||
Latest And Complete Update 2024 With Expert Solutions||
Complete A+ Guide
Which fof fthe ffollowing fkeys fIS fNOT fa fway fto ftrace fprecedent fcells?
Ctrl f[
f
Alt fm fp
Alt ft fu ft
f
Ctrl fAlt f[ f- fANSWER: fThe fcorrect fanswer fis: fCtrl f[. fCtrl f[ fis fnot fa fvalid fshortcut.
fAlt fm fp, f Alt ft fu ft, fand fCtrl fAlt f[ fare fall fshortcuts fthat fcan fbe fused fto ftrace fprecedent
fcells.
What fis fthe fkeyboard fshortcut fto ffreeze fpanes fwithin fa fworksheet?fAlt
f F fW fV
Alt fW fS
f Alt fW fF
,F
f
Alt fA fW fT f- fANSWER: fThe fcorrect fanswer fis: fAlt fw ff ff.
Alt ff fw fv fis fthe fshortcut ffor fPrint fPreview. fAlt fw fs fis fthe fshortcut fto fsplit fpanes. fAlt
fa fw ft fis fa fshortcut fto fbuild fdata ftables.
Please fselect fthe fanswer fthat fbest fdescribes fthe fshortcut fto
Split f(not ffreeze) fan fexcel fsheet finto fjust ftwo fpanes f(top fand fbottom)
To fnavigate ffrom fpane fto fpane
f
With fthe factive fcell fon fany frow fbut fin fcolumn fA, fhit fAlt fw fs fto fsplit fthe fpanes fto fa
ftop fand fbottom.
Hit fF6 fto fjump ffrom fpane fto fpane f(in fsome fversions fof fExcel fyou fwill fneed fto fhitfF6
fseveral ftimes fto fget f from fone fpane fto fthe fother).
If fthe factive fcell fis fnot fin fColumn fA, fthe fuser fwill fhave fmore fthan f2 fpanes. fIf fthe
factive fcell fis fin fRow f1, fthe f user fwill fget ftwo fvertical fpanes.
You fare fin fcell fA1 fand fstart fa fformula fby ftyping f= fin fa fworksheet fwith fsplit ftop fand
fbottom fpanes. fIn forder fto fjump fto fthe fbottom fpane fwhile fworking fon fthe f formula:
Hit fTab
Hit fF6
f
Hit fAlt fF6
Hit fAlt fTab f- fANSWER: fThe fcorrect fanswer fis: fHit fF6
Tab fwill fnavigate fto fthe fnext fcell. fAlt fF6 fis fnot fa fvalid fshortcut. fAlt fTab fwill
fnavigate fto fa fdifferent fwindow.
See flesson: fSplitting f& fFreezing fPanes
Identify fthe fcommands fto finsert fa fcomment fand fdelete fa fcomment
1)Alt fe fm f2) fAlt fe fm
f
1)Alt fh fe fm f2) fAlt fI fm
f 1)Shift fF2 f2) fAlt fh fe
f m
1)Alt fh fe fm f2) fAlt fI fs f- fANSWER: fThe fcorrect fanswer fis fShift fF2, fAlt fh fe fm.
, 3 | fP f a f g f e
Alt fe fm fis fa fshortcut fto fopen fthe fmenu fto fmove for fcopy fa fselected fsheet. fAlt fI fs fis
fthe fshortcut fto finsert fa fsymbol.
Identify fthe futility fused fto fcreate fa fdropdown fmenu fin fExcel.fAlt
f d ft
Alt fd fv fl
Alt fd fl
f
Alt fd fd ft f- fANSWER: fThe fcorrect fanswer fis: falt fd fl.
Alt fd ft fis fthe fshortcut fto fbuild fa fdata ftable. fAlt fd fv fl fis fnot fa fvalid fshortcut. fAlt fd fd ft
fis f not fa fvalid fshortcut.
Which fof fthe ffollowing fis fNOT fa fshortcut ffor fchanging fthe fformat fof fa fcellfCtrl
Tab
f
Ctrl fShift f1
Ctrl fB
f
Alt fh ff fc f- fANSWER: fThe fcorrect fanswer fis fCtrl fTab.
Ctrl fTab fwill fmove fthe fselected fcell. fIt fis fnot fa fshortcut fused fto fformat fcells. fCtrl
fShift f1 fwill fchange fthe fcell fto fa fNumber fformat, fCtrl fB fmakes fthe fcell ftext fbold, fAlt
fh ff fc fwill fallow fto fchange fthe ftext fcolor.
Alt fm fa f- fANSWER: fThe fcorrect fanswer fis fAlt fm fa.
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Ascorers. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $16.49. You're not tied to anything after your purchase.
