?>

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

ਸਹੀ ਗਲਤ

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

Zlq

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

Zlq

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

shI

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

shI

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

shI

ਛੋਟੇ ਪ੍ਰਸ਼ਨ

pRSn : mwrzn qoN quhwfw kI Bwv hY?

auqr :
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[

pRSn : pyj ErIAYNtySn au~pr ie~k not ilKo[

auqr :
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[

pRSn : skyilMg qoN qusIN kI smJdy ho?

auqr :
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[ 

pRSn : AY~m. AY~s. AYksl dy ivaUz dy nW ilKo[

auqr :
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)

pRSn : pyj bRyk dI kI vrqoN huMdI hY?

auqr :
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[

ਵੱਡੇ ਪ੍ਰਸ਼ਨ

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

auqr :
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[

pRSn : AY~m. AY~s. AYksl dy koeI do ivaUz dI ivAwiKAw kro[

auqr :
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[

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

auqr :
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[

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

gmail ………… dI ie~k muPq eI-myl syvw hY [

w
?>