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.

Q1. What does the Ctrl + C shortcut do in MS Excel?
a) Copy selected cells
b) Cut selected cells
c) Paste selected cells
d) Delete selected cells

Show Answer

Correct Answer: a) Copy selected cells
Explanation: In MS Excel, the Ctrl + C shortcut is used to copy the contents of the selected cells. This allows users to duplicate data or formulas from one cell or range of cells to another location within the worksheet or across different worksheets and workbooks.

Q2. What does the Ctrl + V shortcut do in MS Excel?
a) Copy selected cells
b) Cut selected cells
c) Paste selected cells
d) Delete selected cells

Show Answer

Correct Answer: c) Paste selected cells
Explanation: In MS Excel, the Ctrl + V shortcut is used to paste the contents of the clipboard (previously copied or cut) into the selected cells. This is a convenient way to transfer data or formulas between cells, worksheets, or workbooks.

Q3. What does the Ctrl + Shift + Arrow Keys shortcut do in MS Excel?
a) Move to the edge of the current data region
b) Select all cells in the current data region
c) Extend the selection to the last non-empty cell in the same column or row
d) Move to the next non-empty cell in the same column or row
Correct Answer: c) Extend the selection to the last non-empty cell in the same column or row

Show Answer

Correct Answer: c) Extend the selection to the last non-empty cell in the same column or row
Explanation: In MS Excel, the Ctrl + Shift + Arrow Keys shortcut is used to extend the selection to the last non-empty cell in the same column or row as the active cell. This is useful for quickly selecting large ranges of data without having to click and drag the mouse.

Q4. What does the F2 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) Toggle between displaying cell values and formulas

Show Answer

Correct Answer: b) Edit the active cell
Explanation: In MS Excel, the F2 shortcut is used to edit the contents of the active cell. This allows users to quickly modify cell contents, such as data or formulas, without having to double-click the cell or use the formula bar.

Q5. What does the F4 shortcut do in MS Excel?
a) Repeat the last action
b) Open the Find and Replace dialog box
c) Toggle between absolute and relative references
d) Open the Go To dialog box

Show Answer

Correct Answer: c) Toggle between absolute and relative references
Explanation: In MS Excel, the F4 shortcut is used to toggle between absolute and relative references while editing a formula. This is helpful for quickly changing the reference type of cell addresses in formulas, making it easier to create flexible and dynamic calculations.

Q6. What does the 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) Toggle between displaying cell values and formulas

Show Answer

Correct Answer: c) Open the Go To dialog box
Explanation: In MS Excel, the F5 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.

Q7. What does the F7 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: d) Start the spell check
Explanation: In MS Excel, the F7 shortcut is used to start the spell check feature. This helps users identify and correct spelling errors in their worksheets, ensuring that the data and text are accurate and professional.

Q8. What does the F11 shortcut do in MS Excel?
a) Create a chart from the selected data
b) Open the Find and Replace dialog box
c) Open the Go To dialog box
d) Toggle between displaying cell values and formulas

Show Answer

Correct Answer: a) Create a chart from the selected data
Explanation: In MS Excel, the F11 shortcut is used to create a chart from the selected data. This provides a quick and easy way to visualize data trends and patterns, making it easier to analyze and interpret the information.

Q9. What does the Ctrl + Shift + ; shortcut do in MS Excel?
a) Insert the current date
b) Insert the current time
c) Insert the current date and time
d) Open the Date and Time dialog box

Show Answer

Correct Answer: b) Insert the current time
Explanation: In MS Excel, the Ctrl + Shift + ; shortcut is used to insert the current time into the active cell. This is useful for quickly adding timestamps to data entries or for tracking the time of specific events or actions.

Q10. What does the Ctrl + ; shortcut do in MS Excel?
a) Insert the current date
b) Insert the current time
c) Insert the current date and time
d) Open the Date and Time dialog box

Show Answer

Correct Answer: a) Insert the current date
Explanation: In MS Excel, the Ctrl + ; shortcut is used to insert the current date into the active cell. This is helpful for quickly adding dates to data entries or for tracking the date of specific events or actions.

More MCQ on Computer GK for Competitive Exams

Get free Text Content Tools, Website Management Tools, Development Tools, Binary Converter Tools, Unit Converter Tools and SEO Tools on EuWebTools.

Pages: 1 2 3 4

1 2 3 4 » Next