Data | MCQs

Explanation

• Pressing the Esc key cannot be used to enter data in a cell in MS Excel
  
• Esc key is used to interrupt or cancel the current process or running program, or to close a pop-up window.

Explanation

Microsoft Access (MS Access) organizes data in tables, which are the fundamental building blocks of any database: 

Data organization: Stores data in tables with rows and columns

Data types: Supports various data types, such as text, number, date/time, currency, and more

*************

VU CBT FIA PAPER 26-12-2021

Explanation

In a spreadsheet, the data is organised in columns and rows. 

Explanation

ORACLE is a Database Management System (DBMS) used for storing, retrieving, and managing data in databases.

ORACLE is specifically designed to handle database operations.

Explanation

Correct sum = (36 * 50 + 48 – 23) = 1825.

Correct mean = 1825/50 = 36.5

Explanation

DBMS is a software system that allows users to create, manage, and manipulate databases.

It ensures data integrity, security, and easy access to data.

Explanation

Sabotage refers to the intentional destruction or damage of data or systems.

It involves deliberate harmful actions, unlike accidental data loss or hardware failures.

Explanation

The set of all possible values of data items is called domain.

A relational table's column structure is defined by a domain.

In a domain, there exist values.

They belong to a database domain, which is a column.

Explanation

Bandwidth refers to the amount of data transmitted per second.

It is measured in bits per second (bps).

It indicates the speed or capacity of a network connection.

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