MS Office

A spreadsheet cell can contain different types of data, including labels (text), values (numbers), and formulas used for calculations. Therefore, all of the given options are correct.

In MS Word, text or paragraphs can be hidden by selecting the text and opening the Font dialog box. Then, enable the 'Hidden' option under the Effects section to hide the selected content.

The COUNT function in spreadsheet applications such as Microsoft Excel is used to count the number of numeric entries in a specified range of cells. It ignores text and blank cells and only counts numerical values.

The 'Embed TrueType Fonts' option in MS Word ensures that the fonts used in the document are included with the file. This helps maintain the document’s formatting and appearance when opened on another computer that may not have the same fonts installed.

In MS Word, pressing Ctrl + Spacebar removes all character-level formatting (such as bold, italic, font size, and color) from the selected text and restores it to the default formatting.

In Microsoft PowerPoint, the shortcut Ctrl + O is used to open an existing presentation file. It brings up the file explorer window where you can select and open saved presentations.

In spreadsheet applications like Microsoft Excel, cell comments (or notes) can be viewed by simply hovering the mouse pointer over the cell. The comment usually appears as a pop-up tooltip.

In Microsoft PowerPoint, a slide show can be started either by pressing the F5 key or by selecting the 'From Beginning' or 'View Show' option from the Slide Show menu. Both methods start the presentation in full-screen mode.

In MS Word and similar word processors, the typeface (font style) is changed through the Format menu, where font settings such as style, size, and appearance can be adjusted.

A page in word processing software like MS Word has four margins: top, bottom, left, and right. These define the printable area and control the spacing between the content and the edges of the page.

In MS Word, document magnification is done using the Zoom option available under the View menu. This allows users to increase or decrease the document display size for better readability without changing the actual content.

In Microsoft Word, tables do not have a fixed maximum number of rows like Excel. The number of rows is practically limited by system memory and performance, so it is generally considered unlimited for normal usage.

Microsoft Office supports 106 languages worldwide, either as fully localized versions or through Language Interface Packs (LIPs). This number is confirmed by official Microsoft sources, which state that the new Office is available in 106 languages, covering fully localized languages and LIPs. The previously cited figure of 145 languages is an overestimate and not supported by current official data.

By default, a new Excel workbook (especially in older versions like Excel 2010 and earlier) contains 3 worksheets. In newer versions, this default can be changed, but traditionally the default value is 3 sheets.

In Microsoft PowerPoint, the shortcut Ctrl + N is used to create a new presentation. It opens a blank presentation file so the user can start designing slides from scratch.

In modern versions of Microsoft Excel (2007 and later), each worksheet contains 16,384 columns, labeled from A to XFD. Earlier versions had fewer columns, but the current standard is 16,384.

In Microsoft Word, a drop cap can be set in two positions: 'Dropped' (within the paragraph) and 'In Margin' (outside the paragraph margin). These options control how the enlarged first letter appears in a paragraph.

In MS Word, the spacing between columns can be set to zero inches if required. However, for better readability, a small gap is usually recommended, but technically the minimum allowed spacing is 0 inches.

In modern versions of Microsoft Excel (2007 and later), each worksheet contains 1,048,576 rows. This increase in row capacity allows users to handle much larger datasets compared to earlier versions.

In Microsoft Word, repeated words are typically flagged as grammar errors, which are indicated by a green wavy underline. The red wavy underline is used for spelling errors, while the green wavy line indicates grammar issues such as repeated words. Blue wavy lines are used for format consistency issues, not repeated words.

In MS PowerPoint, speaker notes pages are controlled through the Notes Master. By editing the Notes Master, you can add elements such as a company logo, which will appear consistently on all printed speaker notes pages along with slides and notes.

Microsoft Word supports a maximum of 63 columns in a table or document section when using the Columns feature under page layout settings. This is a documented limit in Microsoft Word, and any columns beyond this limit are not supported.

In MS Word, the Format Painter tool is used to copy formatting from one text and apply it to another. You select the formatted text, click Format Painter, and then apply it to the target text to match the same style and appearance.

In Microsoft PowerPoint, the Slide Master is used to apply consistent formatting, including background images, across all slides in a presentation. Any changes made in the Slide Master automatically reflect on all slides.

In Microsoft Word, pressing the Home key moves the cursor to the beginning of the current line. This helps users quickly navigate within a line of text without using the mouse.