Data | MCQs

Explanation

1000MB = 1GB

Explanation

A PivotTable helps you calculate, summarize, and analyze data efficiently.

It lets you spot comparisons, patterns, and trends within large datasets.

Explanation

Conditional Formatting highlights data based on rules, making patterns easy to spot.

It provides visual cues like colors or icons to quickly understand data trends.

Explanation

A unique constraint is a rule that forbids duplicate values in one or more columns within a table. Unique and primary keys are the supported unique constraints.

Explanation

A byte is a unit of digital information.

that most commonly consists of eight bits.

Explanation

A field is also known as a column

that stores the same type of data and hence can be called a category of data.

Explanation

The purpose of the TRANSPOSE function in Excel is to convert rows to columns,

i.e. switch the orientation of a given range from horizontal to vertical or vice versa.

The function takes just one argument:

TRANSPOSE(array)

Where array is the range of cells to transpose.

Explanation

Transpose (rotate) data from rows to columns or vice versa.

To use options from the Paste Special box, click Home > Paste > Paste Special > Transpose

Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK

Explanation

Transpose (rotate) data from rows to columns or vice versa.

To use options from the Paste Special box, click Home > Paste > Paste Special > Transpose

Explanation

A bar chart or bar graph is a chart or graph that presents categorical data with rectangular bars with heights or lengths proportional to the values that they represent.

The bars can be plotted vertically or horizontally.

A vertical bar chart is sometimes called a column chart

**** 

RY19012023