BIS 155 Professional Tutor Bcom230mart.com

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/


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



3/17

IS 155 &ab 1 of Sa44le $iv

er %arcin+ an4 (Devr!

•"#$ %#$E C&'SSES ( S )


•,

•,

• &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



4/17

IS 155 &ab 2 of Ecel6s '4

vance4 "ormulas 7 "unctions

•"#$ %#$E C&'SSES ( S )


•,

•,

• 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.



5/17

IS 155 &ab 3 of 'lice arr

$ealt 'nalsis (Devr!

•"#$ %#$E C&'SSES ( S )


•,

•,

• &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.



6/17

IS 155 &ab 8 of Create '4

4ress &abels (Devr!

•"#$ %#$E C&'SSES ( S )


•,

•,

• 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



7/17

IS 155 &ab 5 of runo6s i

99a 'nalsis (Devr!

•"#$ %#$E C&'SSES ( S )


•,

•,

• )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.



8/17

IS 155 &ab of Da Care

Center (Devr!

•"#$ %#$E C&'SSES ( S )


•,

•,

• ;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.



9/17

IS 155 &ab of 'ccess Dat

abase (Devr!

•"#$ %#$E C&'SSES ( S )


•,

•,

• 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.



10/17

IS 155 -ee 1 Jui9 (Ecel "

un4amentals an4 Cartin+!

•"#$ %#$E C&'SSES ( S )


•,

•,

• -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!



11/17

IS 155 -ee 2 Jui9 (Ecel s

'4vance4 "ormulas

•"#$ %#$E C&'SSES ( S )


•,

•,

• -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!



12/17

IS 155 -ee 3 Jui9 (Data '

nalsis "unctions! (Devr!

•"#$ %#$E C&'SSES ( S )


•,

•,

• -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.......



13/17

IS 155 -ee 8 Jui9 (#ffice I

nte+ration an4 %ail %er+e!

•"#$ %#$E C&'SSES ( S )


•,

•,

• -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!



14/17

IS 155 -ee 5 Jui9 (Consoli

4atin+ Data

•"#$ %#$E C&'SSES ( S )


•,

•,

• -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!



15/17

IS 155 -ee Course roe

ct Ecel roect (Devr!

•"#$ %#$E C&'SSES ( S )


•,

•,

• #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.



16/17

IS 155 -ee "inal Eam

(Devr!

•"#$ %#$E C&'SSES ( S )


•,

•,

• ()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!



17/17

IS 155 professional tutor/bc

om230mart.comFOR MORE CLASSES VISIT

www.bis155genius.com

BIS 155 Professional Tutor Bcom230mart.com

Documents

Transcript of BIS 155 Professional Tutor Bcom230mart.com