MS Excel MCQs - Computer Practice | PakExamPoint

Practise MS Excel MCQs in Computer. Attempt multiple-choice questions, check answers and revise related subtopics.

MS Excel MCQs and revision practice

Study MS Excel through multiple-choice questions in Computer. This subtopic contains 445 practice questions. Read the wording carefully, compare the options and attempt an answer before checking the solution in learning mode.

Use these MS Excel MCQs to identify the facts, rules or methods you need to revise. Where an explanation is available, work through it and write down why your chosen option was correct or incorrect. Revisit difficult questions after reviewing your notes, then use exam mode for timed practice.

Continue your revision with related topics: 100 Most Repeated Computer MCQs MCQs, Computer Basic Hardware Components MCQs, Computer Short Questions MCQs, Computer Shortcut Keys MCQs, Important Abbreviations (Computer) MCQs, Information Technology (IT) MCQs, Internet and Social Media MCQs, Internet related Information MCQs.

Return to all Computer topics to choose your next area of study. Read the MCQ study guide to plan your revision, or try a Computer practice quiz.

MS Excel: questions and answer review

Try each question before opening its answer. Record the concept behind each mistake and revisit it during your next practice session.

11. In --- tab you will find auto sum button:

Check answer and explanation

Answer: Formulas tab

Explanation The formula tab allows you to select from over 300 Excel functions .

12. From where add images and tables in PPT?

پی پی ٹی میں تصاویر اور میزیں کہاں سے شامل کریں؟

Check answer and explanation

Answer: insert tab

Explanation Select the Insert tab , then click the Pictures command in the Images group . A dialog box will appear. Locate and select the desired image file, then click Insert. The picture will appear on the currently selected slide.

13. Comments can be added to cells using _______?

کا استعمال کرتے ہوئے خلیوں میں تبصرے شامل کیے جاسکتے ہیں؟ _____

Check answer and explanation

Answer: Insert > Comment

Explanation Comments can be added to cells using Insert > Comment . Right-click the cell and then click Insert Comment (or press Shift+F2).

14. In MS Excel you can use a function to combine text from two cells into one cell. But you can use an operator to do the same thing. Which operator is that?

ایم ایس ایکسل میں آپ دو سیلز سے ٹیکسٹ کو ایک سیل میں جوڑنے کے لیے فنکشن استعمال کر سکتے ہیں۔ لیکن آپ ایک ہی کام کرنے کے لیے آپریٹر استعمال کر سکتے ہیں۔ وہ کون سا آپریٹر ہے؟

Check answer and explanation

Answer: Ampersand

Explanation The Ampersand (&) operator in MS Excel is used to concatenate (combine) text from two or more cells into one cell. For example, =A1 & B1 will combine the text in cells A1 and B1 into a single string.

15. Consider a worksheet of MS Excel, If value of F7 cell is 12 and value of H12 cell is 30. Calculate the answer of following formula=F7*H12 _____?

Check answer and explanation

Answer: 360

Explanation Let's calculate: F7 = 12 H12 = 30 Formula: F7 * H12 = 12 * 30 = 360

16. A numeric value can be treated as label value if ___precedes it

Check answer and explanation

Answer: Apostrophe

Explanation An apostrophe before a cell value forces Excel to interpret the value as text. This is mostly useful for values that look like a number or date.

17. To select a group of worksheet we press and hold ____ key and select the sheet we want to add :

ورک شیٹ کے گروپ کو منتخب کرنے کے لیے ہم ____ کلید کو دباتے ہیں اور اس شیٹ کو منتخب کرتے ہیں جسے ہم شامل کرنا چاہتے ہیں۔

Check answer and explanation

Answer: ctrl

Explanation To edit an embedded Excel worksheet's contents or resize in the future in Word, you must return to editing mode. by double-clicking the embedded Excel worksheet object in the document to switch back to Excel. Press and hold the Ctrl key on your keyboard. Select the next worksheet you want in the group.

18. Which Excel feature allows creating dynamic drop-down lists based on cell values?

ایکسل میں کون سا فیچر سیل ویلیوز کی بنیاد پر ڈائنامک ڈراپ ڈاؤن لسٹ بنانے کی اجازت دیتا ہے؟

Check answer and explanation

Answer: Data Validation

Explanation Microsoft Excel provides tools to control and manage user input. Data Validation is used to create drop-down lists based on cell values. It helps ensure accurate and consistent data entry . Last verified on 04-04-2026

19. A numeric value can be treated as label value if it is precedes with

عددی قدر کو لیبل ویلیو کے طور پر سمجھا جا سکتا ہے اگر یہ۔۔۔۔ سے پہلے ہو۔

Check answer and explanation

Answer: Apostrophe

Explanation An apostrophe (') can be used to treat a numeric value as a label value. When an apostrophe precedes a numeric value, Excel recognizes it as text instead of a number. **** RY17-012-23

20. A collection of related worksheets is called ______?

متعلقہ ورک شیٹس کے ایک مجموعہ کو ______ کہا جاتا ہے؟

Check answer and explanation

Answer: Workbook

Explanation A collection of related worksheets is called a workbook . In spreadsheet applications like Microsoft Excel, a workbook is the main file (e.g., .xlsx) Workbook: The entire file containing multiple sheets. Worksheet: A single page/sheet within a workbook, consisting of rows and columns. Last updated 15-feb-2026

Found a mistake? Use “Report correction” in the practice tool or contact us with the question and a supporting source.