What is the function of the 'Ctrl + Shift + End' key combination in Excel? MCQ with Answer and Explanation

Question
What is the function of the 'Ctrl + Shift + End' key combination in Excel?
A. Deletes all data to the right
B. Moves the active cell to the last cell
C. Selects all cells from the current position to the last used cell in the worksheet
D. Saves and closes the workbook
Answer: Option C
Solution (By JKSSB Mock Tests)
Ctrl+Shift+End extends the selection to the bottom-right used cell.
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
In MS Access, to import data from an Excel file, you can use:
A. Create tab -> Table from Excel
B. Database Tools -> Import
C. External Data tab -> Import Excel
D. Home tab -> Get External Data
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The External Data tab provides import and link options.
This question belongs to: Computer Microsoft Office
Question #2
What will be the result of the MS Excel formula =AVERAGE(10, 20, 30) if entered into a modern worksheet?
A. 30
B. 20
C. #VALUE!
D. 15
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
When passed directly as individual arguments inside a formula, numeric strings are parsed into numbers. Thus, (10 + 20 + 30) / 3 = 20.
This question belongs to: Computer Microsoft Office
Question #3
In MS Access, which view is used to design the structure of a table (field names, data types)?
A. Layout View
B. Form View
C. Design View
D. Datasheet View
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Design View is used to define field properties. Datasheet View shows data in rows/columns.
This question belongs to: Computer Microsoft Office
Explore All Microsoft Office MCQs
Today's Top Topics
Computer Hardware 430 Operating Systems 510 Programming Languages 0 Cyber Security 269 Database Management System (DBMS) 278
Explore Subjects
Reasoning 2064 Science 4430 Accountancy and Statistics 3179 Economy GK 2220 Computer 5279
Practice Mix
Which national park in Himachal Pradesh is known for its high-altitude grasslands and is a key habitat for the Himalayan Tahr?
Who was the first Indian to be the Coordination Secretary?
Which of the following is an example of an animal cell that lacks a nucleus in its mature form?
What is the primary limitation of configuring a network using a point-to-point Full Mesh Topology as the number of nodes scales high?
Double fertilization in angiosperms was discovered by: