?>

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

ਸਹੀ ਗਲਤ

AYkitv sY~l dw AYfrY~s hmySW nym bwks iv~c pRdriSq huMdw hY[

shI

AY~m. AY~s. AYksl dy swry kwlm 1 nwl SurU hox vwly nMbrW duAwrw drswey jWdy hn[

Zlq

PwrmUly vwlw sY~l hmySw PwrmUly dw nqIjw sY~l iv~c pRdriSq krdw hY jdoN ik PwrmUlw Kud PwrmUlw bwr iv~c pRdriSq huMdw hY[

shI

AY~m. AY~s. AYksl ie~k swDwrn qOr qy vriqAw jwx vwlw vrf pRosYsr hY[

Zlq

AsIN iP~l hYNfl dI vrqoN krdy hoey AY~m. AY~s. AYksl iv~c nMbr sIrIz Br skdy hW[

shI

ਛੋਟੇ ਪ੍ਰਸ਼ਨ

pRSn : AY`m. AY`s. AYksl ƒ pirBwSq kro[

auqr :
mweIkroswPt AYksl ie~k spRYfSIt pRogrwm hY[ ieh mweIkroswPt AwiPs dw iek Bwg hY[ iesdI vrqoN fwtw ƒ roAz Aqy kwlmW iv~c ivvsiQq krn Aqy gixiqk gxnwvW krn leI kIqI jWdI hY[ AsIN cwrt Aqy gRwPs dI vrqoN krky fwtw ƒ gRwiPkl rUp ivc vI drsw skdy hW[ AYksl iv`c bxweIAW geIAW PweIlW ƒ vrkbu`k ikhw jWdw hY[

pRSn : AY`m. AY`s. AYksl dy kI-kI aupXog hn?

auqr :
AY`m.AY`s. AYksl dy aupXog hyTW idqy Anuswr hn:
1) AYksl dI vrqoN gixiqk gxnwvW krn leI kIqI jw skdI hY[
2) cwrt dI vrqoN krky fwtw ƒ gRwiPkl rUp iv~c drswieAw jw skdw hY[
3) ies ivc AsIN skUl dI smW-swrxI vI iqAwr kr skdy hW[
4) krmcwrIAW dIAW qnKwhW dI gxnw kIqI jw skdI hY[
5) ividAwrQIAW dy nqIjy vI AYksl iv`c iqAwr kIqy jWdy hn[

pRSn : AY~m. AY~s. AYksl iv~c irbn dI ivAwiKAw kro[

auqr : irbn mweIkroswPt AYksl dw iek mh~qvpUrn Bwg hY[ ieh AYksl ivMfo dy auprly ih~sy ivc mOjUdw huMdw hY[ ieh kmWfz dI ie`k lVI hY jo hryk mInUM bwr dw ih`sw hY[ AYksl dIAW lgBg swrIAW kmWfW jo AsIN AYksl iv~c kMm krn dOrwn vrqdy hW, ies irbn aupr hI auplbD huMdIAW hn[ iehnW swrIAW kmWfW ƒ auhnW dy kMm dy AwDwr qy v~K-v~K tYbz  Aqy gru`p iv~c ivvsiQq kIqw igAw huMdw hY[

pRSn : nym bwks kI huMdw hY?

auqr : nym bwks AYksl iv~c PwrmUlw bwr dw ie~k ih~sw huMdw hY[ ieh PwrmUlw bwr dw sB qoN pihlw Bwg huMdw hY jo AYkitv sY~l dw AYfrYs idKwauNdw hY[

pRSn : AY`m AY`s AYksl iv~c roAz Aqy kwlmz dI ivAwiKAw kro[

auqr :
roAz: vrkSIt iv~c sY~lW dIAW lytvIAW lweInW ƒ roAz ikhw jWdw hY[ hryk roA nUM roA nMbr duAwrw drswieAw jWdw hY[ roAz dw nMbr 1,2,3,4, . . .  huMdw hY[ 
kwlm: vrkSIt iv~c sY~lW dIAW KVvIAW lweInW ƒ kwlm ikhw jWdw hY[ hryk kwlm dI pCwx kwlm hYfr duAwrw kIqI jWdI hY[ kwlmW ƒ A, B, C, D,. . . . , AA, AB, . . . nwm id~qw igAw huMdw hY[

ਵੱਡੇ ਪ੍ਰਸ਼ਨ

pRSn : AY`m. AY`s. AYksl vrkSIt dy mu~Fly kwrj kI hn?

auqr :
vrkSItW 'qy lwgU kIqy jwx vwly kuJ mu~Fly kwrj hyTW id~qy gey hn:
  1. nvIN vrkSIt dwKl krnw: vrkSIt dI vrqoN fwtw stor krn leI kIqI jWdI hY[ AsIN kIA borf dI Swrtk~t kIA Shift + F11 dI vrqoN krky AwswnI nwl nvIN vrkSIt dwKl kr skdy hW[
  2. vrkSIt dw nwm bdlxw: AsIN AYksl iv~c vrkSItW dw nwm vI bdl skdy hW[ SIt dw nwm bdlx leI, SIt lIP 'qy mwaUs dw rweIt kil~k kro  'Rename' AwpSn 'qy kil~k kro[
  3. vrkSIt ƒ iflIt krnw: jdoN iksy vrkSIt dI jrUrq nW hovy qW ausƒ iflIt vI kIqw jw skdw hY[ SIt ƒ iflIt krn leI, SIt lIP 'qy mwaUs dw rweIt kil~k kro 'Delete' AwpSn 'qy kil~k kro[
  4. vrkSIt ƒ kwpI krnw: AsIN mOjUdw vrkSIt dI kwpI krky fuplIkyt SIt vI iqAwr kr skdy hW[ SIt dI kwpI krn leI, SIt lIP 'qy mwaUs dw rweIt kil~k kro  'Move or Copy' AwpSn 'qy kil~k kro[

pRSn : vrkbu~k Aqy vrkSIt dy iv~c AMqr ilKo[

auqr :
vrkbu~k Aqy vrkSIt dy iv~c AMqr  hyT ilKy Anuswr hY:-

vrkSIt

1. vrkSIt AY`m. AY`s. AYksl dI spRYfSIt nUM drswauNdI hY[ ijs iv`c roAz Aqy kwlm Swiml huMdy hn

2. vrkSIt isMgl pyz sprYfSIt huMdI hY[

3.vrkbu`k qoN ibnw koeI vI vrkSIt syv nhIN kIqI jw skdI [

vrkbu`k

1.vrkbu`k AY`m. AY`s. AYksl iv`c bxweI geI PweIl huMdI hY ijs iv`c keI vrkSItW swiml ho skdIAW hn[

2. vrkbu`k iv`c ie`k jW ie`k qoN v`D vrkSItW swiml ho skdIAW hn[

3. hryk vrkbu`k .xlsx AYkstYNSn nwl syv kIqI jWdI hY[


pRSn : AY~m. AY~s. AYksl dIAW ivSySqwvW bwry d~so[

auqr :
mweIkroswPt AYksl dIAW kuJ mu~K ivSySqwvW ies pRkwr hn:
  1. Awswn fwtw ivSlySx: AYm.AYs. AYksl fwtw dw AwswnI nwl ivSlySx krn leI bhuq hI au~nq tUl pRdwn krdw hY - ijvyN ik sOritMg, iPltirMg Awid[
  2. kMfISnl PwrmYitMg: AsIN v~K-v~K inXmW Aqy SrqW Anuswr Awpxy fwtw ƒ PwrmYt kr skdy hW[
  3. fwtw vylIfySn: ieh swƒ kuJ mwpdMfW dy ADwr qy fwtw ƒ pRmwixq krn Xog bxwauNdw hY[ 
  4. fwtw nUM stor krn Aqy l~Bx iv`c AswnI : AsIN vrkSItW iv~c AwswnI nwl fwtw stor kr skdy hW Aqy l~B skdy hW[
  5. PMkSn Aqy PwrmUly: AYksl gxnwvW krn leI keI qrHW dy PMkSn Aqy PwrmUly pRdwn krdw hY[
  6. fwtw pRotykSn: AYksl dIAW SItW ƒ pwsvrf dI vrqoN krky sur~iKAq kIqw jw skdw hY[

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

……… do jw do qo v~D kMipautrw dw ie~kT huMdw hY [

w

ਸ਼ਾਰਟਕੱਟ ਕੀਅ

AY~m. AY~s. AYksl iv~c koeI pihlW bxI Pwiel Kolx leI .............

Ctrl + O

AY~m. AY~s. AYksl iv~c Pwiel ƒ syv krn leI ……………

Ctrl + S

AY~m. AY~s. AYksl iv~c nvIN Pwiel bxwaux leI …………

Ctrl + N

AY~m. AY~s. AYksl iv~c fwaUn iPl krn leI …………

Ctrl + D

AY~m. AY~s. AYksl iv~c rweIt iPl krn leI ............

Ctrl + R

AY~m. AY~s. AYksl iv~c kwpI krn leI ................

Ctrl + C

AY~m. AY~s. AYksl iv~c pyst krn leI ................

Ctrl + V
?>