Class - 9 :: Chapter 6

ਮਾਈਕਰੋਸਾਫ਼ਟ ਐਕਸਲ (ਭਾਗ-4)

ਬਹੁ ਚੋਣਵੇਂ ਪ੍ਰਸ਼ਨ

1) iehnW ivcoN ikhVI AwpSn pyj lyA Awaut tYb (Page Layout Tab) nwl sbMiDq hY?

1) pyj ErIAYNtySn (Page Orientation)

2) pypr sweIz (Paper Size)

3) ipMRt eyrIAw (Print Area)

4) auprokq swry

2) iehnW ivcoN ikhVw AYm.AY`s AYksl dw ivaU nhIN hY?

1) PwrmUlw ivaU (Formula View)

2) nwrml ivaU (Normal View)

3) pyj lyA AwaUt ivaU (Page Layout View)

4) pyj bRyk pRIivaU (Page Break Preview)

3) ............. vrkSIt fwtw Aqy ipRMt kIqy jwx vwly pyj dy iknwirAW dy ivckwr dI KwlI QW huMdI hY[

1) pypr swiez (Paper Size)

2) ipMRt eyrIAw (Print Area)

3) mwrzn (Margin)

4) ipMRt pRIivaU (Print Preview)

4) AsIN Awpxy sY`lW nUM ............ AwpSn dI shwieqw nwl glqI nwl hox vwly bdlwv qoN rok skdy hW[

1) syv AYz (Save As)

2) syv (Save)

3) ipRMt eyrIAw (Print Area)

4) pRotYkt SIt (Protect Sheet)

5) ........... ipRMt pRIivaU Aqy ipRMt hoeIAW SItW hryk pMny dw isKr qy idKweI idMdw hY[

1) Pu`tr (Footer)

2) hY`fr (Header)

3) hyTlI mwrzn (Bottom Margin)

4) iehnW ivcoN koeI nhI

ਸਹੀ ਗਲਤ

1) AY~m. AY~s. AYksl iv~c vrkbu~k ƒ pRotYkt nhIN kIqw jw skdw[

au`qr : Zlq

2) ie~k vwr pyj bRyk dw^l krn qoN bwAd AsIN ausƒ htw nhIN skdy[

au`qr : Zlq

3) pyj ErIAYNtySn do pRkwr dy huMdy hn: portryt Aqy lYNfskyp[

au`qr : shI

4) mwrzn ie~k pyj dy au~pr, hyTW, K~by, s~jy, hY~fr Aqy Pu~tr qy ho skdIAW hn[

au`qr : shI

5) AsIN vrkSIt dy iksy Kws ih~sy ƒ ipRMt krn leI ipRMt eyrIAw AwpSn dI vrqoN kr skdy hW[

au`qr : shI

ਛੋਟੇ ਪ੍ਰਸ਼ਨ

1) mwrzn qoN quhwfw kI Bwv hY?

au`qr :

mwrzn vrkSIt fwtw Aqy ipRMt kIqy pyj dy K`by, s`jy, au`pr Aqy hyTly iknwirAW dy ivckwr KwlI jgHw huMdI hY[ AsIN XUzr dy fwtw dIAW swrIAW idSwvW dI mwrzn Gtw vDw skdy hW[AsIN AwpxI jrUrq Anuswr mwrzn nUM GtwA jW vDwA vI skdy hW[

2) pyj ErIAYNtySn au~pr ie~k not ilKo[

au`qr :

pyz ErIAYNtySn dsqwvyz dI aus idSw ƒ drswauNdw hY ijs ausƒ ipRMt kIqw jWdw hY[ AsIN Awpxy pyz ƒ jW qW lytvIN jW KVvIN idSw iv~c sY~t kr skdy hW[ AsIN Page Layout tYb dI vrqoN krky dsqwvyz dI ErIAYNtySn ƒ bdl skdy hW[AY`m. AY`s. AYksl swfy leI do pyz ErIAYNtySn pRdwn krdw hY:

lYNfskyp ErIAYNtySn: ieh ErIAYNtySn dsqwvyz ƒ lytvIN idSw iv~c pirBwiSq krdI hY[

portryt ErIAYNtySn: ieh ErIAYNtySn dsqwvyz ƒ KVvIN idSw iv~c pirBwiSq krdI hY[

3) AY~m. AY~s. AYksl dy ivaUz dy nW ilKo[

au`qr :

AYksl ivc pMj v~K-v~K iksmW dy ivaU auplbD hn, ijhnW dy nW hyTW idqy gey hn:

1. nwmrl ivaU (Normal View)

2. pyz lyAwaUt ivaU (Page Layout View)

3. pyz bRyk pRIivaU (Page Break Preview)

4. kstm ivaU (Custom View)

5. Pu~l skRIn ivaU (Full Screen View)

4) skyilMg qoN qusIN kI smJdy ho?

au`qr :

skyilMg dI vrqoN nwl AsIN SIt dy kMtYNts ƒ iksy Kws pMny/pMinAW 'qy ipMRt kIqy jwx vwly fwtw dw Awkwr v`fw jW Cotw kr skdy hW[ ieh AwpSn aus smyN bhuq aupXogI huMdI hY jdoN AsIN ie~k v~fI vrkSIt 'qy kMm kr rhy huMdy hW[ ies AwpSn dI vrqoN krky AsIN vrkSIt dy swry kMtYNts ƒ ie~k pyz aupr AYfjst kr skdy hW[ iesy qrHW jykr SIt aupr kMtYNts G~t hox qW ausƒ keI pMinAW 'qy vI PYlwieAw jw skdw hY[

5) pyj bRyk dI kI vrqoN huMdI hY?

au`qr :

pyz bRyk AYksl ivc ie~k mh~qvpUrn AwpSn hY[ ieh ie~k ivSyS mwrkr huMdw hY jo mOjUdw pyz ƒ Kqm krdw hY Aqy ie~k nvW pyz SurU krdw hY[ jykr AsIN cwhuMdy hW ik swfI SIt dy kMtYNts ƒ v~K-v~K pyjW iv~c ipRMt kIqw jwvy qW ieh AwpSn bhuq aupXogI is~D huMdI hY [ ieh AwpSn Page Layout tYb a`upr auplbD huMdI hY[ pyz bRyk hmySw AYkitv sY~l dy au~prly K~by kony qoN SurU huMdw hY[

ਵੱਡੇ ਪ੍ਰਸ਼ਨ

1) pyj lyA-AwaUt qoN quhwfw kI Bwv hY? koeI iqMn pyj lyA-AwaUt AwpSnj dI ivAwiKAw kro[

au`qr :

pyz lyA-Awaut ie~k pyz aupr tYkst, qsvIrW Aqy hor EbjYkts dy pRbMD ƒ drswauNdw hY[ AYksl iv~c pyj lyAwaut AwpSn mu~K qOr 'qy swfI vrkSIt dI ipRMitMg nwl sbMDq hY[ Page Layout tYb swfy pyj dw lyAwaUt (FWcw) bdlx sMbMDI AwpSnW pRdwn krdw hY:

ErIAYNtySn: pyz ErIAYNtySn dsqwvyz dI aus idSw ƒ drswauNdw hY ijs iv~c ausƒ skRIn aupr pRdriSq kIqw jWdw hY jW ausƒ ipRMt kIqw jWdw hY[ AsIN Awpxy pyz ƒ jW qW lytvIN (lYNfskyp) jW KVvIN (portryt) idSw iv~c sY~t kr skdy hW[

mwrjn: pyz dI mu~K sm~grI Aqy iesdy iknwirAW ivckwr KwlI Kyqr ƒ mwrijn ikhw jWdw hY[ AsIN ie~k pyz dIAW cwry idSwvW – twp, bwtm, K~by Aqy s~jy iv~c mwrijn sY~t kr skdy hW[

skyilMg: skyilMg SIt dy kMtYNts ƒ kMprY~s krn jW aus ivc PYlwE krn dI pRikirAw hY[ iesdI vrqoN nwl AsIN SIt dy kMtYNts ƒ iksy Kws pMny/pMinAW 'qy AYfjst kr skdy hW[ ieh AwpSn aus smyN bhuq aupXogI huMdI hY jdoN AsIN ie~k v~fI vrkSIt 'qy kMm kr rhy huMdy hW[

2) AY~m. AY~s. AYksl dy koeI do ivaUz dI ivAwiKAw kro[

au`qr :

AYksl iv~c ivaU AwpSn swfy kwrj Kyqr nUM dyKx dw qrIky inrDwirq krdIAW hn[ Awm qOr 'qy vrqy jWdy ivaUz dw vrnx hyTW id`qy Anuswr hY:

1. nwrml (Normal) ivaU: ieh AYksl dw ie~k ifPwlt ivaU hY[ jdoN AsIN AYksl KolHdy hW, qW swfI PweIl Awpxy Awp Awm ies ivaU iv~c idKweI idMdI hY[ ieh ivaU fwtw pRbMDn, PwrmUly/PMkSnW dI vrqoN krn Aqy roAz/kwlmW ƒ PwrmYt krn ivc shwiek huMdw hY[ AsIN View tYb dI vrqoN nwl Normal ivaU dI vrqoN kr skdy hW[

2. pyz bRyk pRIivaU (Page Break Preview): ieh ivaU mu~K qOr 'qy vrkSIt dI ipRMitMg nwl sbMDq hY[ ieh ivaU bhuq SkqISwlI ipRMt-pRIivaU hY[ ies ivaU ivc AsIN pyj-bRyk ƒ Awpxy Anuswr mUv kr skdy hW Aqy vrkSIt ivc pyjW ƒ ipRMitMg leI punrgiTq (reorganize) kr skdy hW[ AsIN View tYb dI vrqoN nwl Page Break Preview dI vrqoN kr skdy hW[

3) hY~fr Aqy PU~tr kI huMdw hY? AYksl iv~c hY~fr Aqy Pu~tr ikvyN lwgU kIqy jw skdy hn?

au`qr :

hY~fr Aqy Pu~tr vrkSIt dy mh~qvpUrn Bwg huMdy hn[ hY~fr Aqy Pu~tr Awm qOr qy auh tYkst huMdw hY jo hryk pyz dy au~pr (hY~fr) Aqy hyTW (Pu~tr) ipRMt kIqw jWdw hY[ ieh AwpSn iksy mh~qvpUrn jwxkwrI - ijvyN ik pyz nMbr, PweIl dw nwm Awid ƒ hryk pyz aupr drswaux leI bhuq aupXogI huMdI hY[ hY~fr Aqy Pu~tr ƒ lwgU krn leI hyTW id~qy stYps dI vrqoN kIqI jw skdI hY:

1. Page Layout tYb 'qy kil~k kro[

2. Page Setup gru~p iv~c lWcr AweIkn 'qy kil~k krky Page Setup fwielwg bwks KolHo[

3. ies fwielwg bwks iv~c, Header/Footer tYb 'qy kil~k kro[

4. FukvIAW AwpSnW dI vrqoN krky hY~fr Aqy PU~tr dy vyrvy sYt kro[

5. OK btn 'qy kil~k kro[