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
7751
Which function is used to get the current date?
Answer:
Today()
To insert the current date into a cell, you use the `TODAY()` function. For example, typing `=TODAY()` into a cell will display the current date, which will update each time the workbook is opened.
7752
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.
7753
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.
7754
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.
7755
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.
7756
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.
7757
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.
7758
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.
7759
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.
7760
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.