Data | MCQs

Explanation

An apostrophe before a cell value forces Excel to interpret the value as text.

This is mostly useful for values that look like a number or date.

Explanation

A spreadsheet is a file that exists of cells in rows and columns and can help arrange, calculate and sort data.

Data in a spreadsheet can be numeric values, as well as text, formulas, references and functions.

Explanation

The Huffman encoding scheme takes advantage of the disparity between frequencies and uses less storage for the frequently occurring characters at the expense of having to use more storage for each of the more rare characters.

Explanation

Petabyte (PB), a unit of information equivalent to 1000 terabytes which is used, for example, to quantify computer memory or storage capacity.

Explanation

Tabulation is the presentation of figures from an investigation in a table which consists of rows and columns of cells, or spaces, each of which provides one unit of information.

Explanation

Explanation

If the database operations do not update the database but only retrieve data, this type of transaction is called a read-only transaction.

If the database were in an inconsistent state before a transaction, it would remain in the inconsistent state after the transaction.

Explanation

A memorandum is a written message that is typically used in a professional setting.

Commonly known as a "memo," these messages are typically brief and easily understood.

Explanation

Encryption is a means of securing digital data using one or more mathematical techniques, along with a password or "key" used to decrypt the information. 

Explanation

A Pivot Table in Excel is used to quickly summarize, analyze, explore, and present large sets of data.

It helps in organizing data by categories, totals, averages, and filters without altering the original dataset.