Exam (elaborations)
GMETRIX PRACTICE EXAM 2 QUESTIONS WITH CORRECT ANSWERS.
- Course
- Institution
GMETRIX PRACTICE EXAM 2 QUESTIONS WITH CORRECT ANSWERS.
[Show more]
Content preview
GMETRIX PRACTICE EXAM 2QUESTIONS WITH CORRECT ANSWERS
Project t1 ttask t1 t- tAnswer t1. tAbove tthe tworksheet tto tthe tleft tof tthe tformula tbar, tclick
tthe tName tBox tdown tarrow.
2. tSelect tAppheading2.
3. tCell trange tE1:F3 tshould tbe tselected.
4. tRight-click ton tthe tselected tcells tand tselect tClear tContents.
5. tClick tOK.
On tthe tDownloads tworksheet, tadjust tthe theight tof trow t27 tto t78. t- tAnswer t1. tOn tthe
tDownloads tworksheet, tclick trow t27 tto tselect tit.
2. tOn tthe tHome ttab, tin tthe tCells tgroup, tclick tFormat tand tselect tRow tHeight.
3. tIn tthe tRow tHeight tpop-up tbox, ttype t78.
4. tClick tOK.
Apply tthe tcell tstyle tLight tBlue, t40% t- tAccent t2 tto tcell tA27. t- tAnswer t1. tSelect tcell
tA27.
2. tOn tthe tHome ttab, tin tthe tStyles tgroup, tclick tthe tMore tdropdown.
3. tIn tthe tThemed tCell tStyles tsection, tclick tLight tBlue, t40% t- tAccent t2.
Create ta ttable twith theaders tfrom tcell trange tA3:B24 tby tapplying tthe tBlue, tTable tStyle
tLight t10. t- tAnswer t1. tOn tthe tDownloads tworksheet, tclick tanywhere twithin tthe tcell
trange tA3:B24.
2. tOn tthe tHome ttab, tin tthe tStyles tgroup, tclick tFormat tas tTable.
3. tIn tthe tsection, tselect tBlue, tTable tStyle tLight t10.
4. tIn tthe tFormat tAs tTable tpop-up twindow, tdo tthe tfollowing:
a. tConfirm tthe tdata tfield tcontains t=$A$3:$B$24.
Insert ta tFooter tthat tdisplays ttoday's tdate ton tthe tright, tand tthen treturn tto tNormal
tview. t- tAnswer t1. tOn tthe tInsert ttab, tin tthe tText tgroup, tclick tHeader t& tFooter.
2. tIn tthe tHeader t& tFooter tDesign ttab, tin tthe tNavigation tgroup, tclick tGo tto tFooter.
3. tClick tthe trightmost tcell tin tthe tFooter.
4. tOn tthe tHeader t& tFooter tTools tDesign ttab, tin tthe tHeader t& tFooter tElements
tgroup, tclick tCurrent tDate.
5. tClick toutside tof tthe tFooter tcells.
Import tPetFoods.txt tlocated tin tthe tGMetrixTemplates tfolder tas ta ttable ton ta tnew
tworksheet. t- tAnswer t1. tOn tthe tData ttab, tin tthe tGet t& tTransform tData tgroup, tclick
tFrom tText/CSV.
(Hint: tComma-Delimited tfiles tand tTab-Delimited tfiles tare ttypes tof tText tfiles.)
, 2. tIn tthe tImport tData tpop-up twindow, tbrowse tto tthe tGMetrixTemplates tfolder.
3. tSelect tthe tPetFoods.txt tfile tand tclick tthe tImport tbutton.
4. tIn tthe tPetFoods.txt tpop-up twindow, tconfigure tthe tfollowing:
File tOrigin: taccept tthe tdefault t- t1252: tWestern tEuropean t(Windows)
Delimiter: tTab
Data tType tDetection: tAccept tthe tdefault t- tBase ton tfirst t200 trows
5. tClick tthe tdown tarrow tto tthe tright tof tthe tLoad tbutton tand tselect tLoad tTo...
6. tIn tthe tImport tData tpop-up twindow, tconfigure tthe tfolowing:
Select thow tyou twant tto tview tthis tdata tin tyour tworkbook: tTable
Where tdo tyou twant tto tput tthe tdata? tNew tWorksheet
7. tClick tOK.
On tthe tFeed tInventory tworksheet, tremove tthe thyperlink tfunctionality tbut tleave tthe
ttext tin tcell tC27. t- tAnswer t1. tOn tthe tFeed tInventory tworksheet, tselect tcell tC27.
2. tOn tthe tInsert ttab, tin tthe tLinks tgroup, tclick tHyperlink.
3. tIn tthe tInsert tHyperlink tpop-up twindow, tclick tRemove tLink.
Remove tthe tconditional tformatting tfrom tthe tInventory tcolumn ton ton tthe tFeed
tInventory tworksheet. t- tAnswer t1. tOn tthe tFeed tInventory tworksheet, tclick tanywhere
ton tthe ttable.
2. tOn tthe tHome ttab, tin tthe tStyles tgroup, tclick tConditional tFormatting.
3. tSelect tClear tRules tand tclick tClear tRules tfrom tThis tTable.
On tthe tOrganic tFeed tworksheet, tformat tthe tdata trange tA3:F10 tas ta ttable tthat thas
theaders. tApply tthe tDark tRed, tTable tStyle tMedium t7 tformat. t- tAnswer t1. tOn tthe
tOrganic tFeed tworksheet, tselect tcell trange tA3:F10.
2. tOn tthe tHome ttab, tin tthe tStyles tgroup, tclick tFormat tas tTable tto topen tthe tgallery.
3. tUnder tthe tMedium tsection, tclick tDark tRed, tTable tStyle tMedium t7.
4. tIn tthe tFormat tAs tTable tpop-up twindow, tdo tthe tfollowing:
a. tConfirm tthe tdata tfield tcontains t=$A$3:$F$10.
b. tConfirm tthe tMy ttable thas theaders tbox tis tenabled.
c. tClick tOK.
On tthe tFeed tInventory tworksheet, tapply tStyle t11 tto tthe tchart. t- tAnswer t1. tOn tthe
tFeed tInventory tworksheet, tclick ton tthe tchart tto tselect tit.
2. tClick tthe tChart tTools tDesign tcontextual ttab.
3. tIn tthe tStyles tgroup, tclick tthe tMore tdown tarrow tto topen tthe tChart tStyles tgallery.
4. tSelect tStyle t11.
Display tthe tCosts tworksheet tin tthe tPage tLayout tview. tThen tinsert ta tpage tbreak
tbetween trow t20 tCracker tJacker tand trow t21 tRaspberry tChocolate. t- tAnswer t1.
tSelect tthe tView ttab.
2. tIn tthe tWorkbook tViews tgroup, tclick tPage tLayout.
3. tScroll tdown tthe tpage tand tselect trow t21 tRaspberry tChocolate.
4. tOn tthe tPage tLayout ttab, tin tthe tPage tSetup tgroup, tclick tBreaks.
5. tSelect tInsert tPage tBreak.
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 LucieLucky. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $11.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
77254 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now
