MS Office

In MS Excel, the shortcut Ctrl + Shift + ; is used to insert the current time into a selected cell. This function quickly records the system time without requiring manual entry. The other options do not perform this action in Excel.

The three main steps of Mail Merge in MS Word are: creating the main document, creating or selecting a data source, and merging the two files. 'Setting the mailing list parameters' is not one of the official Mail Merge Helper steps, making it the correct answer.

The shortcut key CTRL+D is used to Fill Down in spreadsheet applications like Microsoft Excel, copying the content of the top cell into the selected cells below.

Mail merge in MS Word requires three main components: the main document, the data source, and merge fields. 'Word fields' is not a standard or essential component of mail merge, making it the correct answer.

Auto Correct is a feature in word processing software that automatically detects and corrects common spelling and typing mistakes while the user is typing. This helps reduce spelling errors and improves document accuracy.

Microsoft PowerPoint includes features such as printing slides on transparencies, printing speaker notes with slides, and drawing using pen tools during presentations. However, linking slide transitions with a laser pointer is not a standard built-in feature of PowerPoint.

In MS Excel's AutoFormat dialog box, users can selectively apply or reject various formatting options including Number format, Border format, and Font format. The dialog box provides checkboxes for each formatting aspect, allowing customized autoformatting.

In Microsoft Word, the shortcut Ctrl + H opens the Find and Replace dialog box, allowing users to search for and replace text efficiently.

In MS PowerPoint, a design template ensures a consistent look and format across all slides in a presentation. It controls colors, fonts, and overall design style. Other options like slide layout or outline view do not apply a uniform design to the entire presentation.

To move a block of text, you use the Cut and Paste operation. Cutting removes the text from its original location, and pasting places it at the new location. Copy and Paste would duplicate the text instead of moving it.

In Microsoft PowerPoint, the Task Pane includes options like Getting Started, Clip Art, and Search Result. WordArt is not a Task Pane section; instead, it is a feature used to create decorative text within slides.

Slide Sorter view in MS PowerPoint displays all slides in a grid format, allowing users to easily select multiple slides and apply transition effects uniformly. It is the most efficient view for managing transitions across an entire presentation. Other views are mainly used for editing content or notes rather than applying global effects.

The 'Pack and Go' feature in PowerPoint allows users to package a presentation along with linked files and fonts so it can be easily transferred and run on another computer. This ensures all necessary components are included for portability.

In Microsoft Word, you can set different headers and footers for the first page, even/odd pages, and different sections. However, there is no specific built-in option to assign different headers or footers only to the last page of a section.

In MS Word, section break options include Next Page, Odd Page, and Even Page. There is no 'Previous Page' section break option, making it the correct answer.

In Microsoft Excel, the shortcut Shift+F9 is used to calculate the active worksheet (current sheet) only, whereas F9 calculates all worksheets in all open workbooks. Therefore, option B is correct.

In older versions of Microsoft PowerPoint, the Common Tasks toolbar was a context-sensitive toolbar that provided different options depending on the active master view (Slide Master, Handout Master, or Notes Master). This toolbar allowed quick access to frequently used commands relevant to the master view being edited. Other toolbars like Drawing, Formatting, and Standard toolbars are more general-purpose and do not change their options based on the master view. Although the Common Tasks toolbar is not present in recent versions of PowerPoint, the question and answer correctly refer to its function in earlier versions.

In Microsoft Excel, the zoom range typically supports values from 10% to 400%. Therefore, 500% is not a valid zoom percentage. The other options (10%, 100%, and 300%) fall within the supported range.

Legal, Executive, and A3 are standard paper sizes used in word processing and printing. Landscape is not a paper size; it is a page orientation that refers to a horizontal layout.

In MS Word, the Columns feature (found under the Layout or Page Layout tab) is used to format text into newspaper-style columns. This allows text to flow vertically in multiple columns on a page, similar to newspapers. Other options like tables, tabs, and text boxes do not create proper newspaper-style column layouts.

Endnotes are used in documents to provide citations or references and are placed at the end of the document or section. Footnotes appear at the bottom of the same page, while headers and footers are used for page layout information such as titles, page numbers, or dates.

Automatic text formatting features in word processors include underlining hyperlinks, correcting spacing issues, and replacing symbols such as two hyphens with an em dash. Therefore, all the given options are examples of automatic text formatting.

In Microsoft Excel, pressing Ctrl + ' (apostrophe) copies the formula from the cell directly above into the current cell. This shortcut is specifically designed for copying formulas, making option D the correct answer.

MS Excel is a spreadsheet software used for organizing, analyzing, and storing data in tabular form. MS Word is a word processor, and MS PowerPoint is used for presentations, so they are not spreadsheet software.

In spreadsheet applications like MS Excel, Ctrl + A and the Select All command are used to select all cells. Triple-clicking with the right mouse button does not perform any selection action, so it will not select all cells in the document.