?>

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

ਸਹੀ ਗਲਤ

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

Zlq

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

shI

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

shI

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[

shI

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

shI

ਛੋਟੇ ਪ੍ਰਸ਼ਨ

pRSn : AY`m.AY`s. AYksl iv`c vrqy jWdy gixqk Eprytr ilKo[

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

pRSn : fwtw vYlIfySn qoN quhwfw kI Bwv hY?

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

pRSn : iksy iqMn gixiqk PMkSn dw nwm ilKo?

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

pRSn : AY`m.AY`s. AYksl iv`c swritMg kI huMdI hY[

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

pRSn : PwrmUly ƒ pirBwSq kro[

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

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

auqr :
AYksl ivc vrqy jwx vwly mu~K kMfISnl PMkSnW dy nW hyTW idqy gey hn:
  • IF( ) PMkSn
  • SUMIF( ) PMkSn
  • COUNTIF( ) PMkSn

ਵੱਡੇ ਪ੍ਰਸ਼ਨ

pRSn : sY~l rYPrYNisMg kI hY? ies dIAW iksmW dI ivAwiKAw kro[

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

pRSn : koeI vI 3 stirMg PMkSn pirBwSq kro[

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

pRSn : PMkSn kI hY? iksy vI do gixqk PMkSnz ƒ audwhrx dy nwl smJwE[

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

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

…… ie~k irlySn fwtwbys mYnyjmYt isstm hY

e
?>