What happens when you select a cell in MS Excel and press 'Ctrl + ;' (Control + Semicolon)? MCQ with Answer and Explanation

Question
What happens when you select a cell in MS Excel and press 'Ctrl + ;' (Control + Semicolon)?
A. The current system date is inserted
B. The cell formulas are hidden
C. The current system time is inserted
D. The column is completely deleted
Answer: Option A
Solution (By JKSSB Mock Tests)
Ctrl + ; inserts the current system date into the cell, whereas Ctrl + Shift + : (Colon) inserts the current system time.
This question belongs to: Computer Microsoft Office
Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1
What will be the output of the MS Excel formula =CEILING.MATH(14.2, 5)?
A. 14
B. 15
C. 10
D. 20
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The CEILING.MATH function rounds a number up to the nearest specified multiple. The nearest multiple of 5 greater than or equal to 14.2 is 15.
This question belongs to: Computer Microsoft Office
Question #2
Which tab on the ribbon layout houses options to insert footnotes, endnotes, captions, and an automated table of contents in MS Word?
A. Design Tab
B. Insert Tab
C. Review Tab
D. References Tab
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The References tab consolidates all formal academic reference indexing features, including bibliographies, table of contents, and citations.
This question belongs to: Computer Microsoft Office
Question #3
What is the shortcut key to open the 'Thesaurus' in MS Word?
A. Alt + F7
B. F7
C. Shift + F7
D. Ctrl + F7
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Shift+F7 opens the Thesaurus. F7 runs spell check.
This question belongs to: Computer Microsoft Office
Explore All Microsoft Office MCQs
Today's Top Topics
Computer Networking 325 Microsoft Office 1199 CPU (Central Processing Unit) 327 Cyber Security 269 Memory and Storage Devices 438
Explore Subjects
Geography GK 6121 Current Affairs 575 History GK 3374 Accountancy and Statistics 3179 Maths 5575
Practice Mix
Select the most appropriate meaning of the idiom: 'Make a mountain out of a molehill'.
What does the 'GUI' acronym stand for in computer interface terminology?
A trader marks his goods 80% above cost price and gives a discount of 40%. Find his gain percent.
Which type of memory is used to store the firmware that boots the computer?
The average of 8 numbers is 30. If one number is 40, find the average of the remaining 7.