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.

1. Which function can be used to calculate the monthly mortgage payment :

ماہانہ رہن کی ادائیگی کا حساب لگانے کے لیے کون سا فنکشن استعمال کیا جا سکتا ہے

Check answer and explanation

Answer: PMT

Explanation PMT , one of the financial functions, calculates the payment for a loan based on constant payments and a constant interest rate.

2. How do you display current date and time in MS Excel?

ایم ایس ایکسل 2016 میں کون سا فنکشن متن کو بڑے حروف میں تبدیل کرتا ہے؟

Check answer and explanation

Answer: Now ()

Explanation In MS Excel , different functions are used to handle dates and times. To display the current date and time , the NOW() function is used. Additional information : DATE() – Returns a date based on year, month, and day TODAY() – Returns today’s date only TIME() – Constructs a specific time from hours, minutes, and seconds Last verified on 11-03-2026

3. Which function in Excel tells how many numeric entries are there?

ایکسل میں کون سا فنکشن بتاتا ہے کہ کتنےعددی اندراجات ہیں؟

Check answer and explanation

Answer: COUNT

Explanation In Excel, the COUNT function is used to determine how many numeric entries are present in a range of cells. COUNT Function : The COUNT function counts the number of cells that contain numeric values within a specified range. For example: =COUNT(A1:A10) This formula will return the number of cells containing numbers in the range A1 through A10.

4. In MS Excel window, on the bottom, right area of the spreadsheet there is/are:

Check answer and explanation

Answer: All of these

Explanation Zoom slider is in the bottom right corner of the Excel window. To use the Zoom slider, drag the slider to the right or to the left. To zoom in, drag the slider to the right. AGM 17-12-2022

5. What type of chart will you use to compare performance of two employees in the year 2021?

سال 2021 میں دو ملازمین کی کارکردگی کا موازنہ کرنے کے لیے آپ کس قسم کا چارٹ استعمال کریں گے؟

Check answer and explanation

Answer: Column Chart

Explanation A column chart is ideal for comparing the performance of two employees in 2021 because it allows for a side-by-side comparison of their performance metrics, such as sales, productivity, or revenue. Pie Chart : Shows how different components contribute to a whole. Dot Chart : Displays a small number of data points. Column Chart : Compares performance metrics side-by-side. Line Chart : Shows trends over time.

6. statistical calculation and preparation of tables and graphs can be done using

شماریاتی حساب کتاب اور جدولوں اور گرافوں کی تیاری کا استعمال کرتے ہوئے کیا جا سکتا ہے۔

Check answer and explanation

Answer: excel

Explanation statistical calculation and preparation of tables and graphs can be done using excel ** Explanation: The MS-Excel is a part of the office package or software which is used for the calculation or manipulation of data with the help of mathematics formulas. It is also used to hold the records in the form of rows and tables. It also presents the data in the form of a graph.

7. A function inside another function in called _____?

کسی دوسرے فنکشن کے اندر ایک فنکشن جسے _____ کہا جاتا ہے؟

Check answer and explanation

Answer: Nested function

Explanation A function inside a function is called a Nested function . Function Definition Round Function This function rounds a number to a specified number of digits. Switch Function It returns a value (if matched), after matching it with other values in the list. Nested Function A function tucked inside a function

8. Which chart is by default in MS Excel?

ایم ایس ایکسل میں کون سا چارٹ بطور ڈیفالٹ ہے؟

Check answer and explanation

Answer: Column Chart

Explanation In MS Excel , when you insert a chart without specifying the type, it defaults to a Column Chart . Column charts are commonly used to compare values across categories.

9. In a computer spreadsheet, a function that is used to count a number of entries in a given range is called?

کمپیوٹر اسپریڈشیٹ میں، ایک فنکشن جو ایک دی گئی رینج میں کئی اندراجات کو شمار کرنے کے لیے استعمال کیا جاتا ہے، کہا جاتا ہے؟

Check answer and explanation

Answer: length

Explanation In a computer spreadsheet, a function that is used to count a number of entries in a given range is called length *** COUNTA: To count cells that are not empty. COUNT: To count cells that contain numbers. COUNTBLANK: To count cells that are blank. COUNTIF: To count cells that meet specified criteria.

10. What are the small squares arranged in rows and columns called in Excel?

قطاروں اور کالموں میں ترتیب دیئے گئے چھوٹے مربعوں کو ایکسل میں کیا کہتے ہیں؟

Check answer and explanation

Answer: Cells

Explanation The small squares arranged in rows and columns in Excel are called cells. Each cell is the intersection of a row and a column and can hold data.

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