MCQ on Shortcut Keys for MS Excel – Computer GK
Useful and informative MCQ on Shortcut Keys for MS Excel – Computer GK that will elevate your spreadsheet skills by focusing on the keyboard shortcuts that can streamline your data management tasks. Whether you’re a spreadsheet novice or a seasoned user, this quiz will help you become a true Excel expert.
These MCQ on Shortcut Keys for MS Excel – Computer GK are very helpful for competitive exams such as CPCT, GATE, IES/ESE, IBPS PO, IBPS Clerk, SBI PO, SBI Clerk, RBI, SEBI, LIC, NICL, BCA, B.Sc. IT, DCA, SSC, RRB, NIELIT CCC, CTET, UDC NET, CUET, MCA, PGDCA, MCS, TET, State Police, BPO, etc.
These MCQ on Shortcut Keys for MS Excel – Computer GK have correct answers and brief explanations of each question for better understanding.
Q21. What does the Ctrl + Y shortcut do in MS Excel?
a) Redo the last action
b) Cut selected cells
c) Paste selected cells
d) Delete selected cells
Show Answer
Correct Answer: a) Redo the last action
Explanation: In MS Excel, the Ctrl + Y shortcut is used to redo the last action that was undone. This allows users to quickly reverse an undo operation if they change their mind or make a mistake.
Q22. What does the Ctrl + 5 shortcut do in MS Excel?
a) Copy selected cells
b) Cut selected cells
c) Paste selected cells
d) Apply or remove strikethrough formatting
Show Answer
Correct Answer: d) Apply or remove strikethrough formatting
Explanation: In MS Excel, the Ctrl + 5 shortcut is used to apply or remove strikethrough formatting on the selected text or cell contents. This is useful for indicating that specific data or text has been revised or is no longer relevant.
Q23. What does the Ctrl + O shortcut do in MS Excel?
a) Open an existing workbook
b) Cut selected cells
c) Paste selected cells
d) Delete selected cells
Show Answer
Correct Answer: a) Open an existing workbook
Explanation: In MS Excel, the Ctrl + O shortcut is used to open an existing workbook. This allows users to quickly access and work on previously saved Excel files.
Q24. What does the Ctrl + N shortcut do in MS Excel?
a) Copy selected cells
b) Cut selected cells
c) Paste selected cells
d) Create a new workbook
Show Answer
Correct Answer: d) Create a new workbook
Explanation: In MS Excel, the Ctrl + N shortcut is used to create a new workbook. This allows users to quickly start working on a new Excel file without having to navigate through menus.
Q25. What does the Ctrl + F9 shortcut do in MS Excel?
a) Minimize the workbook window
b) Cut selected cells
c) Paste selected cells
d) Delete selected cells
Show Answer
Correct Answer: a) Minimize the workbook window
Explanation: In MS Excel, the Ctrl + F9 shortcut is used to minimize the workbook window. This allows users to quickly hide the Excel window while working on other tasks or applications.
Q26. What does the Ctrl + F10 shortcut do in MS Excel?
a) Maximize or restore the workbook window
b) Cut selected cells
c) Paste selected cells
d) Delete selected cells
Show Answer
Correct Answer: a) Maximize or restore the workbook window
Explanation: In MS Excel, the Ctrl + F10 shortcut is used to maximize or restore the workbook window. This allows users to quickly switch between a full-screen view and a smaller window view of their Excel file.
Q27. What does the Ctrl + P shortcut do in MS Excel?
a) Copy selected cells
b) Cut selected cells
c) Paste selected cells
d) Open the Print dialog box
Show Answer
Correct Answer: d) Open the Print dialog box
Explanation: In MS Excel, the Ctrl + P shortcut is used to open the Print dialog box. This allows users to quickly access print settings and options for their workbook, making it easy to print their data and charts.
Q28. What does the Ctrl + Z shortcut do in MS Excel?
a) Undo the last action
b) Cut selected cells
c) Paste selected cells
d) Delete selected cells
Show Answer
Correct Answer: a) Undo the last action
Explanation: In MS Excel, the Ctrl + Z shortcut is used to undo the last action performed. This allows users to quickly reverse a mistake or an unwanted change made in their worksheet.
Q29. What does the Ctrl + F6 shortcut do in MS Excel?
a) Switch between open workbooks
b) Cut selected cells
c) Paste selected cells
d) Delete selected cells
Show Answer
Correct Answer: a) Switch between open workbooks
Explanation: In MS Excel, the Ctrl + F6 shortcut is used to switch between open workbooks. This allows users to quickly navigate between multiple Excel files that are open at the same time.
Q30. What does the Ctrl + (number) shortcut do in MS Excel, where (number) is a digit between 0 and 9?
a) Apply a specific number format
b) Cut selected cells
c) Paste selected cells
d) Delete selected cells
Show Answer
Correct Answer: a) Apply a specific number format
Explanation: In MS Excel, the Ctrl + (number) shortcut, where (number) is a digit between 0 and 9, is used to apply a specific number format to the selected cells. This allows users to quickly format their data as currency, percentage, date, or other number formats.
More MCQ on Computer GK for Competitive Exams
- Introduction to Computer
- Basic Computer Organization
- Number Systems
- Computer Codes
- Processor and Memory
- Secondary Storage Devices
- Input and Output Devices
- Computer Software
- Flowchart and Computer Languages
- System Implementation
- Operating Systems
- Application Software Packages
- Business Data Processing
- Communications and Networks
- Internet Concepts and IoT
- Multimedia and File Extensions
- Classification of Computers
- Cyber Safety and Cyber Crime
- Computer Viruses and Security
- Basic Computer Shortcut Keys
- Shortcut Keys for Windows
- Shortcut Keys for MS Excel
- Shortcut Keys for MS Word
- Computer Abbreviations Set 1
- Computer Abbreviations Set 2
- Computer Abbreviations Set 3
Get free Text Content Tools, Website Management Tools, Development Tools, Binary Converter Tools, Unit Converter Tools and SEO Tools on EuWebTools.