In Microsoft Excel, sorting data from A to Z is called:

A. Descending Order
B. Filtering
C. Custom Sorting
D. Ascending Order
Correct answer is: D. Ascending Order
Sorting from A to Z is ascending order in Excel.

Which keyboard shortcut is used to minimize the Excel window?

A. Ctrl + F8
B. Ctrl + F9
C. Ctrl + F10
D. Ctrl + F11
Correct answer is: B. Ctrl + F9
Ctrl + F9 minimizes the Excel workbook window.

MS Word offers different views of a document:

A. Two
B. Three
C. Four
D. Five
Correct answer is: D. Five
MS Word provides five views: Print Layout, Read Mode, Web Layout, Outline, and Draft.

Which keyboard shortcut is used to extend the selection down in a Microsoft Excel worksheet?

A. Shift + Down Arrow
B. Ctrl + Shift + Right Arrow
C. Alt + Down Arrow
D. Ctrl + Down Arrow
Correct answer is: A. Shift + Down Arrow
Shift + Down Arrow extends the selection downward in Excel.

The file extension .ppt is used for files created by:

A. MS Word
B. MS Excel
C. MS PowerPoint
D. MS Access
Correct answer is: C. MS PowerPoint
The .ppt extension is used for PowerPoint presentation files.

Ctrl + Q is used to:

A. Remove Paragraph formatting (Line Space and Paragraph Space)
B. Close Word Application without saving
C. Print Whole Document without confirmation
D. Does nothing
Correct answer is: A. Remove Paragraph formatting (Line Space and Paragraph Space)
Ctrl + Q resets paragraph formatting to default in MS Word.

The ____ feature of MS Excel quickly completes a series of data.

A. Auto Complete
B. Auto Fill
C. Fill Handle
D. Sorting
Correct answer is: B. Auto Fill
Auto Fill completes a series of data, such as numbers or dates, in Excel.

Which keyboard shortcut is used to switch between open applications in Windows 10?

A. Ctrl + Tab
B. Alt + F4
C. Alt + Tab
D. Shift + Esc
Correct answer is: C. Alt + Tab
Alt + Tab allows switching between open applications in Windows.

The Protect Document option can be found in the ____ tab of the Ribbon.

A. Review
B. Home
C. References
D. Edit
Correct answer is: A. Review
The Protect Document option is located in the Review tab in MS Word.

Which keyboard shortcut is used to create a formula that sums all the cells above the active cell in Excel?

A. Alt + S
B. Ctrl + =
C. Alt + =
D. Shift + =
Correct answer is: C. Alt + =
Alt + = inserts a SUM formula for the cells above the active cell in Excel.
Scroll to Top