Computer Awareness GK Questions with Answers – Page 25

The Internet of Things means giving everyday objects — machines, sensors, meters, shelves, vehicles — an address on the internet so that they can report what they sense and be controlled from a distance.

A proxy firewall, also called an application gateway, stands between the client and the server as a stand-in for both, opens each message and filters it at the application layer, so it can read a URL, a command or an attachment before passing the request on.

Drupal is a content management system, a free program used to build and run websites; it keeps its pages in a database but is not itself a database management system.

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.

An IPv4 address, which is what the question means by an IP address, is thirty-two bits long.

F1 is the function key that opens Help in Windows and in almost every Microsoft Office program, which is why it is the first key on the row.

Java is an object-oriented programming language, so it is the right pick for Preet.

A packet filtering firewall works at the network layer, the third layer of the OSI model, where it reads the header of every incoming and outgoing packet and compares the source and destination IP address, the port number and the protocol against a list of rules, then allows the packet…

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

DASD stands for Direct Access Storage Device. It is any storage device on which the read-write head can be sent straight to the place where a record is kept, so a file can be reached without passing over everything stored before it.

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.

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.

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

A dollar sign locks the part of the address that follows it, so $A$1 has both the column and the row locked and keeps pointing at cell A1 however far the formula is copied.

Excel treats whatever follows an equals sign as something to be calculated, so =A1+B1 adds the two cells and =SUM(A1:A10) totals a range.

From Excel 2007 the grid of one worksheet was enlarged to 1,048,576 rows and 16,384 columns, so the very last cell of the sheet is XFD1048576.

From Excel 2007 onwards the suite moved to the Office Open XML formats, and a plain workbook saves with the.xlsx extension.

Ctrl together with F2 opens the print area of the Backstage view in Excel, Word and PowerPoint, where the page is shown exactly as it will be printed and the printer, copies, orientation and margins can be set.

An electronic spreadsheet stores data in a grid of rows and columns and recalculates its formulas whenever a value changes, and Excel is the spreadsheet program of the Microsoft Office suite.

LEN returns the number of characters in an entry, counting letters, digits, punctuation and spaces alike, so =LEN("Excel") gives 5.