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.
Q31. What does the Ctrl + Page Up and Ctrl + Page Down shortcut do in MS Excel?
a) Move to the previous sheet and move to the next sheet
b) Move to the top of the worksheet and move to the bottom of the worksheet
c) Move to the first cell and move to the last cell
d) Move to the left edge of the worksheet and move to the right edge of the worksheet
Show Answer
Correct Answer: a) Move to the previous sheet and move to the next sheet
Explanation: In MS Excel, the Ctrl + Page Up and Ctrl + Page Down shortcuts are used to move to the previous sheet and move to the next sheet, respectively. This allows users to quickly navigate between worksheets within a workbook without using the mouse.
Q32. What does the Ctrl + Shift + $ shortcut do in MS Excel?
a) Apply currency format to the selected cells
b) Apply percentage format to the selected cells
c) Apply date format to the selected cells
d) Apply time format to the selected cells
Show Answer
Correct Answer: a) Apply currency format to the selected cells
Explanation: In MS Excel, the Ctrl + Shift + $ shortcut is used to apply the currency format to the selected cells. This is useful for quickly formatting numerical data as currency values, making it easier to read and understand financial data.
Q33. What does the Alt + = shortcut do in MS Excel?
a) Insert a function
b) AutoSum the selected cells
c) Apply or remove bold formatting
d) Insert a hyperlink in the active cell
Show Answer
Correct Answer: b) AutoSum the selected cells
Explanation: In MS Excel, the Alt + = shortcut is used to automatically sum the selected cells. This is a convenient way to quickly calculate the total of a range of numbers without having to manually enter a formula or function.
Q34. What does the Ctrl + Tab shortcut do in MS Excel?
a) Switch between open workbooks
b) Move to the next sheet
c) Move to the previous sheet
d) Apply or remove bold formatting
Show Answer
Correct Answer: a) Switch between open workbooks
Explanation: In MS Excel, the Ctrl + Tab 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.
Q35. What does the Ctrl + Shift + ! shortcut do in MS Excel?
a) Apply currency format to the selected cells
b) Apply percentage format to the selected cells
c) Apply number format with two decimal places to the selected cells
d) Apply date format to the selected cells
Show Answer
Correct Answer: c) Apply number format with two decimal places to the selected cells
Explanation: In MS Excel, the Ctrl + Shift + ! shortcut is used to apply the number format with two decimal places to the selected cells. This is useful for quickly formatting numerical data with a consistent level of precision, making it easier to read and compare values.
Q36. What does the Ctrl + Shift + % shortcut do in MS Excel?
a) Apply currency format to the selected cells
b) Apply percentage format to the selected cells
c) Apply date format to the selected cells
d) Apply time format to the selected cells
Show Answer
Correct Answer: b) Apply percentage format to the selected cells
Explanation: In MS Excel, the Ctrl + Shift + % shortcut is used to apply the percentage format to the selected cells. This is useful for quickly formatting numerical data as percentages, making it easier to read and understand ratios and proportions.
Q37. What does the Ctrl + Shift + ^ shortcut do in MS Excel?
a) Apply currency format to the selected cells
b) Apply percentage format to the selected cells
c) Apply scientific notation format to the selected cells
d) Apply date format to the selected cells
Show Answer
Correct Answer: c) Apply scientific notation format to the selected cells
Explanation: In MS Excel, the Ctrl + Shift + ^ shortcut is used to apply the scientific notation format to the selected cells. This is useful for quickly formatting large numbers or numbers with many decimal places in a more compact and readable form.
Q38. What does the Ctrl + Shift + # shortcut do in MS Excel?
a) Apply currency format to the selected cells
b) Apply percentage format to the selected cells
c) Apply date format to the selected cells
d) Apply time format to the selected cells
Show Answer
Correct Answer: c) Apply date format to the selected cells
Explanation: In MS Excel, the Ctrl + Shift + # shortcut is used to apply the date format to the selected cells. This is useful for quickly formatting numerical data as dates, making it easier to read and understand date-related information.
Q39. What does the Ctrl + W shortcut do in MS Excel?
a) Close the active workbook
b) Cut selected cells
c) Paste selected cells
d) Delete selected cells
Show Answer
Correct Answer: a) Close the active workbook
Explanation: In MS Excel, the Ctrl + W shortcut is used to close the active workbook. This allows users to quickly close an Excel file without having to navigate through menus or click the close button.
Q40. What does the Ctrl + Space shortcut do in MS Excel?
a) Select the entire column of the active cell
b) Select the entire row of the active cell
c) Select all cells in the worksheet
d) Select the current data region
Show Answer
Correct Answer: a) Select the entire column of the active cell
Explanation: In MS Excel, the Ctrl + Space shortcut is used to select the entire column of the active cell. This is useful for quickly selecting a large range of data in a single column for formatting, copying, or other operations.
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.