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.