StudyXT

A dvanced MS Excel   formula logic, lookup functions, conditional calculations, references, errors, arrays, and practical formula-based questions . Advanced MS Excel Formula MCQs 1. What will =IF(A1>=60,"Pass","Fail") return if A1 contains 75? A. 60 B. TRUE C. Pass D. Fail Answer: C. Pass Explanation: Since 75 ≥ 60 is TRUE, the IF() function returns "Pass" . 2. What is the result of =SUM(A1:A5) ? A. Adds only A1 and A5 B. Adds values from A1 through A5 C. Counts cells A1 through A5 D. Finds the average Answer: B. Adds values from A1 through A5 Explanation: The colon : specifies a continuous range from A1 to A5. 3. Which formula correctly calculates the average only for values greater than 50 in A1:A20? A. =AVERAGEIF(A1:A20,">50") B. =AVERAGE(A1:A20,">50") C. =IFAVERAGE(A1:A20,50) D. =AVGIF(A1:A20,50) Answer: A. =AVERAGEIF(A1:A20,">50") Explanation: AVERAGEIF() calculates the average of cells satisfying a spe...

MS Excel MCQs with explanations,  suitable for competitive exams, computer exams, UGC/college exams, SSC, banking, teaching recruitment, and general computer knowledge . MS Excel MCQs 1. Microsoft Excel is primarily used for: A. Word processing B. Spreadsheet and data analysis C. Presentation design D. Web browsing Answer: B. Spreadsheet and data analysis Explanation: Excel is spreadsheet software used for storing, organizing, calculating, analyzing, and visualizing data. 2. The intersection of a row and a column is called: A. Sheet B. Cell C. Workbook D. Range Answer: B. Cell Explanation: A cell is the basic unit of an Excel worksheet, such as A1 or B5 . 3. A collection of worksheets is called: A. Workbook B. Range C. Column D. Cell Answer: A. Workbook Explanation: An Excel file containing one or more worksheets is called a workbook. 4. Which symbol is used to begin a formula in Excel? A. # B. @ C. = D. % Answer: C. = Explanation: Every Excel formula generally starts with the...

Imagine that, it's a morning in 2026. In a classroom, a teacher holds up a tablet. Instead of reciting multiplication tables, a group of eight-year-olds watches a tiny animation explaining how computers “learn” from patterns. A curious hand shoots up. “Ma’am, does that mean my phone is smarter than me?” The class bursts into laughter, but the question lingers. That, in essence, is the beginning of India’s new chapter — where Artificial Intelligence is no longer a distant, sci-fi term, but a part of early education. The Turning Point The Central Board of Secondary Education (CBSE) has drafted a plan to introduce AI as a subject from Class 3 to Class 12 , a first in the country’s education history. The proposal, now with NCERT for expert review, aims to roll out by April 2026 . If all goes to plan, teacher training will begin next year, resource books and digital tools will follow, and by the time the next generation steps into school, “AI” will sit alongside English, Science,...

Walk into any conversation about Indian tech, and names like TCS, Infosys, and Wipro dominate. But beneath the noise, one company—quietly bootstrapped, fiercely independent, and unapologetically Indian—is redefining what it means to build a global tech empire from India’s suburbs. That company is Zoho Corporation . Zoho was founded by Sridhar Vembu  in 1996 , Zoho has grown into a $1 billion-plus SaaS powerhouse with over 100 million users across 180 countries—without a single rupee of venture capital. It’s the polar opposite of Silicon Valley’s hyper-funded “grow fast, burn faster” philosophy. And now, as India positions itself as a global tech player amid shifting geopolitics and digital sovereignty debates, the question naturally arises: Can Zoho become India’s version of Microsoft or Google ? The New Global Tech Order The world of 2025 looks very different from the pre-AI era. The United States and China continue their tech cold war—semiconductors, AI models, data localizati...

MCQs on SDLC models with answers and detailed explanations for UGC NET, ISRO, and Assistant Professor: 1. In the Spiral Model, the radial dimension represents: a) Progress made in completing each cycle b) Cost of the project c) Level of risk involved d) Number of iterations completed Answer: a) Progress made in completing each cycle Explanation: In the spiral model diagram, the radial dimension shows the cumulative cost and progress, while the angular dimension represents phases. 2. Which of the following is a key feature that distinguishes the Spiral Model from other models? a) Phased development b) Heavy documentation c) Risk assessment at each iteration d) Parallel testing and coding Answer: c) Risk assessment at each iteration Explanation: Spiral is unique in systematically addressing risks at every stage. 3. In the Incremental Model, which of the following risks is reduced compared to the Waterfall model? a) Risk of system failure b) Risk of changing requireme...

MCQs on different SDLC (Software Development Life Cycle) models with answers and explanations, ideal for UGC NET, ISRO, and Assistant Professor exams : 1. The Waterfall model is best suited for projects where: a) Requirements are evolving frequently b) Prototyping is essential c) Requirements are well understood and fixed d) Risk analysis is the main concern Answer: c) Requirements are well understood and fixed Explanation: Waterfall is a linear model and works best when all requirements are clearly defined at the beginning. 2. Which SDLC model includes a risk analysis phase in every cycle? a) Waterfall Model b) Agile Model c) Spiral Model d) V-Model Answer: c) Spiral Model Explanation: The Spiral Model emphasizes risk analysis in each iteration of its cycle. 3. Which model is known as verification and validation model ? a) V-Model b) Spiral Model c) Prototype Model d) RAD Model Answer: a) V-Model Explanation: V-Model emphasizes that each development phase is d...