ISTM 210 PROMETHEUS
TEST 2 WITH ALL
ANSWERS RATED A+
Lesson B1 BExcel BBasics B- Bcorrect Banswer-
2 Bimportant Bpoints B- Bcorrect Banswer-1. Bno Bsubstitute Bfor Bexperience
2. Bshould Balways Bfind Bways Bto Bexperiment Bin BExcel
workbook B- Bcorrect Banswer-excel Bfile Bthat Bstores Ball Binfo, Bprevious
Bcalculations, Band Banalyses Bthat Byou Bhave Balready Bcompleted B
-must Bcontain Bat Bleast Bone Bworksheet
-can Bcontain Bhundreds Bof Bworksheets, Blimited Bby Bmemory Bspace Bof Bcomputer
worksheet B- Bcorrect Banswer-contains Bactual Bdata Band Bcalculations
-organized Binto Bthe Bcollection Bof Bcells Barranged Bin Bthe Bform Bof Ba Btable
-can Bcontain Bover B17 Bbillion Bcells
, cells B- Bcorrect Banswer-store Bindividual Bpieces Bof Bdata Bor Bcalcs
-refer Bto Bcells Bby Btheir Baddresses B
-according Bto Bcolumn Bletter Band Brow Bnumber B(A1)
-referencing Bcell Brange- Bupper Bleft Bcell Band Bbottom Bright Bcell Bin Brange
menus B- Bcorrect Banswer-file-used Bto Bmanipulate Bworkbooks
home- Bitems Bused Bin Bformatting Bthe Bappearance Bof Bdata Bin Bcells
insert-features Bthat Ballow Byou Bto Bplace Bspecialized Belements Bin Bworkbooks
B(charts, Bpics)
page Blayout- Bused Bto Bformat Bappearance Bof Bworksheets
formulas-aid Bin Bperforming Bcalcs Busing Bexcels Bbuilt Bin Bfunctions
data-used Bto Baid Bin Bimporting Band Bworking Bwith Blarge Bamounts Bof Bdata
review- Bhelp Bin Bsharing Ban Bexcel Bworkbook Bwith Bcolleagues B
view- Bchange Bhow Ba Bworksheet Bis Bdisplayed Bon Bscreen
**developer Bor Badd-ins Bare Bmenus Bthat Bcan Bbe Bcustomized Bto Bthe Boriginal
Bmenu
fill Bfeature B- Bcorrect Banswer-allows Byou Bto Bautomatically Bpopulate Bcells Bin Ba
Bworksheet
-Fill Bmenu Bitem Bis Bin Bthe Bediting Bgroup Bon Bthe Bhome Btab B
-can Balso Buse Bto Bcomplete Ba Bpattern B(1-5)-select Bseries Bfrom Bfill Bmenu
-copy Band Bpast Bis Ban Balternative Bfor Bthis B(ctrl-c Bis Bcopy, Bctrl-v Bis Bpaste)
inserting Ba Bcolumn Bor Brow B- Bcorrect Banswer-column- Bto Binsert Bcolumn
Bbetween BA Band BB, Bselect Bcolumn BB Band Bexcel Bwill Binsert Ba Bnew Bcolumn Bto
Bleft Bof Bthe Bcell B
row- Bbetween B1 Band B2, Bselect Brow B2 Band Bclick Binsert Bsheet Brows Bfrom Binsert
Bmenu
hide Bcolumn Bor Brow B- Bcorrect Banswer-hide Band Bunhide Bmenu Boptions Blocated
Bin Bhome Btab
print Barea B- Bcorrect Banswer-a Bworksheet Bcan Bonly Bhave Bone Bprint Barea
Bdefined Bat Ba Btime
TEST 2 WITH ALL
ANSWERS RATED A+
Lesson B1 BExcel BBasics B- Bcorrect Banswer-
2 Bimportant Bpoints B- Bcorrect Banswer-1. Bno Bsubstitute Bfor Bexperience
2. Bshould Balways Bfind Bways Bto Bexperiment Bin BExcel
workbook B- Bcorrect Banswer-excel Bfile Bthat Bstores Ball Binfo, Bprevious
Bcalculations, Band Banalyses Bthat Byou Bhave Balready Bcompleted B
-must Bcontain Bat Bleast Bone Bworksheet
-can Bcontain Bhundreds Bof Bworksheets, Blimited Bby Bmemory Bspace Bof Bcomputer
worksheet B- Bcorrect Banswer-contains Bactual Bdata Band Bcalculations
-organized Binto Bthe Bcollection Bof Bcells Barranged Bin Bthe Bform Bof Ba Btable
-can Bcontain Bover B17 Bbillion Bcells
, cells B- Bcorrect Banswer-store Bindividual Bpieces Bof Bdata Bor Bcalcs
-refer Bto Bcells Bby Btheir Baddresses B
-according Bto Bcolumn Bletter Band Brow Bnumber B(A1)
-referencing Bcell Brange- Bupper Bleft Bcell Band Bbottom Bright Bcell Bin Brange
menus B- Bcorrect Banswer-file-used Bto Bmanipulate Bworkbooks
home- Bitems Bused Bin Bformatting Bthe Bappearance Bof Bdata Bin Bcells
insert-features Bthat Ballow Byou Bto Bplace Bspecialized Belements Bin Bworkbooks
B(charts, Bpics)
page Blayout- Bused Bto Bformat Bappearance Bof Bworksheets
formulas-aid Bin Bperforming Bcalcs Busing Bexcels Bbuilt Bin Bfunctions
data-used Bto Baid Bin Bimporting Band Bworking Bwith Blarge Bamounts Bof Bdata
review- Bhelp Bin Bsharing Ban Bexcel Bworkbook Bwith Bcolleagues B
view- Bchange Bhow Ba Bworksheet Bis Bdisplayed Bon Bscreen
**developer Bor Badd-ins Bare Bmenus Bthat Bcan Bbe Bcustomized Bto Bthe Boriginal
Bmenu
fill Bfeature B- Bcorrect Banswer-allows Byou Bto Bautomatically Bpopulate Bcells Bin Ba
Bworksheet
-Fill Bmenu Bitem Bis Bin Bthe Bediting Bgroup Bon Bthe Bhome Btab B
-can Balso Buse Bto Bcomplete Ba Bpattern B(1-5)-select Bseries Bfrom Bfill Bmenu
-copy Band Bpast Bis Ban Balternative Bfor Bthis B(ctrl-c Bis Bcopy, Bctrl-v Bis Bpaste)
inserting Ba Bcolumn Bor Brow B- Bcorrect Banswer-column- Bto Binsert Bcolumn
Bbetween BA Band BB, Bselect Bcolumn BB Band Bexcel Bwill Binsert Ba Bnew Bcolumn Bto
Bleft Bof Bthe Bcell B
row- Bbetween B1 Band B2, Bselect Brow B2 Band Bclick Binsert Bsheet Brows Bfrom Binsert
Bmenu
hide Bcolumn Bor Brow B- Bcorrect Banswer-hide Band Bunhide Bmenu Boptions Blocated
Bin Bhome Btab
print Barea B- Bcorrect Banswer-a Bworksheet Bcan Bonly Bhave Bone Bprint Barea
Bdefined Bat Ba Btime
