Tag: information communication technology (ict)

Questions Related to information communication technology (ict)

The _______ is the arrangement of various flash elements, like panels, menus, bars, windows etc.

  1. Tools Panel

  2. Menu

  3. Stage

  4. Workspace


Correct Option: D
Explanation:

To show the workspace surrounding the Stage, or to view elements in a scene that are partly or outside of the Stage area, select View > Pasteboard. The pasteboard appears in light gray. For example position the bird outside of the Stage in the pasteboard and animate it into the Stage area.

An application program that helps the user to change any number and immediately see the result of that change is 

  1. Desktop publishing

  2. Database

  3. Spreadsheet

  4. All of above


Correct Option: C
Explanation:

An application program that helps the user to change any number and immediately see the result of that change is Spreadsheet.

spreadsheet programs. Today, Microsoft Excel is the most popular and widely used spreadsheet program, but there are also many alternatives. Below is a list of spreadsheet programs that can be used to create a spreadsheet. Google Sheets - (Online and free) iWork Numbers - Apple Office Suite.

A spreadsheet is an interactive computer application for organization, analysis and storage of data in tabular form. Spreadsheets are developed as computerized simulations of paper accounting worksheets. The program operates on data entered in cells of a table.

An application is any program, or group of programs, that is designed for the end user. Applications software (also called end-user programs) include such things as database programs, word processors, Web browsers and spreadsheets.

A spreadsheet is an interactive computer application for organization, analysis and storage of data in tabular form. Spreadsheets are developed as computerized simulations of paper accounting worksheets. The program operates on data entered in cells of a table.

Asha was entering data into a worksheet and in the cell A$3$ she entered the formula $=A1+A2+A3$. What would be the result after pressing the Enter key?

  1. Sum of $A1$, $A2$ and $A3$

  2. Name Error

  3. $####$

  4. Circular Reference Warning


Correct Option: D
Explanation:

Circular reference occurs when a cell in worksheet refers to itself, the formula $=A1+A2+A3$ is entered in cell $A1$, so it will generate a circular reference warning.

Communication between computer and a keyboard involves.

  1. Simplex transmission

  2. Full duplex transmission

  3. Half duplex transmission

  4. Automatic transmission


Correct Option: A
Explanation:

Communication between computer and a keyboard involves Simplex transmission.

Simplex communication is a communication channel that sends information in one direction only. The International Telecommunication Union definition is a communications channel that operates in one direction at a time, but that may be reversible; this is termed half duplex in other contexts.

An advantage of half-duplex is that the single track is cheaper than the double tracks. A full duplex communication channel is able to transmit data in both directions on a signal carrier at the same time. It is constructed as a pair of simplex links that allows bidirectional simultaneous transmission.

The intersection of a column and row in a spreadsheet is called a bon of.

  1. Key

  2. Field

  3. Cell

  4. Menu

  5. None of the above


Correct Option: C
Explanation:

The intersection of a column and row in a spreadsheet is called a bon of Cell.

The INTERSECTION of a row and column is called a CELL. Also called a spreadsheet. The intersection of a column and row on a worksheet. You enter data into cells to create a worksheet. The active cell contains the cell pointer. Alternatively, in a table (which I assume you're referring to),

rows are "horizontal" collections of items belonging to a certain category; columns are "vertical" collections. Each item (orange) in the table "belongs" to one row (yellow) and one column (red).

In a spreadsheet, a _______ is a number you will use in a calculation.

  1. Label

  2. Cell

  3. Field

  4. Value

  5. None of these


Correct Option: D
Explanation:

In a Spreadsheet, a Value is a number you will use in a calculation.

A spreadsheet program is Electronic paper  also called a Worksheet. With MS Excel, you can have multiple worksheets contained in a WorkBook .

What would be the result of the given formula in MS-Excel $2010$, if cell A$1$ = $2016$?
                  = REPLACE (A$1, 3, 2, "17")$

  1. $20117$

  2. $2017$

  3. $17$

  4. $2016 - 17$


Correct Option: B

Considering the given snapshot, where cells A$$: A$4$ has been named as "NUMBER" with the help of Define Name feature of MS-Excel $2010$. what would be the result of the given formula in MS-Excel $2010$?
                             = COUNT(NUMBER)

  1. $1$

  2. $2$

  3. $3$

  4. $4$


Correct Option: B

In table in excel, there are typical labels along with _________.

  1. Letters

  2. Numbers

  3. Names

  4. Formulae

  5. None of these


Correct Option: B
Explanation:

In table in excel, there are typical labels along with Number’s.

Entering data into a spreadsheet is just like typing in a word processing program, but you have to first click the cell in which you want the data to be placed before typing the data.  All words describing the values (numbers) are called labels. The numbers, which can later be used in formulas, are called values.

_________ is the short-key to move to the next worksheet.

  1. CTRL$+$Pagedown

  2. CTRL$+$Pageup

  3. CTRL$+$Right arrow

  4. CTRL$+$Left arrow


Correct Option: A
Explanation:

CTRL+ Pagedown : Move to the next sheet in a workbook. 

ALT+Pagedown: Move one screen to the right in a worksheet.