ISS 2016 Statistics Paper-1 Solution: Question 80 (Database, Spreadsheet and Presentation Software Basics)
We are back with the next instalment in our ongoing, question-by-question walkthrough of the ISS Statistics Paper-1 previous year papers. This post happens to land on the very last item of the 2016 paper, and it is a nice change of pace from the probability and numerical-methods questions we have been solving: a basic computer-fundamentals MCQ. Let us work through it carefully, statement by statement.
Quick Summary
Topic:Computer Fundamentals — Application Software (Database, Spreadsheet, Presentation tools)
Question Reference:ISS 2016, Statistics Paper-1, Question 80 (Test Booklet Series A)
Correct Answer:Option (d) — Statements 1, 2 and 3 are all correct
The Question, As It Appeared in the Paper
Q80. Which of the following statements are correct?
SQL is used for database management.
Spreadsheets are good for manipulating huge tables.
Presentation softwares can handle text, tables, images and videos.
Select the correct answer using the code given below:
(a) 1 and 2 only
(b) 2 and 3 only
(c) 1 and 3 only
(d) 1, 2 and 3
Step 1: What Kind of Question Is This?
This is a statement-based, "select the correct code" question built around three common categories of application software:database software,spreadsheet software, and presentation software. The trick with this question format is that it is never really asking you one question — it is asking three small true/false questions at once, and then testing whether you can combine your answers correctly using the given code. So the right approach is to evaluate each numbered statement completely independently first, decide True or False, and only then match your results to options (a) through (d).
Step 2: Evaluating Statement 1 — SQL and Database Management
SQL stands for Structured Query Language. It is the standard language used to create, access, update, and manage data stored in relational databases (the kind of databases organised into tables of rows and columns, such as those run by MySQL, Oracle, or PostgreSQL). Through SQL you can define a database's structure, insert and modify records, run queries to retrieve specific data, and control who has access to what. This is precisely what "database management" means, so Statement 1 is correct.
Step 3: Evaluating Statement 2 — Spreadsheets and Huge Tables
Spreadsheet software (think MS Excel or Google Sheets) is built around a grid of rows and columns — in other words, it is designed from the ground up for tabular data. It lets you enter, sort, filter, summarise, and run calculations across large tables of numbers far more efficiently than a word processor ever could, which is exactly what the statement is getting at when it says spreadsheets are "good for manipulating huge tables." As a standalone computer-fundamentals claim — spreadsheet software is suited to handling large tabular datasets — this is correct.
Step 4: Evaluating Statement 3 — Presentation Software and Multimedia
Presentation software (such as MS PowerPoint or Google Slides) is built to combine several types of content on a single slide: typed text, inserted tables, images, and embedded video clips (often audio too). Since the statement only claims it "can handle" these four content types, and modern presentation tools genuinely do support all of them, Statement 3 is also correct.
Pro Tip: The part of this question most likely to trip you up is Statement 2, not because the fact is wrong, but because your instinct might be to overthink it — spreadsheets do have practical row limits and genuinely huge, high-volume datasets are better handled by a proper database. But objective-type computer-awareness questions like this one are testing the standard textbook description of what each software category is designed for, not a deep technical debate about scale. The way this distinction is usually taught is to first answer "what is this tool designed for" as a clean, standalone fact, and only bring in comparisons between tools if the question explicitly asks you to compare them. Students who drill themselves to separate these two levels of reasoning — the
Step 5: Combining the Results
We found Statement 1 correct, Statement 2 correct, and Statement 3 correct. That means all three statements, 1, 2 and 3, are correct — which corresponds exactly to option (d).
Final Answer: (d) 1, 2 and 3
This matches the official ISS 2016 Statistics Paper-1 answer key (Test Booklet Series A), which also records option D as correct for Question 80. No discrepancy here — our independent reasoning and the official key agree.
Why This Question Matters
It is tempting, while preparing for ISS Statistics Paper-1, to pour almost all your effort into probability, inference, and numerical methods and treat a basic computer-fundamentals question like this one as an afterthought. But questions like Q80 are designed to be quick, easy marks for anyone who has a clear, organised mental map of what each category of application software is for. Losing a mark here due to overthinking a straightforward statement is exactly the kind of avoidable error that separates a good score from a great one, and keeping your reasoning disciplined — evaluate each statement on its own terms before combining — is a transferable skill that pays off across every statement-based MCQ in the paper, not just this one.
Frequently Asked Questions
Is SQL itself a database, or just a language used with databases?
SQL is a language, not a database. It is the standard language used to communicate with relational database management systems (RDBMS) like MySQL or Oracle — you use SQL commands to create tables, insert data, run queries, and manage access, but the actual database is the underlying system storing the data.
Does "spreadsheets are good for manipulating huge tables" mean spreadsheets can replace a database?
No. Spreadsheets are well suited to structured, tabular data and are genuinely strong at sorting, filtering and calculating across large tables, but they are not a substitute for a database management system when data volumes get extremely large or when many users need to access and update the data simultaneously. The statement in this question is simply describing what spreadsheet software is designed for, not claiming it replaces a database.
Can presentation software really embed video, not just images?
Yes. Modern presentation tools such as MS PowerPoint and Google Slides allow you to embed or link video clips directly into a slide alongside text, tables and images, which is exactly what Statement 3 in this question describes.
How common are computer-fundamentals questions like this in ISS Statistics Paper-1?
They appear occasionally, usually as a handful of general-awareness items mixed among the heavier probability, inference and numerical-methods questions. They rarely require deep technical knowledge, so a basic, organised understanding of common software categories is normally enough to answer them confidently.
What is the best way to approach a "select the correct code" statement-based question under time pressure?
Evaluate each numbered statement independently and mark it True or False before even glancing at the answer options. Once you have your True/False pattern, matching it against options (a) through (d) becomes a simple lookup rather than a second round of reasoning, which saves time and avoids the confusion of trying to judge statements relative to each other.
Where can I find the rest of the ISS 2016 Statistics Paper-1 solutions?
This post completes Question 80, the final question of the ISS 2016 Statistics Paper-1. The earlier questions in this paper, along with solutions to other years, are being published one by one as part of this same ongoing series — keep an eye on the blog for the next year's paper, which picks up from Question 1.
That brings us to the end of the ISS 2016 Statistics Paper-1 series. If anything in the reasoning above was unclear, or you solved this one differently, drop a comment below — and if you know a fellow ISS aspirant who would find this useful, feel free to share it with them.
Comments