8/18/2019 BIS 155 Professional Tutor Bcom230mart.com
1/17
IS 155 professional tutor/bc
om230mart.com
FOR MORE CLASSES VISIT
www.bis155genius.com
http://www.bis155genius.com/http://www.bis155genius.com/
8/18/2019 BIS 155 Professional Tutor Bcom230mart.com
2/17
IS 155 Entire Course (Devr!
•"#$ %#$E C&'SSES ( S )
• ***.bis155+enius.com
•,
•,
• BIS 155 -ee Course roect Ecel roect•
• BIS 155 &ab 1 of Sa44le $iver %arcin+ Ban4
•
•
BIS 155 &ab 2 of Ecel6s '4vance4 "ormulas 7 "unctions•
• BIS 155 &ab 3 of 'lice Barr $ealt 'nalsis
•
• BIS 155 &ab 8 of Create '44ress &abels
• • 6
http://www.bis155genius.com/http://www.bis155genius.com/
8/18/2019 BIS 155 Professional Tutor Bcom230mart.com
3/17
IS 155 &ab 1 of Sa44le $iv
er %arcin+ an4 (Devr!
•"#$ %#$E C&'SSES ( S )
• ***.bis155+enius.com
•,
•,
• &ab 1 of : Sa44le $iver %arcin+ Ban4 (50 oints!• Submit our assi+nment to te Dropbo locate4 on te silver tab a
t te top of tis pa+e.
• & ' B # E $ I E -
• Scenario/Summar
• ;ou are te assistant to te ban4 4irector for te to>4ate *it te amount remainin+ to reac te profit +oal. ;ou *ill open te partiall complete4 *orboo
http://www.bis155genius.com/http://www.bis155genius.com/
8/18/2019 BIS 155 Professional Tutor Bcom230mart.com
4/17
IS 155 &ab 2 of Ecel6s '4
vance4 "ormulas 7 "unctions
•"#$ %#$E C&'SSES ( S )
• ***.bis155+enius.com
•,
•,
• BIS 155 &ab 2 of : Ecel?s '4vance4 "ormulas 7 "unctions• ;ou are an intern at "irst @ational Ban *orin+ in te loan 4epart
ment= an4 our boss as ase4 ou to prepare te montl A@e* &oan $eportA for te Boar4 of Directors. )is analsis report *ill clearl list an4 summari9e all ne* loans for resi4ential ousin+ in te
past mont. )e summar area inclu4es te loan statistics as labele4 4ata in te 4ata file. )e format of te report is appropriate forte Boar4 of Directors for te "irst @ational Ban.
http://www.bis155genius.com/http://www.bis155genius.com/
8/18/2019 BIS 155 Professional Tutor Bcom230mart.com
5/17
IS 155 &ab 3 of 'lice arr
$ealt 'nalsis (Devr!
•"#$ %#$E C&'SSES ( S )
• ***.bis155+enius.com
•,
•,
• &ab 3 of : 'lice Barr $ealt 'nalsis• ;ou are an intern *it te $e+ional $ealt 'ssociation an4 are
• anal9in+ te claim ma4e b 'lice Barr $ealt tat A*e +et our price.A ;ou ave
• prepare4 a sprea4seet tat so*s 4ata relatin+ to 3 monts6 sales b 'lice Barr
• $ealt. ;ou are +oin+ to 4etermine te percent of asin+ price for eac ome
• sol4 an4 anal9e te sales 4ata to 4etermine te true trac recor4of te
• compan in sellin+ omes for te asin+ price.
http://www.bis155genius.com/http://www.bis155genius.com/
8/18/2019 BIS 155 Professional Tutor Bcom230mart.com
6/17
IS 155 &ab 8 of Create '4
4ress &abels (Devr!
•"#$ %#$E C&'SSES ( S )
• ***.bis155+enius.com
•,
•,
• Create labels for te letters. )e ; Corporation *ises to use• mailin+ labels to a44ress te envelopes. )e o*n 1/2 11A see
ts of label
• paper *it 1A b 8A labels= *ic te purcase4 from #ffice
• Depot.
• Do*nloa4 te &ab 8= Step 3 Instructions.
• '. Create
http://www.bis155genius.com/http://www.bis155genius.com/
8/18/2019 BIS 155 Professional Tutor Bcom230mart.com
7/17
IS 155 &ab 5 of runo6s i
99a 'nalsis (Devr!
•"#$ %#$E C&'SSES ( S )
• ***.bis155+enius.com
•,
•,
• )e o*ner of Bruno6s i99a= oe Bruno= *ants to evaluate te profitabilit of is tree restaurants before e epan4s furter. Fe is particularl intereste4 in te comparative results of tree 4inin+ cate+ories= 4ine>in= picup= an4 4eliver. oe as ase4 for our elp in 4oin+ tis analsis in return for a small stipen4 an4 all te pi99a ou
can eat. ;ou ave alrea4 prepare4 a template an4 4istribute4 it toeac restaurant mana+er= *o as entere4 te sales 4ata for last ear. ;our net tas is to consoli4ate te 4ata into a sin+le *orboo tat so*s te total sales for eac Guarter an4 eac 4inin+ cate+or. )e information soul4 be so*n in tabular= as *ell as +rapi
cal formats. ;ou *ill also create a 4ocumentation seet so tat oe*ill no* eactl *at ou ave create4.
http://www.bis155genius.com/http://www.bis155genius.com/
8/18/2019 BIS 155 Professional Tutor Bcom230mart.com
8/17
IS 155 &ab of Da Care
Center (Devr!
•"#$ %#$E C&'SSES ( S )
• ***.bis155+enius.com
•,
•,
• ;our frien4= ane %orales= is consi4erin+ openin+ a Da Care Center. Se as starte4 compilin+ er assumptions an4 puttin+ to+eteran Income Statement. Se as 4etermine4 tat se must mae at least H5=000 profit per ear in or4er to start te business. Se asase4 ou to anal9e er Income Statement an4 elp er 4etermin
e *eter it is viable for er to start tis business. ;ou ave a+ree4to elp er complete er Income Statement an4 to perform -at>If analsis to elp er loo at er potential profitabilit.
http://www.bis155genius.com/http://www.bis155genius.com/
8/18/2019 BIS 155 Professional Tutor Bcom230mart.com
9/17
IS 155 &ab of 'ccess Dat
abase (Devr!
•"#$ %#$E C&'SSES ( S )
• ***.bis155+enius.com
•,
•,
• Fopefull ou *ill fin4 t5is *ee6s lab activit fun an4 useful. If ou5ave never create4 a 4atabase= ou *ill be able to tell all of our fri en4s an4 famil t5at ou are no* a 4atabase 4esi+ner. ;ou *ill *al t5rou+5 t5e steps of creatin+ an4 populatin+ an 'ccess 4atabaseto eep a recor4 of items in our 5ome. )5e 4atabase *ill 5ave a ta
ble= a form= a Guer= an4 a report.• )urn in one 4atabase name4 &ab3ourlastname.acc4b to t5e Dro
pBo2. -5en submittin+ t5e 4atabase= provi4e a comment in t5e Dr opbo2 comments area e2plainin+ *5at ou learne4 from completi n+ t5is lab activit.
http://www.bis155genius.com/http://www.bis155genius.com/
8/18/2019 BIS 155 Professional Tutor Bcom230mart.com
10/17
IS 155 -ee 1 Jui9 (Ecel "
un4amentals an4 Cartin+!
•"#$ %#$E C&'SSES ( S )
• ***.bis155+enius.com
•,
•,
• -ee 1 Jui9•
• ()C# 1! -ic of te follo*in+ 4escribes te function of te "ormula Bar (as it applies to Ecel 2010!K (oints : 2!
• ()C# 1! -ic of te follo*in+ best 4escribes a cell a44ressK (oints : 2!
• ()C# 1! If ou *ante4 to insert te current 4ate into an active cell= *ic of te follo*in+ *oul4 ou useK (oints : 2!
• ()C# 1! In Ecel a "ormula is . (oints : 2!
•
()C# 1! -ic of te follo*in+ 4escribes te 'uto "ill in Ecel 2010K (oints : 2!
http://www.bis155genius.com/http://www.bis155genius.com/
8/18/2019 BIS 155 Professional Tutor Bcom230mart.com
11/17
IS 155 -ee 2 Jui9 (Ecel s
'4vance4 "ormulas
•"#$ %#$E C&'SSES ( S )
• ***.bis155+enius.com
•,
•,
• -ee 2 Jui9• ()C# 2! 'n absolute cell reference: (oints : 2!
• ()C# 2! -ic of te follo*in+ best 4escribes a circular referenceK(oints: 2!
• ()C# 2! LHE2>MH8 contains eamples of cell references. (oints: 2!
• ()C# 2! In Ecel= an 'r+ument *oul4 be best 4escribe4 b *ic ofte follo*in+ statementsK (oints: 2!
http://www.bis155genius.com/http://www.bis155genius.com/
8/18/2019 BIS 155 Professional Tutor Bcom230mart.com
12/17
IS 155 -ee 3 Jui9 (Data '
nalsis "unctions! (Devr!
•"#$ %#$E C&'SSES ( S )
• ***.bis155+enius.com
•,
•,
• -ee 3 Jui9• ()C# 8! If tere are certain columns of information tat are not ne
e4e4 at a particular time but mi+t be nee4e4 later= te unnee4e4 columns to allo* users to focus on onl te essential information. (oints:2!
• ()C# 8! In Ecel= te print area is 4efine4 as . (oints : 2!• ()C# 8! -en sortin+ in Ecel= it arran+es recor4s in a table .
(oints : 2!
• ()C# 8! "ilterin+ te Cost column (fiel4! to so* onl recor4s +reater tan H10=000 is.......
http://www.bis155genius.com/http://www.bis155genius.com/
8/18/2019 BIS 155 Professional Tutor Bcom230mart.com
13/17
IS 155 -ee 8 Jui9 (#ffice I
nte+ration an4 %ail %er+e!
•"#$ %#$E C&'SSES ( S )
• ***.bis155+enius.com
•,
•,
• -ee 8 Jui9• ()C# ! -ic of te follo*in+ is one of te most common file tpe
s importe4 into EcelK (oints : 2!
• ()C# ! -ic of te follo*in+ is @#) a tet fileK (oints : 2!
• ()C# ! -ic of te follo*in+ is @#) a meto4 for refresin+ 4ataK (oints : 2!
• ()C# ! )e Convert )et to Columns -i9ar4 allo*s ou to coose te file tpe= suc as Delimite4(oints:2!
http://www.bis155genius.com/http://www.bis155genius.com/
8/18/2019 BIS 155 Professional Tutor Bcom230mart.com
14/17
IS 155 -ee 5 Jui9 (Consoli
4atin+ Data
•"#$ %#$E C&'SSES ( S )
• ***.bis155+enius.com
•,
•,
• -ee 8 Jui9• ()C# ! -ic of te follo*in+ is one of te most common file tpe
s importe4 into EcelK (oints : 2!
• ()C# ! -ic of te follo*in+ is @#) a tet fileK (oints : 2!
• ()C# ! -ic of te follo*in+ is @#) a meto4 for refresin+ 4ataK (oints : 2!
• ()C# ! )e Convert )et to Columns -i9ar4 allo*s ou to coose te file tpe= suc as Delimite4(oints:2!
http://www.bis155genius.com/http://www.bis155genius.com/
8/18/2019 BIS 155 Professional Tutor Bcom230mart.com
15/17
IS 155 -ee Course roe
ct Ecel roect (Devr!
•"#$ %#$E C&'SSES ( S )
• ***.bis155+enius.com
•,
•,
• #bective• )e +eneral instructions for tis proect can be foun4 in te -ee
&ecture material. )e -ee &ecture 4escribes te assi+nment an4 provi4es an overvie* of te proect as a *ole. )ere are no step>b>steps for te course proect. )e follo*in+ are +ra4in+ criteria
for tis proect.
http://www.bis155genius.com/http://www.bis155genius.com/
8/18/2019 BIS 155 Professional Tutor Bcom230mart.com
16/17
IS 155 -ee "inal Eam
(Devr!
•"#$ %#$E C&'SSES ( S )
• ***.bis155+enius.com
•,
•,
• ()C# 1! ;ou *or for a local construction firm= ADer En+ineerin+MroupA an4 our supervisor *ants to test our no*le4+e an4 sills *it %icrosoft Ecel an4 as instructe4 ou to 4evelop a sprea4seet to calculate *eel paroll for N15O emploees *it te follo*in+ assumptions:....... (oints : 80!
http://www.bis155genius.com/http://www.bis155genius.com/
8/18/2019 BIS 155 Professional Tutor Bcom230mart.com
17/17
IS 155 professional tutor/bc
om230mart.comFOR MORE CLASSES VISIT
www.bis155genius.com
http://www.bis155genius.com/http://www.bis155genius.com/