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
2151
Which function puts the current time into a worksheet cell?
Answer:
=NOW()
The NOW function returns the current date and time.
2152
What does the function =TODAY() return?
Answer:
The current system date
=TODAY() inserts today’s date.
2153
When formatting a cell as Number, which can NOT be set?
Answer:
Currency symbol
The Number format omits currency symbols; that's for Currency format.
2154
When formatting a cell as Currency, you can specify:
Answer:
Both of above
You can choose both decimal places and the currency symbol.
2155
How can you make text automatically fit within a cell’s width?
Answer:
All of the above
Any of these actions help text fit the cell width.
2156
Can you apply a 0.5 inch left indentation to a cell in Excel?
Answer:
You can set indentation through the Format Cells dialog box
Indent settings for cells are available in the Format Cells dialog Alignment tab.
2157
How can you display text vertically in a cell?
Answer:
Set 90 Degrees in the Orientation section of Format Cells dialog
To display text vertically, set Orientation to 90 Degrees in the Format Cells dialog box.
2158
The Spelling tool is located on which toolbar?
Answer:
Standard
The Standard toolbar in Excel contains the spelling check tool.
2159
Which of the following is NOT a valid Zoom percentage in Excel?
Answer:
500
Excel’s Zoom options typically range from 10% to 400%. 500% is not offered as a standard choice.
2160
What is the shortcut key to select an entire column in Excel?
Answer:
None of these
The correct shortcut is clicking on the column letter or pressing Ctrl + Spacebar.