Data | MCQs

Explanation

The size of information in the computer is measured in Kilobytes (KB), Megabytes (MB), Gigabytes (GB), and Terabytes (TB).

1024 kilobytes (KB) is equal to 1 megabyte (MB).

One Megabyte (MB) = 1024 Kilobytes (KB

One Gigabyte (GB) =  1024 Megabytes MB

One Terabyte (TB)= 1024 gigabytes (GB).

Explanation

TEXT data type contains all types of text data type.

It comprises more than single-byte character that is supported by the system.

Explanation

When we insert an excel file into a word document and keep the source file linkage when data is updated in source file update data in liked file also. The data are Linked.

In Embedded objects file become part of document and does not get updated when source file is updated.

Explanation

CDs are circular discs that are 4.75 in (12 cm) in diameter.

The CD standard was proposed by Sony and Philips in 1980 and the technology was introduced to the U.S. market in 1983.

*******

VU FIA PAPER 18-12-2021

Explanation

For highlighting a column CTRL+space is used.

while

Shift + space is used for row.

shortcut key in  MS Excell:

which key is used for help in MS excel?

 F1

***

Which is the shortcut key to display active cells in Excell?

Shift+Backspace

**

Which key is used to enter the current date in Excel?

 Ctrl+;

***

Which key is used for the GO TO tab in Ms. Excel?

 F5 

***

Which key is used for excel column highlight?

CTRL + space

****

What is the keyboard shortcut to insert a SUM formula in MS Excel?

 ALT + =

***

The delete key of the keyboard is assigned to which command in excel?

 Edit > Clear > Contents

****

The shortcut key to insert a new worksheet in Excel is _____.

 Shift + F11

****

in excel which key is used to format numbers in comma format?

 shift+1

*****

In Excel which shortcut key is used to go to the formula tab?

 Alt+M

ND11-3-2023

ND29-5-2023

Explanation

KB stands for Kilobyte

MB stands for Megabyte

GB stands for Gigabyte

TB stands for Terabyte

Explanation

• In MS Excel, you can copy data or formulas using Edit menu commands, shortcut menu options, or toolbar buttons like "Copy" and "Paste."
• These methods offer flexibility for users to quickly replicate data or formulas across cells or worksheets.

Additional Points:

• Keyboard Shortcuts: Use Ctrl + C (Copy) and Ctrl + V (Paste) for efficiency.
• Drag and Drop: Copy formulas by dragging the fill handle at the corner of a selected cell.
• Right-Click Menu: Provides quick access to copy/paste commands directly.
• Paste Special: Allows pasting specific attributes (e.g., values, formats) using Alt + E + S.

Explanation

A chart is a graphical representation of data.

It typically used to visualize information clearly and concisely.

Explanation

A report is the output of a database application, designed to present data in a readable format.

Reports summarize and analyze data from tables or queries.

This making it easy for users to interpret the information.

Explanation

In computer disk storage, a sector is a subdivision of a track on a magnetic disk or optical disc.

****

RY17-012-23