Study HubHubPage 80/171Scan verified MCQs with the answer highlighted, then open explanations when you want the reasoning.
Read Mode
Excel Transpose
Which function displays row data into columns or column data into rows?
The TRANSPOSE function in Excel converts rows to columns or columns to rows, effectively switching the orientation of the data. This matches the description in the question.
Read Mode
Ms Word Fields
When typing in a Word field manually, what must you press to insert the code’s brackets?
In Microsoft Word, to manually insert field brackets (curly braces) for fields, you must press Ctrl + F9. This shortcut inserts the special field code brackets that cannot be typed manually from the keyboard.
Read Mode
Embedded Objects In Office
What would you do when you want to update the data in an embedded worksheet range?
To update data in an embedded worksheet range, you need to edit the data in the source document (the original Excel worksheet). Double-clicking the embedded object opens the source for editing, but the actual update happens in the source document, not just by double-clicking.
Read Mode
Keyboard keys
Which key deletes the character to the left of the cursor?
The Backspace key deletes the character to the left of the cursor, whereas the Delete key removes the character to the right. End and Home keys move the cursor to the end or beginning of the line, respectively.
Read Mode
Computer Ports
Which place is used to connect various external devices to the computer?
A port is a physical interface on a computer used to connect various external devices such as keyboards, mice, printers, and storage devices. This makes option C the correct answer.
Read Mode
Ms Word Autoformat
When three hyphens, underscores, equal signs, asterisks, or number signs are typed and then the Enter key is pressed, the AutoFormat feature ____.
In MS Word, typing three hyphens (---), underscores (___), equal signs (===), asterisks (***), or number signs (###) followed by pressing Enter triggers the AutoFormat feature to insert a specific type of border or line above the paragraph. For example, three hyphens create a horizontal line (border) above the paragraph, confirming option A is correct.
Read Mode
Ms Office Linking
Which command is used to establish a link between a source document and a destination document in modern Microsoft Office versions?
In modern versions of Microsoft Office (including Word, Excel, and PowerPoint), the command to establish a link between a source document and a destination document is found under the Insert tab, specifically via the Insert > Link (or Hyperlink) command. This command opens a dialog where you can specify the destination document or location, effectively creating a link between the source and destination. The older menu path 'Tools > Link > Documents' is outdated and no longer used in recent versions. Option D ('Edit, Paste Special') is used for pasting content with special options but does not establish a link between documents.
Read Mode
Object Selection
Which command selects all objects at one time when selecting multiple objects to be deleted?
The command to select all objects or items at once in most computer applications is Ctrl + A, not Edit, Select All. Ctrl + A is a standard keyboard shortcut for 'Select All'.
Read Mode
Ms Word Document Elements
Which items are placed at the end of a document?
Endnotes are items placed at the end of a document, typically used to provide additional information or citations. Footers appear at the bottom of each page, footnotes are placed at the bottom of the page where the reference occurs, and 'Headet' is a misspelling of 'Header', which appears at the top of each page.
Read Mode
Ms Word Text Case
Which feature is used to change the selected sentence to all capital letters or all small letters?
The feature used in MS Word to convert selected text to all capital letters or all small letters is called 'Change Case'. This option allows toggling between uppercase, lowercase, and other capitalization formats.