MICROSOFT WORDS, POWERPOINT, EXCEL

END USER APPLICATIONS COURSE CODE :

ASM452 EXAMINA TION :

DECEMBER 2018 TIME :

3 HOURS I N STR UCTIO NS T O C ANDID ATE S 1 .

T his te st c o nsis ts o f T H REE ( 3 ) p arts :

P A R T A ( 1 5 Q uestio ns) P A R T B ( Q uestio ns) P A R T C ( Q uestio ns) 2 .

F ollo w a ll th e in str u ctio ns g iv e n in th e q uestio ns.

3 .

S ubm it a ll th e th re e file s fr o m W ord , E xce l a nd P ow erP oin t t o y o ur r e sp ectiv e le ctu re rs . N AM E: … …………………………………… ………………………………..

S TU DEN T ID : … …………………………………………………………….

G RO UP: … ………………………………………………………………….. 1 C O NFID EN TIA L B A/D EC 2 018/A SM 452/T E ST P A RT A : M IC RO SO FT W ORD ( 3 0 M AR KS) 1 . O pen a n ew W ord d ocu m ent a nd th en s a ve th e file a s H O T W ord ( Y our N am e). 2 . T yp e th e fo llo w in g d ocu m ent: ( 3 m ark s) 3 . I n clu de C lo ud S to ra ge a s th e tit le fo r th e r e se arc h p aper. C ente r a nd b old th e tit le . ( 2 m ark s) 4 . C hange th e r ig ht m arg in to 1 in ch a nd th e le ft m arg in t o 1.5 in ch es. ( 2 m ark ) 5 . F orm at th e e ntir e d ocu m ent to 1 2-p oin t T im es N ew R om an f o nt. ( 1 m ark ) 6 . F orm at th e e ntir e d ocu m ent u sin g d ouble lin e s p acin g. ( 1 m ark ) 7 . C re ate a h eader t h at i n clu des y o ur F ull N am e a nd S tu dent I D o n t h e l e ft s id e o f y o ur r e se arc h p aper a nd a dd t h e p age n um ber o n t h e r ig ht- h and c o rn er o f y o ur d ocu m ent f o ote r. C lo se th e H eader a nd F oote r to olb ar a nd s a ve y o ur w ork . ( 2 m ark s) 8 . I n se rt c it a tio n a t th e fo llo w in g p oin ts m ark e d ❶ , ❷ a nd ❸ r e sp ectiv e ly . 2 C O NFID EN TIA L B A/D EC 2 018/A SM 452/T E ST ❶ S o urc e : “ C lo ud S to ra ge a n d t h e I n te rn et,” a p erio dic a l a rtic le o n p age s 2 3-3 7 i n M arc h 2 0 16 i s su e o f I n te rn et U sa ge a nd T re n ds b y L e o na C arte r. ❷ Sou rc e : p ag es 2 2-2 8 i n a b ook c a lle d W ork in g w it h t h e I n te rn et: C lo u d S to ra g e b y R ob ert M . G a a n d J e ssic a T . F le m in g, p ub lis h ed a t J a n e L e w is P re ss i n N ew Y ork i n 2 014. ❸ S ou rc e : a W eb s it e t it le d T he I n te rn et: C lo u d S to ra g e b y R eb ecca A . F o rd a n d H arry I . G arla n d d ate d J a n uary 2 , 2 015, v ie w ed o n M arc h 7 , 2 015. ( 7 m ark s) 9 . C re ate a b ib lio gra phy p age a rra nged i n M LA s ty le . C onve rt t h e b ib lio gra phy f ie ld t o r e gula r te xt w it h th e s a m e fo nt a nd s iz e a s th e r e se arc h p aper. ( 3 m ark s) 1 0. C re ate th e ta ble a fte r th e s e co nd p ara gra p h u sin g t h e in fo rm atio n a s s h ow n b elo w : T ype Features Price/month Dropbox Business features including collaboration.

Referrals get you extra storage.

2GB free.

1TB for $10 with Dropbox Plus 2TB for $19.99 a month with Dropbox Professional Google Drive Generous amount of free storage.

Integrated with Android devices.

15GB free.

100GB for $1.99 a month 200GB for $2.99 a month 2TB for $9.99 a month 10TB for $99.99 a month Mega Easy-to-use UI Extremely generous free of fering Sync client is open source 50GB free.

200GB for $6 a month 1TB for $12 a month 4TB for $23 a month 8TB for $35 a month ( 3 m ark s) 1 1 . I n se rt o ne c o lu m n a fte r th e fir s t c o lu m n ( n am e th e c o lu m n a s F unctio ns ) a nd in se rt th e f o llo w in g in fo rm atio n : V ete ra n c lo ud s to ra ge p ro vid er A s m art o ptio n fo r G oogle fa ns a nd G S uit e u se rs P uts a p re m iu m o n s e cu rit y ( 2 m ark s) 1 2. C entr e a nd b old th e c o lu m n h eadin gs. F orm at th e ta ble u sin g s in gle lin e s p acin g. ( 2 m ark s) 1 3. A pply a ppro pria te fo rm at fo r “ T a ble S ty le ” fo r th e t a ble . ( 1 m ark ) 1 4. I n se rt T a ble 1 : C om paris o n o f C lo ud S to ra g e a t th e t o p o f th e ta ble . ( 1 m ark ) 1 5. S ave th e d ocu m ent. 3 C O NFID EN TIA L B A/D EC 2 018/A SM 452/T E ST M IC RO SO FT P O W ER PO IN T ( 3 0 M ARKS) 1 . C re ate n ew b la nk P ow erP oin t p re se nta tio n a nd t h e f ile a s H O T P ow erP oin t ( Y our N am e). 2 . A dd S lid e # 1 a nd c h oose t h e T it le S lid e L ayo ut a nd p ut t h e t it le o f “ H EAD IN G T O F IN AL E XAM ” a nd p ut y o ur n am e a nd s tu dent I D i n t h e s u btit le . I n cre ase t h e f o nt s iz e o f t h e t it le t e xt p ara gra ph, H eadin g t o F in al E xa m , t o 4 4 p oin t. I ta lic iz e y o ur n am e a nd y o ur s tu dent ID a nd in cre ase th e fo nt s iz e to 3 2 p oin t. ( 3 m ark s) 3 . A dd S lid e # 2 w it h T it le a nd C onte nt S lid e L ayo ut w it h b ulle te d l is ts , e nte r t h e f o llo w in g t e xt b elo w ; ● P la ce L ib ra ry , q uie t p la ce , g ood e nvir o nm ent. ● S ch ed ule S ta rt e arly in th e m orn in g, ta ke a b re ak e ve ry 1 h our. ● T e st T ry to a nsw er p ast y e ar q uestio ns ( 4 m ark s) 4 . A dd a tit le a s “ E AR LY P R EPA R AT IO N” in S li d e # 2 ( 1 m ark ) 5 . S earc h fo r c lip a rt im age o f “ s tu dent s tu dyin g” a nd i n se rt th e im age in S lid e # 2. ( 2 m ark s) 6 . I n se rt S lid e # 3 u sin g P ic tu re w it h C aptio n L ayo ut, e nte r th e fo llo w in g te xt b elo w ; B EFO RE F IN AL E XA M S le ep e arly B e e arly H ave a n utr it io us fo od B e c o nfid ent ( 3 m ark s) 7 . S earc h fo r c lip a rt im age a nd in se rt tw o im ag es r e la te d t o th e to pic in S lid e # 3. ( 2 m ark s) 8 . A dd a n ew S lid e # 4 w it h T it le a nd C onte nt S lid e L ayo ut; t y p e “ R O AD T O F IN AL E XAM ” a s t h e t it le . I n se rt a c lip a rt i m age o f “ s tu dent w earin g a m orta rb oard ” a nd e nte r t h e t e xt a s “ M y g ra duatio n d ay” b elo w th e im age. C ente r th e i m age a nd te xt o n th e s lid e. ( 3 m ark s) 4 C O NFID EN TIA L B A/D EC 2 018/A SM 452/T E ST 9 . A pply th e a ppro pria te D esig n T hem e fo r a ll s lid es. ( 1 m ark ) 1 0. U se “ R eve al” T ra nsit io n t o a ll s lid es a nd c h ange t h e a dva nce s lid e t im in g s e ttin g t o r u n a fte r 2 s e co nds. ( 3 m ark s) 1 1 . A pply “ B ounce ” E m phasiz e E ff e ct i n t h e A nim atio n G alle ry f o r a ll t h e t it le s o f t h e f o ur s lid es a nd c h ange th e s ta rt tim in g s e ttin g to W it h P re vio us w it h 2 5 s e co nds d ura tio n. ( 4 m ark s) 1 2. A pply ” W ave ” E ntr a nce E ff e ct i n t h e A nim atio n G alle ry f o r a ll t h e c o nte nts o f t h e f o ur s lid es a nd c h ange th e tim in g s e ttin g to A fte r P re vio us w it h 5 0 s e co nds d ura tio n. ( 4 m ark s) 1 3. S ave a nd c lo se th e file . 5 C O NFID EN TIA L B A/D EC 2 018/A SM 452/T E ST M IC RO SO FT E XC EL ( 4 0 M ARKS) Overview:

Y ou are a project manager for FBM Bowling T ournament 2018 .

As a project manager , you are required to do some calculation for reporting purposes by using Microsoft Excel. Instructions:

(1) Start Microsoft Excel and create new workbook. Save the workbook as HOT EXCEL (YOUR FULL NAME) (GROUP). (2) Enter the data given below into a worksheet. (3 marks) Name Game 1 Game 2 Game 3 Game 4 Game 5 1 Faradiyana Al Fateh 212 276 308 210 209 2 Mohd. Quddus Rasyid 1 15 175 1 12 131 125 3 Fatin Nabilla Ariffin 208 210 226 212 245 4 Syazana Soleh 178 206 215 189 169 5 Chuan Yi Min 271 288 291 276 278 6 Zakuan Isa 216 212 196 215 210 7 Andy Loga 196 188 216 192 208 8 Hasnan Zikry 218 215 231 226 212 Game 1 Game 2 Game 3 Game 4 Game 5 Highest Scor e:

Lowest Scor e:

A verage Scor e:

(3) Add a title to the chart as “ FBM BOWLING T OURNAMENT 2018 SCORE SHEET” (heading should be mer ged and centered, font size 16). (3 marks) (4) Change the first contestant score for Game 3 to 208 (1 mark) (5) Using the most appropriate formulas and functions; a. Find the highest score for each game b. Find the lowest score for each game 6 C O NFID EN TIA L B A/D EC 2 018/A SM 452/T E ST c. Find the mean score for each game d. Calculate the total pins for each contestant (8 marks) (6) Add new column before column “T otal Pins” and name the column heading as Highest Scoring Game . (1 mark) (7) Use appropriate formula to show the highest score received by each contestant. (2 marks) (8) Add new column name the column heading as Stage 2 Qualification . (1 mark) (9) Use IF function to determine stage 2 qualification if the “total pins” is more than 1000 by indicate “Y es” if the condition if met or leave as blank if the student is not qualified. (10 marks) (10) Sort the data according the “T otal Pins” in descending order . (2 marks) (1 1) Apply conditional formatting by changing the fill colour of the cell to “blue” if the individual score is more than 150. (3 marks) (12) Insert a clustered column chart in a new worksheet that display highest and lowest score for each game. (4 marks) (13) Add a title to the chart as “FBM Bowling T ournament Highest and Lowest Score in Comparison. (2 marks) (14) Save worksheet. E N D O F Q UESTIO N P A PER 7