Computer Science/IT MCQs
Topic Notes: Computer Science/IT
MCQs and preparation resources for competitive exams, covering important concepts, past papers, and detailed explanations.
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
391
Which function is used to return the current system date?
Answer:
Today
The `TODAY()` function in Excel is a volatile function that returns the current date based on the computer's system clock. It takes no arguments and will automatically update whenever the worksheet is recalculated.
392
Which symbol is used in absolute referencing?
Answer:
$
The dollar sign ($) is used in Excel to create absolute or mixed cell references. Placing it before a column letter locks the column, and placing it before a row number locks the row when a formula is copied.
393
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.
394
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.
395
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.
396
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.
397
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.
398
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.
399
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.
400
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.