Data Management | MCQs

Explanation

We can paste formula, value, formats, comments, validation using Paste Special command.

Explanation

All important questions about "MS EXCEL"

Microsoft Excel is a spreadsheet application launched in 1985 by the Microsoft Corporation.

MS-Excel uses the _____ function when creating a data table.

spreadsheet

****

Which of the following functions in Microsoft Excel is used to count items in a cell range?

Count

***

In MS Excel, which function automatically total a column or row of values?

SUM

***

MS Excel's function arguments are always written in----------?

Parenthesis

***

In MS Excel, which function automatically totals a column or row of values?

SUM

****

Columns in MS Excel are called?

Fields

***

Constant value in excel also called?

Number

***

Ctrl +D in MS Excel?

Fill down in the selection

***

Ctrl+R is used in Excel too?

Fill the selection with active cells to the right

***

MOD () function is used in MS Excel to get

Remainder

****

ND30-4-2023

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

The correct term for a repository for data, usually covering a specific topic, is a "database" or a "data repository."

Explanation

File Manager helps users manage files and folders (copy, move, delete, etc.).

It is a utility program that supports the operating system's functionality.

Explanation

A Database Administrator (DBA) is responsible for the design, implementation, maintenance, and repair of a database.

They ensure that the database operates efficiently, securely, and reliably.

Explanation

Data acquisition refers to the process of collecting data, not a primary objective of a database.

The main objectives of a database include Data Independence, Data Integration, and Data Integrity, which focus on organizing, managing, and ensuring the accuracy of data.

Explanation

File folders are used to organize papers in files, protect papers in files, sort files, and keep files safe and organized.

A folder is a virtual area on a computer where applications, documents, data, and other sub-folders can be stored.ta retrieval. 

Explanation

Data governance is indeed the practice of:

1. Identifying Important Data: Recognizing which data is critical for the organization's operations and decision-making processes.
2. Ensuring Data Quality: Implementing policies and procedures to maintain high data quality, including accuracy, consistency, and reliability.
3. Improving Data Value: Enhancing the usability and value of data to support business objectives and strategic goals.

Explanation