In Excel, a valid cell address consists of a column letter(s) followed by a row number. Both "Z2" (column Z, row 2) and "AZ3" (column AZ, row 3) follow this rule. "2Z" is incorrect because the row number cannot come before the column letter.

The core features of a spreadsheet program are its grid of rows and columns, the ability to use formulas for calculations, and functions for printing the data. WordArt is a feature for creating decorative text, which is more commonly associated with word processing or presentation software.

MS Excel is the spreadsheet application within the Microsoft Office suite. It is designed for organizing, analyzing, and storing data in a tabular format using a grid of rows and columns.

The "Ignore All" command tells the spell checker to disregard every instance of that specific, supposedly misspelled word for the remainder of the current editing session. It will not flag that same word again until the document is closed and reopened.

When AutoCorrect makes a change, a small blue box (the AutoCorrect Options smart tag) appears. Clicking this tag provides a menu that allows you to undo that specific correction, stop Word from making that correction in the future, or access the AutoCorrect options dialog box.

The keyboard shortcut Ctrl + Enter inserts a manual page break. This forces all subsequent content to move to the top of the next page, regardless of how much space is left on the current page.

The Find feature in Word includes a "Reading Highlight" option that allows you to highlight every instance of your search term in the document simultaneously, making it easy to see all occurrences at a glance. The feature is on the Home tab and can search for phrases and formats.

By default, dragging and dropping selected text in Word will move it. If you want to copy the text instead of moving it, you must press and hold the CTRL key while you drag and drop. The cursor will change to show a plus sign, indicating a copy action.

A macro is a recorded sequence of commands and actions that can be replayed to automate a repetitive task. In Microsoft Word, macros are created using Visual Basic for Applications (VBA), allowing users to significantly improve their workflow efficiency. Ctrl + I is the shortcut for italicizing selected text in MS Word. * Which shortcut key is used to check spelling? (A) F1 (B) F2 (C) F7 (D) F9 F7 is the shortcut to check spelling and grammar in MS Word. * What does Ctrl + B shortcut accomplish in MS-Word? (A) It converts selected text into the next larger size of the same font (B) It adds a line break to the document (C) It makes the selected text bold (D) It applies Italic formatting in the selected text Ctrl + B is the shortcut to make selected text bold in MS Word. * To get help using Word, click the help icon on the ribbon or press the F1 key. (A) True (B) False Pressing F1 or clicking the help icon opens Word's Help feature to assist with various tasks. * To use your keyboard instead of the mouse to select tools on the ribbon, you display the Key Tips by pressing the key. (A) Alt (B) Ctrl (C) Shift + Enter (D) Alt + Enter Pressing the Alt key displays Key Tips, which allow you to navigate the ribbon using your keyboard. * Where can you find the horizontal split bar on the MS Word screen? (A) On the left of the horizontal scroll bar (B) On the right of the horizontal scroll bar (C) On the top of the vertical scroll bar (D) On the bottom of the vertical scroll bar The horizontal split bar appears above the vertical scroll bar to divide the document into sections for easier navigation. * Pressing F8 key for three times selects: (A) A word (B) A sentence (C) A paragraph (D) Entire document Pressing F8 three times selects a paragraph in MS Word. * What happens if you press Ctrl + Shift + F8? (A) It activates extended selection (B) It activates the rectangular selection (C) It selects the paragraph on which the insertion line is (D) None of the above Ctrl + Shift + F8 activates the extended selection mode, allowing you to select text more easily. * How can you disable extended selection mode? (A) Press F8 again to disable (B) Press Del to disable (C) Press Esc to disable (D) Press Enter to disable Pressing the Esc key will disable the extended selection mode. * What is the shortcut key to create a copyright symbol? (A) Alt+Ctrl+C (B) Alt+C (C) Ctrl+C (D) Ctrl+Shift+C Alt + Ctrl + C is the keyboard shortcut to insert the copyright symbol (©). * The keystroke Ctrl+I is used to: (A) Increase font size (B) Insert a line break (C) Indicate the text should be bold (D) Applies Italic format to selected text Ctrl + I is the shortcut to apply italic formatting to the selected text in MS Word. * Which function key activates the speller? (A) F5 (B) F7 (C) F9 (D) Shift + F7 F7 is the shortcut key to run the spell check in MS Word. * To move the cursor page to page of a document: (A) Ctrl + PgDn (B) Ctrl + PgUp (C) Both of the above (D) None of the above Ctrl + PgDn moves the cursor to the next page, and Ctrl + PgUp moves the cursor to the previous page. * You can detect spelling and grammar errors by: (A) Press Shift + F7 (B) Press Ctrl + F7 (C) Press Alt + F7 (D) Press F7 Pressing F7 opens the spelling and grammar checker in MS Word. * Which key should you press if you want to copy while using drag and drop? (A) Shift (B) CTRL (C) ALT (D) Home Hold the CTRL key while dragging to copy text instead of moving it. * Which shortcut keystrokes do you use to create a manual page break? (A) Ctrl + Spacebar (B) Ctrl + Enter (C) Ctrl + Shift + Enter (D) Alt + Enter Ctrl + Enter is the shortcut to insert a manual page break in Word. Subscript refers to text that appears smaller and lowered below the regular text line, like the "2" in H2O. * A First Line indent indents all lines after the first line of the paragraph. (A) True (B) False A First Line indent only indents the first line of the paragraph, not all lines. * The default line spacing for a Word 2007 document is set to multiple with a 15% increase (1.15) over single spacing. (A) True (B) False By default, Word 2007 uses 1.15 line spacing, which is a 15% increase over single spacing. * The vertical space between lines of text is referred to as what? (A) Indenting (B) Line spacing (C) Paragraph padding (D) Internal margins Line spacing refers to the amount of vertical space between lines of text in a paragraph. * An outline numbered list can have up to how many levels? (A) 5 (B) 8 (C) 9 (D) 15 An outline numbered list in Word can have up to 9 levels of indentation. * What is the maximum number of lines you can set for a drop cap? (A) 3 (B) 10 (C) 15 (D) 20 In Word, the maximum number of lines you can set for a drop cap is 10. * What is the default number of lines to drop for a drop cap? (A) 3 (B) 10 (C) 15 (D) 20 By default, Word applies a 3-line drop cap effect to the first letter of a paragraph. * What is the smallest and largest font size available in the Font Size tool on the formatting toolbar? (A) 8 and 72 (B) 8 and 64 (C) 12 and 72 (D) None of the above The Font Size tool in Word allows font sizes from 8 to 72 points. * What is the maximum font size you can apply for any character? (A) 163 (B) 1638 (C) 16038 (D) None of the above The maximum font size that can be applied in MS Word is 1638 points. * A character that is raised and smaller above the baseline is known as: (A) Outlined (B) Raised (C) Superscript (D) Subscript A superscript is a character that appears raised and smaller above the baseline, such as in mathematical notations (e.g., x²). * Why are Drop Caps used in a document? (A) To drop all the capital letters (B) To automatically begin each paragraph with a capital letter (C) To begin a paragraph with a large dropped initial capital letter (D) None of the above Drop Caps are used to add a large initial capital letter to the beginning of a paragraph, typically for stylistic purposes. * Superscript, subscript, outline, emboss, engrave are known as: (A) Font styles (B) Font effects (C) Word art (D) Text effects These are various font effects that modify how the text appears in the document. * The feature of Word that automatically adjusts the amount of space between certain combinations of characters so that an entire word looks more evenly spaced is called: (A) Spacing (B) Scaling (C) Kerning (D) Positioning Kerning adjusts the spacing between characters to make text appear more even and visually appealing. * Which of the following is not available in Font Spacing? (A) Normal (B) Loosely (C) Condensed (D) Expanded Loosely is not a standard font spacing option in MS Word. * Which of the following positions is not available for fonts on MS Word? (A) Normal (B) Raised (C) Lowered (D) Centered Centered is not an available font position option. Fonts are typically Normal, Raised, or Lowered. * What is the maximum scale percentage available in the Scale drop-down box? (A) 500 (B) 200 (C) 100 (D) 90 The maximum scaling percentage in MS Word is 200%. * Bold, Italic, Regular are known as: (A) Font styles (B) Font effects (C) Word art (D) Text effects Bold, Italic, and Regular are different font styles that can be applied to text in MS Word. * Changing the appearance of a document is called: (A) Proofing (B) Editing (C) Formatting (D) All of the above Formatting involves changing the appearance of a document, such as adjusting fonts, margins, or text alignment. * How would you make an item in a multi-level list change level? (A) Indent & Outdent (B) Tab & Shift Tab (C) Format Margin (D) Don't know You can change the level of an item in a multi-level list by pressing Tab to indent and Shift + Tab to outdent. * What is a paragraph? (A) A sentence or group of sentences (B) A block of text (C) Any text with a return at the end (D) Don't know A paragraph in Word is defined as any text followed by a paragraph break (pressing Enter). * Which formatting type makes both margins of a block of text equally straight? (A) Right (B) Justified (C) Align (D) Don't know Justified text aligns both the left and right margins by adjusting the spacing between words. * How can you make letters appear Hollow? (A) Choose the white text option (B) Choose the Hollow from the styles drawer (C) Format it to outline (D) Don't know You can make letters appear hollow by formatting them to be outlined, which removes the fill color and leaves the letter outline. * Using the Font tab in the Font dialog box, you can modify the font, font style, font size, and change the default font. (A) True (B) False The Font tab in the Font dialog box provides options for adjusting the font, style, size, and setting the default font. * The Format Painter is used to copy and paste formatted text. (A) True (B) False The Format Painter tool copies formatting from one section of text and applies it to another section. * You only need to tap Enter once between paragraphs when using Word's new spacing, which automatically adds space after a paragraph. (A) True (B) False While Word’s default setting adds space after paragraphs, you can adjust this behavior, and you still need to tap Enter to start a new paragraph. * To copy text formats to several locations in a document, you select the text containing the formats you want to copy, and then... (A) Click the format painter button and select the desired blocks of text (B) Double-click the format painter button and select the desired blocks of text (C) Use the Copy button (D) Double-click the Copy button Double-clicking the Format Painter button allows you to apply the copied format to multiple locations in the document. Headers and footers are used to display repetitive content like page numbers, document titles, or dates at the top or bottom of each page. * A __ marks the point at which one page ends and another begins. (A) Page break (B) Column break (C) Cell break (D) Line break A page break is used to mark where a page ends and the next begins in a document. * You can add a tab stop just by clicking a location on the Word ruler. (A) True (B) False In Word, you can quickly add a tab stop by clicking on the ruler at the desired location. * To reduce the amount of space on the right side of a document, you can __. (A) Increase; Left Margin (B) Decrease; Right Margin (C) Decrease; Left Indent (D) Increase; Right Indent To reduce space on the right, you can decrease the right margin in the document. * You can format a document to contain a maximum of 3 newsletter columns. (A) True (B) False You can create a maximum of 45 columns in Word, not just 3. * How many columns can you insert in a Word document at maximum? (A) 35 (B) 45 (C) 55 (D) 65 You can insert up to 45 columns in a table in Word. * What is the purpose of inserting a header and footer in a document? (A) To enhance the overall appearance of the document (B) To mark the starting and ending of a page (C) To make a larger document more readable (D) To allow page headers and footers to appear on the document when printed Headers and footers are used to add consistent elements, such as page numbers, document titles, or dates, that will appear on printed pages. * The minimum number of rows and columns in an MS Word document is: (A) 1 and 1 (B) 2 and 1 (C) 2 and 2 (D) None of the above The minimum number of rows and columns that can be in a table in MS Word is 1 and 1. * Which option is not available in Insert Table Autofit behavior? (A) Fixed Column Width (B) AutoFit to Contents (C) AutoFit to Window (D) AutoFit to Column There is no option for "AutoFit to Column." The available options are "AutoFit to Contents" and "AutoFit to Window." * To autofit the width of a column: (A) Double-click the right border of the column (B) Double-click the left border of the column (C) Double-click the column header (D) All of the above Double-clicking the right border of a column will automatically adjust its width to fit the content. * From which Ribbon can you insert Header and Footer? (A) Insert (B) View (C) Format (D) Tools You can insert headers and footers from the Insert Ribbon in MS Word. * After typing header text, how can you quickly enter footer text? (A) Press PageDown key and type the text for the footer (B) Click on Switch between Header & Footer, then type the text (C) Both of the above (D) None of the above The "Switch between Header & Footer" option allows you to easily toggle between editing the header and footer sections. * When inserting a page number in the footer, it appeared as '1' but you wish to show 'a.' How can you do that? (A) From the Home Ribbon, choose Bullets and Numbering and configure the necessary setting (B) From the Insert Ribbon, choose Page Number and specify the necessary setting (C) Click on the Page Number Format tool and specify the required setting (D) All of the above You can change the page number format, such as from numbers to letters, by clicking the Page Number Format tool. * Which of the following statement is false? (A) You can set different header/footer for even and odd pages (B) You can set different page number formats for different sections (C) You can set different header/footer for the first page of a section (D) You can set different header and footer for the last page of a section Word allows different headers and footers for even and odd pages, as well as the first page of a section, but not specifically for the last page of a section. * Where can you change the vertical alignment? (A) Formatting Ribbon (B) Paragraph dialog box (C) Page Setup dialog box (D) Insert Ribbon Vertical alignment can be adjusted from the Page Setup dialog box to control text positioning on the page. * Which of the following is used to create newspaper-style columns? (A) Format Tabs (B) Table Insert Table (C) Insert Textbox (D) Page Layout, Columns In MS Word, to create newspaper-style columns, you use the "Columns" feature in the "Page Layout" tab. * Columns dialog box can be opened from: (A) Page Layout, Columns (B) Double-click on the column space in the ruler (C) Press Alt + O + C (D) All of the above The Columns dialog box can be accessed in multiple ways: from the "Page Layout" tab, by double-clicking the column space in the ruler, or using the shortcut Alt + O + C. * You can jump to the next column by: (A) Clicking with your mouse on the next column (B) Pressing Alt + Down-arrow (C) Both of the above (D) None of the above You can jump to the next column either by clicking with the mouse or using the Alt + Down-arrow shortcut. * How can you break the current column and start a new column immediately? (A) Press Ctrl + Shift + Enter (B) Press Alt + Enter (C) Press Ctrl + Enter (D) Press Alt + Shift + Enter Ctrl + Shift + Enter breaks the current column and starts a new column immediately. * What is the smallest width of a column? (A) 0" (B) 0.5" (C) 1" (D) 1.5" The smallest width a column can have is 0.5 inches. * How much space in minimum must be provided between columns? (A) 0" (B) 0.5" (C) 1" (D) 1.5" A minimum of 0.5 inches of space must be provided between columns. * You need one page to be landscaped in a document that is portrait. What do you use? (A) Page breaks (B) Section breaks (C) Orientation breaks (D) Don't know A section break allows you to have different page orientations (portrait or landscape) within the same document. * What makes full stops in currency line up in a tabbed layout? (A) Decimal Tab (B) Left Tab (C) Bar Tab (D) Don't know A Decimal Tab ensures that numbers with decimal points line up correctly in a column. * In a word table, how can you add up a column of figures? (A) =sum(above) (B) Autosum button (C) Insert function sum (D) Don't know To sum a column in a table, you can use the formula "=sum(above)" to calculate the total of the numbers above the cell. * When we don't want a single line of a paragraph to be left on another page, we turn on: (A) Paragraph line control (B) Widow and Orphan control (C) Line Break control (D) Don't know Widow and Orphan control ensures that a paragraph is not split across pages by keeping at least two lines together. * Manual page breaks remain in place until you remove them. (A) True (B) False Manual page breaks stay in place until you manually remove them or adjust the document’s layout. * You can remove a manual page break by clicking it and tapping Delete. (A) True (B) False You can remove a manual page break by selecting it and pressing Delete. The file extension for MS Word documents is .doc (or .docx for newer versions). * Which of the following types of pictures can Word not accept? (A) CDR (B) PNG (C) TIFF (D) JPG CDR is a file format specific to CorelDRAW and cannot be used in MS Word. * Someone using an older version of Word can read your Word 2007 documents by downloading a compatibility pack from the Microsoft website. (A) True (B) False Microsoft provides a compatibility pack that allows users with older versions of Word to open and read Word 2007 documents.

A mail merge operation requires three essential components: a Main Document (the template), a Data Source (the list of recipient information), and Merge Fields (placeholders in the main document for the data). "Word Fields" is a general term for various codes in Word that display data and is not a specific, essential component of the mail merge process itself.