MS Office

In Excel, pressing Ctrl+; (Control key plus semicolon) inserts the current date into the selected cell. This is a standard shortcut for entering the date quickly.

When the Language bar is hidden, it is not visible on the screen but remains enabled and will appear again the next time you start your computer. This differs from minimizing or closing, which affect its visibility or running state differently.

The Draw Table tool in Microsoft Word is found on the Drawing toolbar, which provides tools for drawing shapes and tables. The other toolbars listed do not contain the Draw Table button.

Vertical alignment in Microsoft Word is changed through the Page Setup dialog box, where you can set the vertical alignment of text on a page (Top, Center, Justified, Bottom). The Paragraph dialog box and toolbars do not control vertical alignment of the entire page.

In Excel, pressing the F11 key creates a chart from the selected data on a new chart sheet. F1 opens Help, and F10 activates the menu bar, so only F11 is correct for creating a chart.

When saving a file as a Web page, Microsoft Word converts the document contents into HTML (HyperText Markup Language), which is the standard language for creating web pages.

When you insert an Excel worksheet into a Word document, Word acts as the destination document because it is the file receiving the embedded or linked Excel content. The Excel worksheet is the source, and Word hosts it within its document.

When a hyperlink is created in Microsoft Word, the default formatting is that the web address becomes underlined and colored blue, indicating it is clickable.

The Quick Access Toolbar is located in the upper-left corner of the Microsoft Office window and is used to provide quick access to your favorite or frequently used commands, improving efficiency.

Vertical alignment in a Word document is changed through the Page Setup dialog box, where you can set the vertical alignment of text on the page (top, center, justified, bottom). The other options do not provide vertical alignment settings.

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.

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.

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.

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.

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.

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.

According to Microsoft support documentation and verified sources, the smallest width you can set for a column in MS Word is approximately 0.08 inches, which is very close to 0 inches and effectively the smallest possible width. MS Word does not allow a column width of exactly 0 inches, but it automatically adjusts any smaller value to this minimum. Therefore, option A (0") is the closest and most accurate answer among the given choices.

In Excel, the intersection of a column and a row is called a cell. Each cell is identified by its column letter and row number, such as A1 or B2.

The VLOOKUP function in Excel searches for a value in the first column of a range and returns a value in the same row from a specified column, performing a vertical lookup based on given criteria.

The overall term for creating, editing, formatting, storing, retrieving, and printing a text document is 'Word processing.' This encompasses all these functions related to handling text documents.

The Format Painter tool in Microsoft Word copies the formatting of selected text and allows you to apply that same formatting to other text, making it the correct answer.

The 'All Caps' feature in Microsoft Word converts all the selected text into uppercase letters, making all characters capitalized. This is a text formatting option and does not relate to images or captions.

The default font size in a new Microsoft Word document based on the Normal template is 12 pt, typically using the Calibri font. This is the standard setting unless the template is modified.

The SUM function in Excel is used to add up all the numeric values within a specified range of cells, making option A correct. Other options describe different functions: AVERAGE calculates the mean, COUNT counts cells with numbers, and MAX finds the highest value.

In Microsoft Word, the 'Split' button is located to the left of the horizontal scroll bar, allowing users to split the document window for easier viewing and editing. The 'View' buttons are typically found at the bottom right corner of the window, not to the left of the horizontal scroll bar.