MICR | MCQs

Explanation

Data sheet can not be a sheet in workbook.

Explanation

To removes a sheet from workbook select the sheet, then choose Edit > Delete Sheet these options available in excel 2003 and earlier version.

Explanation

Ctrl + P is the shortcut key to print.

Explanation

Dragging is used to move an object from one position to another position on the computer screen.

Explanation

On the Data tab, in the Data Tools group, click Text to Columns.

The Convert Text to Columns Wizard opens.

Choose Delimited if it is not already selected, and then click Next.

Select the delimiter or delimiters to define the places where you want to split the cell content.

Explanation

In MS Access, columns in a table are called fields.

It store specific types of data for each record.

Rows in an MS Access table are called Records.

It representing individual entries or data points within the table.

Explanation

In Microsoft Access, the "Number" data type is used to store numerical values, including quantities.

This data type allows you to store whole numbers, decimal numbers, or a combination of both.

Explanation

The "Datasheet View" in MS Access is the option

That allows you to add a new record in a tabular form due to its format and functionality designed for efficient data entry and manipulation within tables.

Explanation

In MS Access, the default data type for a new field in a table is typically set to "Short Text" (previously referred to as "Text" in older versions).

This data type is used to store alphanumeric data up to 255 characters in length.

Explanation

the view used to define the structure of a table is called "Design View."

This view allows you to specify:

• the table's fields
• data types
• validation rules
• default values
• other properties that define its structure