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.
ایم ایس ایکسل 2016 میں کون سا فنکشن متن کو بڑے حروف میں تبدیل کرتا ہے؟
A. Today ()
B. Year ()
C. Now ()
D. Date ()
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
ایکسل میں کون سا فنکشن بتاتا ہے کہ کتنےعددی اندراجات ہیں؟
A. NUM
B. SUM
C. COUNT
D. CHKNUM
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.
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
سال 2021 میں دو ملازمین کی کارکردگی کا موازنہ کرنے کے لیے آپ کس قسم کا چارٹ استعمال کریں گے؟
A. Pie Chart
B. Dot Chart
C. Line Chart
D. Column Chart
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.
شماریاتی حساب کتاب اور جدولوں اور گرافوں کی تیاری کا استعمال کرتے ہوئے کیا جا سکتا ہے۔
A. excel
B. adobe photoshop
C. powerpoint
D. notepad
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.
کسی دوسرے فنکشن کے اندر ایک فنکشن جسے _____ کہا جاتا ہے؟
A. Text function
B. Sum function
C. Round function
D. Nested function
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
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.
کمپیوٹر اسپریڈشیٹ میں، ایک فنکشن جو ایک دی گئی رینج میں کئی اندراجات کو شمار کرنے کے لیے استعمال کیا جاتا ہے، کہا جاتا ہے؟
A. counting
B. length
C. counter
D. count
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.
قطاروں اور کالموں میں ترتیب دیئے گئے چھوٹے مربعوں کو ایکسل میں کیا کہتے ہیں؟
A. Cells
B. Columns
C. Blocks
D. Rows
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.