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.
Q11. What does the Alt + Shift + F1 shortcut do in MS Excel?
a) Create a chart from the selected data
b) Insert a new worksheet
c) Open the Go To dialog box
d) Toggle between displaying cell values and formulas
Show Answer
Correct Answer: b) Insert a new worksheet
Explanation: In MS Excel, the Alt + Shift + F1 shortcut is used to insert a new worksheet. This allows users to quickly add a new sheet to their workbook for organizing and managing data more efficiently.
Q12. What does the Shift + F3 shortcut do in MS Excel?
a) Open the Find and Replace dialog box
b) Insert a function
c) Open the Go To dialog box
d) Start the spell check
Show Answer
Correct Answer: b) Insert a function
Explanation: In MS Excel, the Shift + F3 shortcut is used to open the Excel function window, which allows users to insert a function into a cell or formula.
Q13. What does the Shift + F5 shortcut do in MS Excel?
a) Open the Find and Replace dialog box
b) Edit the active cell
c) Open the Go To dialog box
d) Start the spell check
Show Answer
Correct Answer: a) Open the Find and Replace dialog box
Explanation: In MS Excel, the Shift + F5 shortcut is used to open the Find and Replace dialog box, which allows users to search for specific data or text within the worksheet and replace it with new data or text.
Q14. What does the Ctrl + B shortcut do in MS Excel?
a) Bold the selected text
b) Cut selected cells
c) Paste selected cells
d) Delete selected cells
Show Answer
Correct Answer: a) Bold the selected text
Explanation: In MS Excel, the Ctrl + B shortcut is used to bold the selected text or cell contents. This is useful for emphasizing specific data or headings within the worksheet.
Q15. What does the Ctrl + I shortcut do in MS Excel?
a) Copy selected cells
b) Italicize the selected text
c) Paste selected cells
d) Delete selected cells
Show Answer
Correct Answer: b) Italicize the selected text
Explanation: In MS Excel, the Ctrl + I shortcut is used to italicize the selected text or cell contents. This is useful for emphasizing specific data or headings within the worksheet.
Q16. What does the Ctrl + D shortcut do in MS Excel?
a) Copy selected cells
b) Cut selected cells
c) Fill down the selected cells
d) Delete selected cells
Show Answer
Correct Answer: c) Fill down the selected cells
Explanation: In MS Excel, the Ctrl + D shortcut is used to fill down the selected cells with the contents of the topmost cell in the selection. This is useful for quickly copying data or formulas to multiple cells below the original cell.
Q17. What does the Ctrl + K shortcut do in MS Excel?
a) Copy selected cells
b) Cut selected cells
c) Paste selected cells
d) Insert a hyperlink in the active cell
Show Answer
Correct Answer: d) Insert a hyperlink in the active cell
Explanation: In MS Excel, the Ctrl + K shortcut is used to insert a hyperlink in the currently-active cell or location. This allows users to create links to external resources, such as websites or other files, within their worksheet.
Q18. What does the Ctrl + F / Ctrl + H shortcut do in MS Excel?
a) Open the Find dialog box / Open the Replace dialog box
b) Cut selected cells / Copy selected cells
c) Paste selected cells / Delete selected cells
d) Insert a hyperlink in the active cell / Edit the active cell
Show Answer
Correct Answer: a) Open the Find dialog box / Open the Replace dialog box
Explanation: In MS Excel, the Ctrl + F shortcut is used to open the Find dialog box, while the Ctrl + H shortcut is used to open the Replace dialog box. These shortcuts allow users to search for specific data or text within the worksheet and replace it with new data or text.
Q19. What does the Ctrl + G shortcut do in MS Excel?
a) Copy selected cells
b) Cut selected cells
c) Open the Go To dialog box
d) Delete selected cells
Show Answer
Correct Answer: c) Open the Go To dialog box
Explanation: In MS Excel, the Ctrl + G shortcut is used to open the Go To dialog box. This allows users to quickly navigate to specific cells, ranges, or named objects within the worksheet, making it easier to find and access important data.
Q20. What does the Ctrl + U shortcut do in MS Excel?
a) Copy selected cells
b) Cut selected cells
c) Paste selected cells
d) Underline the selected text
Show Answer
Correct Answer: d) Underline the selected text
Explanation: In MS Excel, the Ctrl + U shortcut is used to underline the selected text or cell contents. This is useful for emphasizing specific data or headings within the worksheet.
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.