Practise MS Excel MCQs in Computer. Attempt multiple-choice questions, check answers and revise related subtopics.
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.
Try each question before opening its answer. Record the concept behind each mistake and revisit it during your next practice session.
ورک بک کس کا گروپ ہے؟
Answer: Worksheets
Explanation A Workbook is a group of Worksheets. A workbook is a file that contains one or more worksheets to help you organize data. A workbook initially contains three worksheets, which are saved in a single file. 1. Sheet1 2. Sheet2 3. Sheet3
میکرو کیا ہے؟
Answer: Automated sequence of commands
Explanation A macro is an automated sequence of commands in applications like Word or Excel to perform repetitive tasks. It helps save time and reduce manual effort. Macros can be recorded or written using programming languages like VBA (Visual Basic for Applications) .
فنکشن ایک ______ ہے جو مخصوص ترتیب میں دی گئی قدروں کا حساب لگا سکتا ہے۔
Answer: Pre-defined formula
Explanation In spreadsheets or programming , a function is a pre-defined formula that calculates values in a specific order. Functions simplify calculations by automating repetitive tasks . They are used in Excel, Google Sheets, and programming languages. Additional information : Examples of functions: SUM(), AVERAGE(), MAX() in Excel. Pre-defined formulas save time and reduce errors compared to manual calculations. Last verified on 16-01-2026
Answer: Both
Explanation On the Home tab, in the Font group, click the arrow next to Borders Button, and then click No Border Button. --OR-- Click Home > the Borders arrow > Erase Border, and then select the cells with the border you want to erase.
ایم ایس ایکسل 2016 میں کون سا فنکشن ان تمام سیلز کا اوسط دیتا ہے جو دیے گئے معیار پر پورا اترتے ہیں؟
Answer: AVERAGEIF
Explanation AVERAGEIF calculates the average of cells that meet a specific condition. Formula : =AVERAGEIF(range, criteria, [average_range]) Useful for conditional averaging in large datasets. Last verified on 08-03-2026
نئی ورک بک میں کلید کردہ نئے ڈیٹا کے لیے پہلے سے طے شدہ اندازکیا ہے؟
Answer: Normal
Explanation The default style for new data keyed in a new workbook is Normal .
ایم ایس ایکسل کا فارمولہ_____ شروع ہوتا ہے؟
Answer: =
Explanation After = symbol you can enter either a calculation or functions ***** ********* FIA VU CONSTABLE PAST PAPER 2021
کون سا چارٹ مختلف زمروں میں اقدار کے موازنہ کے لیے سب سے مفید ہے؟
Answer: Column Chart
Explanation In MS Excel 2016, a Column Chart displays data as vertical bars. It is especially useful for comparing values across categories clearly. Column charts make it easy to visualize differences and trends at a glance. Last verified on 10-03-2026
Answer: Copilot
Explanation Copilot is an AI assistant available across the Microsoft 365 suite (which includes Word and Excel) to help with tasks like generating text, analyzing data, and automating workflows.
ایم ایس ایکسل 2016 میں ڈیٹا میں رجحانات اور پیٹرن کو بارز، رنگوں اور آئیکنز کے ذریعے نمایاں کرنے کے لیے کون سا فیچر استعمال ہوتا ہے؟
Answer: Conditional Formatting
Explanation Conditional Formatting in MS Excel 2016 is used to highlight cells based on specific conditions. It visually displays data trends using colors, data bars, and icon sets. This helps users quickly analyze large datasets. Last verified on 09-03-2026
Found a mistake? Use “Report correction” in the practice tool or contact us with the question and a supporting source.