Class - 9 :: Chapter 5

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

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

1) AYm.AYs. AYksl iv`c hryk PwrmUlw jW PMkSn ........... icMnH nwl SurU hoxw lwzmIN huMdw hY

1) +
2) =
3) &
4) ^

2) AYm.AYs. AYksl dw ikhVw PMkSn sY`lw dy smUh ivcoN sB qoN Cotw nMbr pqw krn leI vriqAw jWdw hY?

1) MINIMUM
2) MID
3) MIN
4) iehnW ivcoN koeI nhIN

3) AY`m. AY`s. AYksl iv`c AYNprsYNf (&) icMnH ikhVy PMkSn dw bdlvW ivklp hY?

1) SUM
2) AND
3) CONCATENATE
4) POWER

4) AYm.AY`s.AYksl dw ikhVw tUl iksy kwlm ivcoN kyvl ivl`Kx mu`l pqw krn leI vriqAw jWdw hY[

1) fwtw vYlIfySn
2) tYkst tU kwlm
3) PwrmUlw
4) irmUv fuplIkyt

5) iehnW ivcoN ikhVw ArQmYitk Eprytr dI audwhrx hY[

1) +
2) %
3) ^
4) auprokq swry
ਸਹੀ ਗਲਤ

1) AsIN AY~m. AY~s. AYksl iv~c KwlI sY~l nhIN igx skdy[

au`qr : Zlq

2) PwrmUlw Eprytrz Aqy EprYNfz nwl bxI ie~k AYkspRySn huMdI hY jo gxnwvW krn leI pRXog kIqI jWdI hY[

au`qr : shI

3) SUM PMkSn dI vrqoN iksy Kws ryNz iv~c joV pqw krn leI kIqI jWdI hY[

au`qr : shI

4) tYkst tU kwlm AwpSn dI vrqoN ie~k sY~l dy kMtYNts ƒ v~K v~K sY~lW iv~c vMfx leI kIqI jWdI hY[

au`qr : shI

5) NOW PMkSn AY~m. AY~s. AYksl iv~c mOjUdw imqI Aqy smW pqw krn leI vriqAw jWdw hY[

au`qr : shI
ਛੋਟੇ ਪ੍ਰਸ਼ਨ

1) AY`m.AY`s. AYksl iv`c vrqy jWdy gixqk Eprytr ilKo[

au`qr :
AY`m.AY`s. AYksl iv`c vrqy jWdy gixqk Eprytr hyT ilKy Anuswr hn:-
 
icMnH mMqv
+ joV
- GtwE
* guxw krn leI
/ Bwg
% pRqISq
^ kYryt

2) fwtw vYlIfySn qoN quhwfw kI Bwv hY?

au`qr : ieh AwpSn aus smyN bhuq aupXogI huMdI hY jdoN AsIN koeI Kws kwlm iv`c kuJ Kws mu`lW nUM dwKl krn dI AwigAw dyxw cwhuMdy hW[audwhrx leI AsIN ies ivSySqw nUM Marks kwlm iv`c r`K skdy hW ijQy AsIN Marks kwlm dw mu`l 1 qoN 30 dw dwiery iv`c r`Kxw hovy[

3) iksy iqMn gixiqk PMkSn dw nwm ilKo?

au`qr :
AYm.AYs. AYksl iv`c drswey kuJ gixiqk PMkSn hyT ilKy Anuswr hn:-
1. SUM
2. COUNT
3. MIN

4) AY`m.AY`s. AYksl iv`c swritMg kI huMdI hY[

au`qr : swrt qoN Bwv hY kwlm ivcly fwtw dw mu`lW dy ADwr qy roAz nUM muVH lVIb`D krnw[ swnuM fwtw dy smUh nUM kRmb`D qrIky nwl r`Kx leI sort krn dI loV huMdI hY[ swritMg rwhI fwtw nUM Gtdy kRm jW vDdy kRm iv`c ivvsiQq kIqw jw skdw hY[[ fwtw nUM swrt krn leI hom tYb irbn iv`c Sort & Filter kmWf dI vrqoN kIqI jWdI hY[

5) PwrmUly ƒ pirBwSq kro[

au`qr :
PwrmUlw ie~k AYkspRYSn  huMdw hY jo sYl jW sYl dI ryNj dy mu~lW 'qy kMm krdI hY[ iehnW smIkrnW iv~c siQr mu~l, sY~l AYfrYs Aqy Eprytr Swml huMdy hn[hryk PwrmUlw brwbr (=) icMnH nwl SurU huMdw hY[ v~K-v~K iksmW dIAW gxnwvW krn leI PwrmUly iv~c stYNfrf Eprytr (+, -, *, /, ^ Awid) vrqy jw skdy hn[

6) AY~m. AY~s. AYksl iv~c vrqy gey kMfISnl PMkSnz dy nW ilKo[

au`qr :
AYksl ivc vrqy jwx vwly mu~K kMfISnl PMkSnW dy nW hyTW idqy gey hn:
  • IF( ) PMkSn
  • SUMIF( ) PMkSn
  • COUNTIF( ) PMkSn
ਵੱਡੇ ਪ੍ਰਸ਼ਨ

1) sY~l rYPrYNisMg kI hY? ies dIAW iksmW dI ivAwiKAw kro[

au`qr :
sY~l rYPrYNisMg sY~l dy pqy ƒ ikhw jWdw hY[ sY~l rYPrYNsW dI vrqoN sY~l fwtw aupr gxnwvW krn leI PwrmUly Aqy PMkSnW iv~c kIqI jWdI hY[ audwhrn leI: =A1+A2 [ ie~Qy A1 Aqy A2 sY~l rYPsrYNs hn[
sY~l rYPrYNsW dIAW iksmW: AYksl iv~c iqMn v~K-v~K iksmW dy sY~l rYPrYNsW dI vrqoN kIqI jWdI hY:
1. rYlyitv rYPrYNisMg: ieh AYksl iv~c ifPwlt rYPrYNisMg hY[ jdoN rYlyitv rYPrYNs vwly PwrmUly iksy hor sY~l ivc kwpI kIqy jWdy hn, qW roAz Aqy kwlmW dI siQqI iv~c qbdIlI Anuswr sY~l rYPrYNs vI bdl jWdy hn[
2. AYbsoilaUt rYPrYNisMg: jdoN AYbsoilaUt rYPrYNisMg vwly PwrmUly iksy hor sY~l ivc kwpI kIqy jWdy hn, qW roAz Aqy kwlmW dI siQqI iv~c qbdIlI Anuswr sY~l rYPrYNs nhIN bdldy[ PwrmUly dI kwpI krdy smyN roAz Aqy kwlmz dy rYPrYNs dovyN siQr rihMdy hn[ AYbsoilaUt rYPrYNisMg leI sY~l dy roA Aqy kwlm AYfrYs nwl $ icMnH dI vrqoN kIqI jWdI hY[ audwhrn leI: =$A$2+$B$2
3. imksf rYPrYNisMg: ieh sY~l rYPrYNisMg AYbsoilaUt Aqy rYlyitv rYPrYNisMg dw imSrx hY[ PwrmUly ƒ kwpI krdy smyN isr& roA jW kwlm siQr rihMdw hY[ audwhrn leI: =A2+ B$2

2) koeI vI 3 stirMg PMkSn pirBwSq kro[

au`qr : stirMg PMkSnz isr& fwtw qy vrqy jWdy hn[ AYksl iv`c vrqy jw rhy kuJ sitRMg PMkSn hyT ilKy hn:
LEN PMkSn:- ies PMkSn nUM lYNQ(Length) PMkSn vjON vriqAw jWdw hY[ AsIN ies PMkSn dI vrqoN krdy hoey ie`k sitRMg AMdr spys Aqy icMnH smyq ku`l A`KrW dI sMiKAw pqw kr skdy hW[
LOWER PMkSn:- AY`m. AY`s AYksl dw ieh PMkSn pUry sitRMg dw A`KrW nUM AMgRyzI dy Coty A`KrW (Lowercase) iv`c bdl dyvygw[
UPPER PMkSn:- AY`m.AY`s AYksl dw ieh PMkSn pUry sitRMg dy A`KrW nUM AMgRyzI dy v`fy A`KrW dw v`fy A`KrW ivc bdl dyvygw [

3) PMkSn kI hY? iksy vI do gixqk PMkSnz ƒ audwhrx dy nwl smJwE[

au`qr : PMkSn pihlW qoN pirBwiSq PwrmUly huMdy hn[ ieh PwrmUly AYksl SItW iv~c gxnwvW krn leI vrqy jWdy hn[ hryk PMkSn = icMnH nwl SurU huMdw hY[ Awm vrqy jWdy do gixqk PMkSnW dw vrnx ies pRkwr hY:-
SUM PMkSn:- ieh PMkSn mu`K qOr qy id`qy gey sY`lW jW ryNj dw mu`lW dw joV pqw krn leI vriqAw jWdw hY[
COUNT PMkSn:- ies PMkSn dI vrqoN auhnW sY`lW dI igxqI krn leI kIqI jw skdI hY ijnHw iv`c sMiKAwvW  hn[