Wednesday, 27 June 2018

MS Excel Short Keys


Complete List of MS Excel Shortcut Keys

Ctrl+A - Select All
Ctrl+B - Bold
Ctrl+C - Copy
Ctrl+D - Fill Down
Ctrl+F - Find
Ctrl+G - Goto
Ctrl+H - Replace
Ctrl+I - Italic
Ctrl+K - Insert Hyperlink
Ctrl+N - New Workbook
Ctrl+O - Open
Ctrl+P - Print
Ctrl+R - Fill Right
Ctrl+S - Save
Ctrl+U - Underline
Ctrl+V - Paste
Ctrl W - Close
Ctrl+X - Cut
Ctrl+Y - Repeat
Ctrl+Z - Undo
F1 - Help
F2 - Edit
F3 - Paste Name
F4 - Repeat last action
F4 - While typing a formula, switch between absolute/relative refs
F5 - Goto
F6 - Next Pane
F7 - Spell check
F8 - Extend mode
F9 - Recalculate all workbooks
F10 - Activate Menubar
F11 - New Chart
F12 - Save As
Ctrl+: - Insert Current Time
Ctrl+; - Insert Current Date
Ctrl+" - Copy Value from Cell Above
Ctrl+’ - Copy Formula from Cell Above
Shift - Hold down shift for additional functions in Excel’s menu
Shift+F1 - What’s This?
Shift+F2 - Edit cell comment
Shift+F3 - Paste function into formula
Shift+F4 - Find Next
Shift+F5 - Find
Shift+F6 - Previous Pane
Shift+F8 - Add to selection
Shift+F9 - Calculate active worksheet
Shift+F10 - Display shortcut menu
Shift+F11 - New worksheet
Shift+F12 - Save
Ctrl+F3 - Define name
Ctrl+F4 - Close
Ctrl+F5 - XL, Restore window size
Ctrl+F6 - Next workbook window
Shift+Ctrl+F6 - Previous workbook window
Ctrl+F7 - Move window
Ctrl+F8 - Resize window
Ctrl+F9 - Minimize workbook
Ctrl+F10 - Maximize or restore window
Ctrl+F11 - Inset 4.0 Macro sheet
Ctrl+F1 - File Open
Alt+F1 - Insert Chart
Alt+F2 - Save As
Alt+F4 - Exit
Alt+F8 - Macro dialog box
Alt+F11 - Visual Basic Editor
Ctrl+Shift+F3 - Create name by using names of row and column labels
Ctrl+Shift+F6 - Previous Window
Ctrl+Shift+F12 - Print
Alt+Shift+F1 - New worksheet
Alt+Shift+F2 - Save
Alt+= - AutoSum
Ctrl+` - Toggle Value/Formula display
Ctrl+Shift+A - Insert argument names into formula
Alt+Down arrow - Display AutoComplete list
Alt+’ - Format Style dialog box
Ctrl+Shift+~ - General format
Ctrl+Shift+! - Comma format
Ctrl+Shift+@ - Time format

Monday, 25 June 2018

Modern. "VERBS" & Their Usage


                                         *Lecture *

Assalam O Alaikum.

Today, we'll talk on Uses of Modal verbs and their usage.

*Modal Verbs*

"Verbs, used with another verb to show/express permission, ability, possibility, suggestions etc".
*Examples*
Modal verbs/modal auxiliaries include the following:

❤1. *_CAN_*

CAN is used for:

1⃣. For ability.
*Eg*. I can do this work.
2⃣. For permission.
*Eg*. You can go now.
3⃣. For request.
*Eg*. Can you translate this article for me please?
4⃣. For possibility. (Usually used in negative and interrogative sentences).
*Eg*. You can not get that book from Karachi.
5⃣. For anger.
*Eg*. Can you just shut up?
6⃣. For general truth.
*Eg*. By exercising daily, you can lose your weight.
7⃣. For offers.
*Eg*. Can I help you?

❤2. *_COULD_*

Could is used for:

1⃣. For past ability.
*Eg*. When I was in SSC, I could study for 7 hours daily.
2⃣. For past possibility.
*Eg*. The road could be blocked but the police reached in time.
3⃣. For polite way of asking.
*Eg*. Could I have my book back please?
4⃣. For uncertain possibility.
*Eg*. They could come any time.
5⃣. For suggestions.
*Eg*. We could have lunch outside today.
6⃣. For anger.
*Eg*. You could try to change it before my arrival.
7⃣. For suggestions.
*Eg*. You could go there before he had gone.

❤3. *_MAY_*

May is used for:

1⃣. For possibility (usually used in positive sentences).
*Eg*. It may rain today.
2⃣. For permission.
*Eg*. May I join you sir?
3⃣. For wish (usually in optative sentences).
*Eg*. May my mother live long.
4⃣. For request.
*Eg*. May I speak sir please?
5⃣. For prohibition.
*Eg*. You may not smoke in the office.

❤4. *_MIGHT_*

Might is used for:

1⃣. Possibility.
*Eg*. It might rain today.
2⃣. For politeness.
*Eg*. Might I take more?
3⃣. For suggestions.
*Eg*. I thought you might help me.

❤5. *_WILL_*

Will is used for:

1⃣. For future actions:
*Eg*. He will leave for India tomorrow.
2⃣. For willingness.
*Eg*. I will play with you.
3⃣. For asking something.
*Eg*. Will you give me your watch?
4⃣. For polite invitation.
*Eg*. Will you join me please?
5⃣. For anger.
*Eg*. Will you stop talking?
6⃣. For something possible.
*Eg*. Who is knocking the door? It will be Ali.
7⃣. For things, which usually happen.
*Eg*. It will last longer, if you used it carefully.
8⃣. For promise.
*Eg*. I will come there tomorrow.

❤6. *_WOULD_*

Would is used for:

1⃣. For a polite request.
*Eg*. Would you mind sitting here?
2⃣. For strong desire.
*Eg*. Would that I could see Quaid E Azam!
3⃣. For past habitual actions.
*Eg*. I would study very hard, when I was in Primary school.
4⃣. For typical behavior.
*Eg*. They always say we are busy. They would say that again.
5⃣. For reason.
*Eg*. Why would one miss such an offer?

❤7. *_SHALL_*

Shall is used for:

1⃣. For first person pronouns.
*Eg*. I/we shall go tomorrow.
2⃣. For a command (usually in 2nd or 3rd person).
*Eg*. You shall not enter to this room.
3⃣. For emphasis.
*Eg*. I shall kill you the day you abused me.
4⃣. For asking something.
*Eg*. Shall you forgive me?
5⃣. For permission.
*Eg*. Shall I collect the money from them Sir?

❤8. *_SHOULD_*

Should is used for:

1⃣. For something advisable.
*Eg*. If you can't sleep, you should go to a good physician.
2⃣. For expectations.
*Eg*. You should do it very easy.
3⃣. For a purpose.
*Eg*. Take umbrella lest you should get wet.
4⃣. For reason.
*Eg*. Why one should reject this offer?
5⃣. For advice.
*Eg*. You should not worry because he's alive.
6⃣. For expressing obligation or duty.
*Eg*. We should obey the law.
7⃣. For politeness.
*Eg*. I should like to help you.
8⃣. For supposition.
*Eg*. If it should rain, they will not come.

❤9. *_MUST_*

Must is used for:

1⃣. For necessary things.
*Eg*. You must study hard.
2⃣. For strong intention.
*Eg*. You must invite him.
3⃣. For emphasis.
*Eg*. I must say "you are great".
4⃣. For strong possibility.
*Eg*. He must be hungry.
5⃣. For obligation.
*Eg*. You must get up very early.
6⃣. For expressing logical certainty.
*Eg*. Living in so much crowd must be very difficult.

❤10. *_OUGHT TO_*

Ought To is used for:

1⃣. For expressing moral obligation or desirability.
*Eg*. We ought to love our neighbours.
2⃣. For expressing probability.
*Eg*. This book ought to be very useful.
3⃣. For expectations.
*Eg*. He ought to be at home now.

❤11. *_USED TO_*

Used To is used for:

1⃣. For repeated actions in the past.
*Eg*. We used to play a lot when we were younger.
2⃣. For expressing a discontinued habit.
*Eg*. I used to study a lot in SSC.

❤12. *_NEED_*

Need is used for:

1⃣. For necessity or obligation.
*Eg*. I need hardly to go.

                                               πŸ›‘πŸ›‘πŸ›‘EndπŸ›‘πŸ›‘πŸ›‘






Sunday, 10 June 2018

PMS Questions & Answers

Academic Questions of PMS 139 Initial test (Maximum Questions Repeat ho tay hain)
Memorize All These Questions.
Remeber Me In Your Prayers <3

Ques:) Holy Prophet was born in?
Answ:) 571 A.D 22nd April
Ques:) Hazrat Hajirah (RA) Was the Mother Of?
Answ:) Hazrat Ismail
Ques:) Jab President Nhi Hota To Mulk Kon Chalata Hy?
Answ:) chairman senate
Ques:) Ghazwa khandak main khandak Ki length and width?
Answ:) 10km long 22ft wide 16ft depth
Ques:) Kaleem Ullah Kis Ka Laqab Tha?
Answ:) Hazrat Musa
Ques:) Largest Dam in Pakistan?
Answ:) Tarbela
Ques:) Quid-e-Azam 14 points ki date?
Answ:) 1929
Ques:) Makah was conquered by Holy Prophet (PBUH) on?
Answ:) 08 Hijri
Ques:) Head quarters of Pak army?
Answ:) GHQ (General Head Quarters) Rawalpindi.
Ques:) Son of Hazrat Adam (a.s)?
Answ:) 3
Ques:) Chief of army staff?
Answ:) General Qamar Javed Bajwa
Ques:) Camel name of Hazrat Muhammad (PBUH) during migration?
Answ:) Qaswa
Ques:) Hazrat Adam was thrown in which country?
Answ:) sri lanka
Ques:) Messaq-e-Madina?
Answ:) 622 hijari
Ques:) Shimla conference?
Answ:) June 1945
Ques:) Which
Ques:) Which military award borderbelongs to Britten?
Answ:) Victoria Cross
Ques:) How many times the name of Holy Prophet (PBUH) is mentioned in the Holy Quran?
Answ:) 4
Ques:) Hazrat Adam (a.s) had ----- son's and---- daughters?
Answ:) 3 sons and 2 daughters
Ques:) Which Prophet sleeps 100 years and again woke up?
Answ:) Hazrat Uzair a.s
Ques:) How many days Hazrat Yousaf (a.s) remained in the well?
Answ:) 3 days
Ques:) Only Sahabi mentioned in Quran is?
Answ:) Hazrat Zaid bin Haris
Ques:) Members of SAARC.
Answ:) 8
Ques:) Speakers of Prophet title of which Prophet?
Answ:) Hazrat Shoaib a.s
Ques:) The incident of Karbala took place in which Moharram?
Answ:) 61 A.H
Ques:) Height of Hazrat Adam (a.s)?
Answ:) 90 feet
Ques:) Who imposed 1st Martial Law in Pakistan?
Answ:) Ayub khan 1958
Ques:) Ali Garh got a status of college/University
Answ:) 1877 College, 1920 University
Ques:) Pak became a member Of UNO on
Answ:) 30 Sept 1947
Ques:) Tochi Pass is b/w?
Answ:) Pakistan and china
Ques:) 2018 Olympics will held in?
Answ:) Pyeongchang, South Korea
Ques:) MAO high school Aligarh given the status of college in?
Answ:) 1977
Ques:) 3rd round table conference?
Answ:) 1932
Ques:) Defence minister name?
Answ:) Khurram Dastgir Khan.
Ques:) Joint Chiefs of Staff Committee (CJCSC) name?
Answ:) General Zubair Mahmood Hayat
Ques:) CHIEF OF NAVAL STAFF name?
Answ:) Admiral Zafar Mahmood Abbasi, HI(M).
Ques:) Objective resolution of Pakistan was passed in?
Answ:) 12th March, 1949
Ques:) Largest Country by Population
Answ:) China
Ques:) Largest Country By Area
Answ:) Russia
Ques:) Speaker national assembly
Answ:) Ayaz sadik
Ques:) Gazwa uhed?
Answ:) 3hijri
Ques:) Pakistan ki mysht ma bra hisa
Answ:) zerat
Ques:) komi asembli ki myad
Answ:) 5 sal
Ques:) jihad ka meaning
Answ:) koshish krna
Ques:) Chora chori Incedent ?
Answ:) 1922
Ques:) First & last mughal badshah ?
Answ:) First mughal Emperor: Zaheer-ud-din Babar & Last mughal Emperor Bahadur Shah Zafar.
Ques:) Last wahi where and when revealed?
Answ:) 10 hijri..hajjah tul wadaa
Ques:) One one function ?
Answ:) Injective
Ques:) Biggest FATA agency ?
Answ:) South wazeristan
Ques:) Who was first empiral in india?
Answ:) Mauryan empire
Ques:) zakat k musaraf ?
Answ:) 8
Ques:) Sura E Maryam in which para?
Answ:) 16
Ques:) biggest thermal power of Pakistan?
Answ:) kot addu
Ques:) Who is the largest producer of quartz?
Answ:) CUBN
Ques:) lucknow pact?
Answ:) 1916

❤Dua Me Yad Rakhna.
      IRFAN BUKHARI....