Computer Science - IT MCQs
Topic Notes: Computer Science - IT
<p>MCQs and preparation resources for competitive exams, covering important concepts, past papers, and detailed explanations.</p>
Plato
- Biography: Ancient Greek philosopher (427–347 BCE), student of Socrates and teacher of Aristotle, founder of the Academy in Athens.
- Important Ideas:
- Theory of Forms
- Philosopher-King
- Ideal State
2511
Which symbol is used before a formula?
Answer:
=
To signal to Excel that you are entering a formula or a function into a cell, you must always begin the entry with an equal sign (=). This tells the program to calculate the result rather than display the entry as text.
2512
Which is an absolute address?
Answer:
None
A true absolute address requires a dollar sign ($) before both the column letter and the row number (e.g., `$A$1`). None of the options provided meet this requirement. `A1` is relative, and `A1$` is an invalid format.
2513
Which of the following is an absolute address?
Answer:
$A$1
An absolute cell reference in Excel is denoted by placing a dollar sign ($) before both the column letter and the row number, as in `$A$1`. This type of reference does not change when the formula is copied or filled to other cells.
2514
Which represents a valid range in Excel?
Answer:
C1:C3
A range of adjacent cells in Excel is represented by the address of the first cell and the last cell, separated by a colon (:). Therefore, `C1:C3` correctly denotes the range including cells C1, C2, and C3.
2515
Which menu contains the 'Name' command?
Answer:
Insert
In older menu-driven versions of Excel, the commands for defining and managing named ranges were located under the "Insert" menu, specifically under "Insert > Name". In the ribbon interface, these commands are on the "Formulas" tab.
2516
Which menu contains the 'Cells' command?
Answer:
Format
In classic menu-based versions of Excel, the "Format" menu contained the "Cells..." command, which opened the comprehensive Format Cells dialog box. In the modern ribbon interface, these options are found on the "Home" tab.
2517
Which represents a label?
Answer:
Mubeen Ahmad
In a spreadsheet, a "label" refers to text entered into a cell. It is used for titles, headings, and descriptions and is not used in calculations. A number like "736" is a value, and "=A1 + B2" is a formula.
2518
Which cell address is correct?
Answer:
Both a and b
In Excel, a valid cell address consists of a column letter(s) followed by a row number. Both "Z2" (column Z, row 2) and "AZ3" (column AZ, row 3) follow this rule. "2Z" is incorrect because the row number cannot come before the column letter.
2519
Which of the following is not a feature of spreadsheet programs?
Answer:
WordArt
The core features of a spreadsheet program are its grid of rows and columns, the ability to use formulas for calculations, and functions for printing the data. WordArt is a feature for creating decorative text, which is more commonly associated with word processing or presentation software.
2520
Which of the following is a spreadsheet?
Answer:
MS Excel
MS Excel is the spreadsheet application within the Microsoft Office suite. It is designed for organizing, analyzing, and storing data in a tabular format using a grid of rows and columns.