Class - 9 :: Chapter 4

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

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

1) hryk nvIN bxweI geI vrkbu`k iv`c pihlW qoN bxIAw ........... vrkSItW Swiml huMdIAW hn[

1) 5

2) 2

3) 3

4) 255

2) vrkSIt v`c ikhVy-ikhVy AwbjYkt Swiml kIqy jw skdy hn?

1) sY`l (Cells)

2) cwrts (Charts)

3) roAz (Rows)

4) auprokq swry

3) iehnW ivcoN ikhVIAW AY`m.AY`s. AYksl dIAW shI tweIps hn[

1) srPys (Surface), rfwr , (Radar), bwr (bar)

2) bwr (bar), kwlm (Column), pweI (Pie), leIn

3) eyrIAw (Are), font (Doughtnut), skYtr (Scatter)

4) auprokq swry

4) iksy id`qI geI ryNj iv`c sB qoN Cotw nMbr pqw krn leI ikhVw PMkSn vriqAw jWdw hY[

1) AVERAGE

2) MIN

3) MAX

4) RANK

5) .......... AYm.AY`s. AYksl iv`c ilKy fwty dI gRwPIkl pySkwrI leI vriqAw jWdw aupXogI tUl hY[

1) fwtw vYlIfySn (data Validadation)

2) kMfISnl PwrmYitMg (Condidtional Formatting)

3) cwrts (Charts)

4) iehnW ivcoN koeI nhIN

ਸਹੀ ਗਲਤ

1) kIborf qoN Ctrl Aqy + kIA dI vrqoN krky nvW sY~l, roA jW kwlm dw^l kIqw jw skdw hY[

au`qr : shI

2) SUM Aqy MIN AY~m. AY~s. AYksl iv~c cwrt dIAW iksmW dIAW audwhrxW hn[

au`qr : Zlq

3) sY~l bwrfr, sY~l dI cOVweI jW aucweI bdlxw, sY~lW ƒ mrz krnw, tYkst ƒ AlweIn (Ailgn) krnw, tYkst dI idSw bdlxw, tYkst ƒ rYp (Wrap) krnw Awid sY~l stweIl dIAW audwhrxW hn[

au`qr : shI

4) kMfISnl PwrmYitMg AY~m. AY~s. AYksl dw ie~k tUl/kmWf hY jo mu~l dy ADwr qy sY~lW dI ryz iv~c PwrmYt lwgU krn leI vriqAw jWdw hY[

au`qr : shI

5) PwrmYitMg AwpSnj fwtw qoN jwxkwrI ƒ drswaux leI bhuq pRBwvSwlI hn[

au`qr : shI

ਛੋਟੇ ਪ੍ਰਸ਼ਨ

1) PwrmYitMg qoN quhwfw kI Bwv hY?

au`qr : PwrmYitMg dI vrqoN nwl fwtw dI id~K iv~c qbdIlI krn leI kIqI jWdI hY[ PwrmYitMg krn nwl swfw fwtw vDyry pVHnXog bx jWdw hY[ AsIN fwtw ƒ keI qrIikAW nwl PwrmYt kr skdy hW[ AYksl iv~c bhuq swry Aijhy tUl hn jo tYkst Aqy sY~lW ƒ PwrmYt krn leI vrqy jw skdy hn[ audwhrx leI: tYkst Aqy sY~lW dw rMg Aqy stweIl bdlxw, tYkst ƒ AlweIn krnw, nMbrW Aqy imqIAW ƒ PwrmYt krnw Awid[

2) sY~l stweIl dy qOr qy iks iksm dI PwrmYitMg vrqI jw skdI hY?

au`qr :

sY~l stweIl dy qOr qy hyTW idqIAW v~K-v~K iksmW dI PwrmYitMg kIqI jw skdI hY:

1. sY~l bwrfr sYt krnw

2. tYkst ƒ AlweIn krnw

3. tYkst dI idSw (Text Orientaiton) bdlxw

4. rYipMg (Wrapping) tYkst

5. nMbr PwrmYt lwgU krnw

3) mrijMg sY~l qoN quhwfw kI Bwv hY?

au`qr :

mrijMg sY~lz dw mqlb hY do jW do qoN v~D sY~lW ƒ joV ky ie~k sY~l bxwauxw[AsIN Awieqwkwr bxwaux vwly iksy vI sY`l nUM mrz kr skdy hW[ sY~lW ƒ mrj krn leI AsIN AYksl dI Home tYb iv~c auplbD 'Merge & Center’ AwpSn dI vrqoN kr skdy hW[

4) AlweInmYNt Aqy ies dIAW iksmW dI ivAwiKAw kro[

au`qr : AlweInmYNt sY~lW leI iek PwrmYitMg stweIl hY[sY~l dy tYkst ƒ lytvIN Aqy KVHvIN idSw ivc AlweIn kIqw jw skdw hY[ AYksl dy Home tYb iv~c Alignment sbMDI AwpSnW auplbD hn[ ie~k sY~l iv~c fwtw ƒ lytvIN idSw ivc AlweIn krn leI AsIN lYPt AlweIn, sYNtr AlweIn Aqy rweIt AlweIn AwpSnW dI vrqoN kr skdy hW, jdoN ik KVHvIN AlweInmYNt leI AsIN twp, imfl Aqy bwtm AlweIn AwpSnW dI vrqoN kr skdy hW[

5) cwrts kI huMdy hn?

au`qr :

cwrt AYksl dI ie~k mh~qvpUrn ivSySqw hY[ fwtw ƒ gRwiPkl rUp iv~c drswaux leI cwrt dI vrqoN kIqI jWdI hY[ fwtw ƒ vDIAw qrIky nwl smJx leI cwrt bhuq lwBdwiek huMdy hn[ mu~lW dI qulnw krn leI jW fwtw iv~c ruJwn idKwaux leI cwrt sB qoN vDIAw qrIkw huMdy hn[ AsIN AYksl iv~c keI qrHW dy cwrt bxw skdy hW, ijvyN: pweI cwrt, kwlm cwrt, lweIn cwrt, bwr cwrt, eyrIAw cwrt Awid[

ਵੱਡੇ ਪ੍ਰਸ਼ਨ

1) kMfISnl PwrmYitMg kI hY? ies dIAW v~K-v~K AwpSnj dI ivAwiKAw kro[

au`qr :

kMfISnl PwrmYitMg AYksl dw ie~k mh~qvpUrn tUl hY[ jo inrDwirq SrqW Aqy mu`l dy ADwr qy sY`l jW sY`lW dI SRyxI iv`c ivSyS PwrmYt lwgU krn dy Xog bxwauNdw hY[ sY~lW aupr PwrmYitMg aus smyN hI lwgU hovygI jdoN sY~l ivclw fwtw kMfISnl PwrmYitMg iv~c idqI geI kMfISn nwl myl KWdw hovy[ kMfISnl PwrmYitMg AwpSn Home tYb iv~c auplbD hY[ kMfISnl PwrmYitMg dIAW kuJ Awm AwpSnW hyTW idqIAW geIAW hn:

1. Highlight Cell Rules: ijvyN ik Greater Than, Less Than, Between, Equal to, Duplicate Values Awid[

2. Top/Bottom Rules: ijvyN Top 10 Items, Bottom 10 Items, Above average Awid[

3. New Rule: ies AwpSn dI vrqoN krky AsIN kMfISnl PwrmYitMg leI nvW inXm vI bxw skdy hW[

4. Clear Rules: ies AwpSn dI vrqoN krky AsIN sY~lW aupr pirBwiSq PwrmYitMg inXmW ƒ klIAr kr skdy hW[

5. Manage Rules: ies AwpSn dI vrqoN krky sY~lW 'qy pihlW qoN lwgU PwrmYitMg inXmW ƒ AYift kr skdy hW[

2) cwrts kI hn? iksy pMj iksmW dy cwrts dy nW ilKo[

au`qr :

• pweI cwrt

• kwlm cwrt

• lweIn cwrt

• bwr cwrt

• eyrIAW cwrt Awid[

3) AY~m. AY~s. AYksl iv~c dwKl kIqy jw skx vwly iksy iqMn AwbjYkts (Objects) dI ivAwiKAw kro[

au`qr :

AYksl vrkSIt iv~c keI qrHW dy AwbjYkts dwKl kIqy jw skdy hn[ auhnW iv~coN kuJ dI ivAwiKAw hyTW id~qI geI hY:

1. roAz ƒ dwKl krnw: vrkSIt iv~c sY~lW dIAW lytvIAW lweInW ƒ roAz ikhw jWdw hY[ AsIN SIt iv~c AwswnI nwl nvIAW roAz dwKl kr skdy hW[ nvIN roA dwKl krn leI Home tYb irbn qoN Insert → "Insert sheet rows" aupr kil~k kro[

2. kwlm ƒ dwKl krnw: vrkSIt iv~c sY~lW dIAW KVvIAW lweInW ƒ kwlm ikhw jWdw hY[ AsIN SIt iv~c AwswnI nwl nvW kwlm dwKl kr skdy hW[ nvW kwlm dwKl krn leI Home tYb irbn qoN Insert → "Insert sheet columns" aupr kil~k kro[

3. cwrt dwKl krnw: fwtw ƒ gRwiPkl rUp iv~c drswaux leI cwrt dI vrqoN kIqI jWdI hY[ AYksl iv~c v~K-v~K qrHW dy cwrt AwswnI nwl bxwey jw skdy hn, ijvyN ik: bwr, kwlm, pweI, lweIn, eyrIAw, font Awid[ AYksl iv~c cwrt bxwaux leI Insert tYb dI vrqoN kIqI jWdI hY[