Computer Awareness Mixed Quiz: Set 11

Division by zero has no answer in arithmetic, so Excel refuses to invent one and writes #DIV/0! instead.

In the 8085A microprocessor the program counter is a 16-bit register that always holds the memory address of the next instruction, or op-code, to be fetched.

From PowerPoint 2007 onwards the default save format is the XML-based Open Office format, whose extension is.pptx, and PowerPoint 2016 follows it.

The 56 K rating of a modem means it can transfer data at up to 56 kilobits per second, so the figure describes speed, not size.

ARPANET was funded by the Advanced Research Projects Agency of the United States Department of Defense, and in 1969 it linked computers at four American universities and passed its first message between them.

EBCDIC is an 8-bit character encoding scheme developed by IBM in 1963 for its mainframe and midrange computers. Because it uses 8 bits for each character it can represent 256 different characters, twice as many as the 7-bit ASCII code, which handles 128.

Data can travel between two devices in three modes. In half-duplex mode both devices can send and receive, but only one of them may transmit at any given moment, so the traffic takes turns; a walkie-talkie is the standard example, and older hubs and CB radio worked the same way.

The plain remove-directory command is built to delete an empty folder only. In Windows it is rmdir, also written rd, and in Linux it is rmdir; both stop with a message such as "The directory is not empty" when anything is still inside.

COUNT walks through the range and counts only the cells that hold a numeric value, which includes dates and times because Excel stores them as serial numbers.

In an entity relationship diagram each symbol has a fixed meaning, and an attribute that can hold more than one value for the same entity, such as a person's several phone numbers, is drawn as a double ellipse.

It lays every slide of the deck side by side as a thumbnail, so a slide can be dragged to a new position, copied, hidden or deleted, and the flow of the whole presentation can be judged at a glance.

A high-level language is written in words close to English and has to be turned into machine code by a compiler or an interpreter, so the programmer need not know the processor at all.

Working at CERN in Switzerland, he proposed a system of linked documents in 1989, wrote the first browser and server, and put the first website online in 1991.

Cloud computing is sold in three service models, and PaaS is the middle one.

Columns are lettered A to Z, then AA to AZ, BA to BZ and so on, and the 16,384th column of the enlarged grid falls at XFD.

The National Digital Library of India is a single window that brings together lakhs of learning resources, from school books to research papers, and lets a student search them free of cost in many Indian languages.

It adds a fresh slide below the selected slide, using the layout of the current one.

Ray Tomlinson sent the first message between two computers on ARPANET in 1971 and needed a character that would never appear in a person's name.

Pressing Ctrl + 3 turns the contents of the selected cell or range italic in Microsoft Excel, and pressing it again removes the italics; Ctrl + I does exactly the same job.

A transition is the visual effect between two slides — Fade, Push, Wipe, Split or Morph — and its gallery, duration, sound and advance timing all sit on the Transitions tab.