←

IELTS Academic Reading Practice Test 180

Part 1 · Read the text and answer questions 1–13

You should spend about 20 minutes on Questions 1–13, which are based on Reading Passage 1 below.

The Rise of the Spreadsheet

For most of the twentieth century, financial planning was done on paper. An accountant would rule a large sheet into rows and columns, write figures in the spaces and add totals at the foot of each column. Because the arithmetic was done by hand, any change to a single figure meant that the totals, and every figure that depended on them, had to be worked out again. Large organisations employed clerks to keep such sheets up to date, and the work was slow and prone to error. Questions of the 'what if' kind, such as what would happen if sales fell by a tenth, were expensive to answer.

The idea for a better method occurred to Dan Bricklin in 1978, when he was a student at Harvard Business School. He later described watching a professor draw a table of figures on a blackboard, erase one value and recalculate the rest of the table by hand. Bricklin had worked as a programmer before going into business, and he imagined a screen on which the table itself would recalculate. With a colleague, Bob Frankston, he wrote a program they called VisiCalc, short for 'visible calculator', and the two men founded a company, Software Arts, to sell it.

VisiCalc went on sale in 1979 for the Apple II, one of the first personal computers to be widely owned. It presented a grid of cells, each identified by a letter and a number, such as B7. A cell could hold either a value or a formula, and a formula could refer to other cells, so that changing one figure updated every cell that depended on it. The memory of the small machines limited the first version to a few hundred rows and about sixty columns, which was nevertheless more than most users needed. The screen showed only a small window onto the grid.

Demand for the program was remarkable. Accountants, estate agents, engineers and small businesses bought computers in order to run it, and VisiCalc is often described as the first 'killer application', software so useful that customers bought a machine simply to use it. Sales ran into the hundreds of thousands, and the program is now regarded as one of the inventions that turned the personal computer from a hobbyist's toy into a tool of business.

Success attracted competitors, and the most significant appeared in 1983. Lotus 1-2-3 was written by Mitch Kapor's company, Lotus Development Corporation, for the IBM Personal Computer, a machine with more memory and a faster processor than the Apple II. It combined a spreadsheet with charting and a simple database in one program, and it offered menus so that users did not have to memorise commands. Lotus 1-2-3 quickly became the standard in offices. VisiCalc could not compete, and Lotus bought Software Arts in 1985 and discontinued VisiCalc.

The next stage belonged to Microsoft. Excel was first released for the Apple Macintosh in 1985 and for Windows two years later. Early versions were praised for their graphical interface, which let users adjust column widths and headings with a mouse rather than by typing instructions. The struggle for the market was not settled immediately, because many companies had spent years writing templates and training staff to use Lotus 1-2-3. But Excel was sold alongside word-processing and presentation software in a single package, and by the early 1990s it had become the leader.

Later changes have concerned capacity as much as features. For many years Excel was limited to 65,536 rows and 256 columns; the version released in 2007 raised these limits to 1,048,576 rows and 16,384 columns, more than a thousand times as many cells. The change reflected the falling cost of computer memory and the appetite of users, who now employ spreadsheets for tasks the inventors never imagined, from school timetables and mailing lists to the analysis of scientific data and the costing of building projects.

The spreadsheet has also produced legal argument. Rival companies that copied the sequence of commands in the Lotus 1-2-3 menus were sued, and in 1995 a federal appeals court in the United States decided that this menu structure was a method of operation and therefore could not be protected by copyright. The Supreme Court divided evenly on the question in 1996, which left the appeals court's decision in place.

Mistakes remain the technology's weakness. Because a formula is copied invisibly down a column or across a row, an error in one cell can spread through an entire model, and researchers who have audited spreadsheets used in business and government have repeatedly found errors in a substantial proportion of the files they examined. A misplaced decimal point, or a range of cells that stops one row short of the last entry, may be invisible on screen and yet produce a plausible but wrong total. Modern programs can trace which cells feed into a result, but no tool can supply the judgement that the person building the model must exercise.

Few pieces of software have changed office life so thoroughly. The electronic spreadsheet did not merely speed up arithmetic; it made possible a style of planning in which assumptions are altered and their consequences seen at once. Its descendant is now so familiar that a grid of cells seems an obvious way to arrange numbers, yet before 1979 no such thing existed.

Tip: select any text in the passage to highlight it in one of four colours. Click a highlight to remove it.

Questions 1–6◎ Practise this set only

Complete the sentences below. Choose ONE WORD ONLY from the passage for each answer.

Write ONE WORD ONLY for each answer.

On paper, any change to a single figure meant that the and every dependent figure had to be worked out again.
Only a small of the grid could be seen on the screen at one time.
Lotus 1-2-3 was designed for a computer with more memory and a faster than the Apple II.
Excel was sold together with word-processing and presentation software as a single .
The version of Excel released in 2007 could hold more than a thousand times as many as earlier versions.
The appeals court decided that the structure of Lotus's menus could not be protected by .

Questions 7–13◎ Practise this set only

Do the following statements agree with the information given in Reading Passage 1? Choose TRUE if the statement agrees with the information, FALSE if the statement contradicts the information, or NOT GIVEN if there is no information on this.

VisiCalc was designed to run on the IBM Personal Computer.
Some purchasers bought a computer only because they wanted to use VisiCalc.
Bricklin and Frankston became wealthy from the sales of VisiCalc.
Lotus 1-2-3 could produce graphs as well as hold tables of figures.
Excel took over from Lotus 1-2-3 as soon as it was launched.
Most spreadsheet errors are eventually noticed by the people who built the model.
The spreadsheet changed the way planning was carried out, not just the speed of calculation.

About this reading test

A full IELTS Academic Reading practice test with 40 questions on three original technology passages: the invention of the electronic spreadsheet, how edge computing moves processing closer to users, and whether rented electric scooters belong in cities. Includes explanations and a band estimate.

PartPassageQuestionsQuestion typesTopicsWords
1The Rise of the Spreadsheet1–13Sentence completion, True / False / Not GivenInventions, Technology, Business & Economics888
2Computing at the Edge14–26Matching information, Multiple choice (choose more than one), Summary completionTechnology, Science871
3Scooters and the City27–40Multiple choice, Yes / No / Not Given, Summary completion (word list)Transport, Environment, Architecture & Cities833

How to use this practice test

  • Take the full test in 60 minutes, or practise one passage in 20 minutes.
  • Select text in the passage to highlight it, and click a question number to flag it for review.
  • Drag answers from a list into the gaps, or tap a gap to choose from a menu.
  • When you submit, each answer is marked right or wrong, with an explanation and a “Show in passage” button that highlights the sentence that proves it.
  • For gap-fill questions, keep to the word limit; an answer over the limit is marked wrong, as in the real exam.

All passages and questions on Sprechify are written by our own team in the official IELTS format. They are not taken from Cambridge IELTS books or any other published test. Band scores are estimates based on the conversion commonly used for practice tests.

More IELTS reading practice tests

All IELTS reading tests →More Inventions passagesMore Technology passagesMore Business & Economics passagesMore Science passagesMore Transport passagesMore Environment passagesMore Architecture & Cities passages