Correct answer: To apply the same format from one text to another. Format Painter copies the formatting of selected text and applies it to other text.

• Copy text: It copies formatting, not the text itself.
• Paste only font style: It copies all formatting, not only the font style.
• Change colour of an object: It is not limited to changing the colour of an object.

Correct answer: Ctrl+H. Ctrl + H opens the Replace dialog (Find and Replace).

• Ctrl+F: Ctrl + F opens Find only.
• Ctrl+G: Ctrl + G opens Go To.
• Ctrl+R: Ctrl + R aligns text to the right.

Correct answer: Home Tab > Sort (A to Z or Z to A). The Sort button is in the Paragraph group of the Home tab.

• Insert Tab > Sort: The Insert tab does not contain the Sort command.
• Review Tab > Sort: The Review tab does not contain the Sort command.
• View Tab > Sort: The View tab does not contain the Sort command.

Correct answer: Letters A, B, C…. Excel columns are labelled with letters (A, B, C…), and rows with numbers.

• Numbers: Numbers label rows.
• Symbols: Symbols are not used for column labels.
• Roman Numerals: Roman numerals are not used for column labels.

Correct answer: Data Tab > Sort & Filter. The Data tab’s Sort & Filter group contains the main sorting and filtering commands.

• Home Tab > Filter: The Home tab has a Sort & Filter menu in the Editing group, but the Data tab is where these commands are grouped.
• View Tab: The View tab changes display settings.
• Insert Tab: The Insert tab adds tables, charts, and pictures.

Correct answer: A red triangle on the right side of the cell. In Excel 2010, a small red triangle in the upper-right corner of a cell indicates a comment.

• Text on the left side of the cell: Comments are not shown on the left side of the cell.
• Text at the bottom of the cell: Comments are not shown at the bottom of the cell.
• Text in the formula: Comments are not part of the formula.

Correct answer: Shift+Enter. Shift + Enter inserts a line break within the same paragraph.

• Enter: Enter starts a new paragraph.
• Ctrl+Enter: Ctrl + Enter inserts a page break.
• Alt+Enter: Alt + Enter is not the line-break shortcut.

Correct answer: Title Bar. The title bar sits at the top of the window and displays the document and program name.

• Menu Bar: The menu bar lists menus below the title bar.
• Tool Bar: The toolbar holds command buttons.
• Status Bar: The status bar is at the bottom of the window.

Correct answer: Word Wrap. Word wrap automatically continues text on the next line at the margin.

• Line Break: A line break is inserted manually.
• Justify: Justify spaces text to align both margins.
• Align: Align positions text left, right, or centre.

Correct answer: Slide Show View. Slide Show view displays each slide full-screen for presenting.

• Normal View: Normal view is the editing view.
• Outline View: Outline view shows the slide text.
• Notes View: Notes view shows speaker notes.

Correct answer: 10%–500%. MS Word allows zoom from 10% to 500%.

• 10%–300%: 300% is below Word’s maximum.
• 5%–200%: 5%–200% does not match Word’s range.
• 1%–1000%: 1%–1000% does not match Word’s range.

Correct answer: Slide Sorter View. Slide Sorter view displays many slides at once as thumbnails.

• Reading View: Reading view shows the presentation one slide at a time in the window.
• Normal View: Normal view edits one slide at a time.
• None of these: “None of these” is incorrect because Slide Sorter view is correct.

Correct answer: Slide Sorter View. Slide Sorter view shows all slides as thumbnails so they can be rearranged.

• Normal View: Normal view shows one slide for editing.
• Outline View: Outline view shows the text of the slides.
• Notes View: Notes view shows a slide with its speaker notes.

Correct answer: Animation. The Animations tab applies animation effects to objects.

• Design: The Design tab applies themes and backgrounds.
• Transition: The Transitions tab applies effects when moving between slides.
• View: The View tab changes how the presentation is displayed.

Correct answer: F5. F5 starts the slideshow from the first slide.

• F4: F4 repeats the last action.
• F7: F7 starts the spelling check.
• Ctrl+F5: Ctrl + F5 is not the standard key to start the slideshow from the beginning.

Correct answer: COUNT. COUNT counts only cells that contain numbers.

• COUNTA: COUNTA counts all non-empty cells, including text.
• COUNTBLANK: COUNTBLANK counts empty cells.
• COUNTIF: COUNTIF counts cells that meet a condition.

Correct answer: LAN. A LAN (Local Area Network) covers a small area such as a room, building, or campus.

• WAN: A WAN covers large areas such as countries.
• MAN: A MAN covers a city.
• PAN: A PAN covers a person’s immediate surroundings (a few metres).

Correct answer: Count cells containing numbers. COUNT counts the cells in a range that contain numbers.

• Sum cells: SUM adds the values.
• Find average: AVERAGE finds the mean.
• Find maximum: MAX finds the maximum.

Correct answer: Print Preview. Print Preview shows how the document will look on paper before printing.

• Save: Save stores the file and does not show print output.
• Page Setup: Page Setup sets margins and size but does not show the final result.
• Print Properties: Print Properties are printer-specific settings.

Correct answer: NOW(). NOW() returns the current date and time.

• DATE(): DATE() builds a date from year, month, and day values.
• TIME(): TIME() builds a time from hour, minute, and second values.
• TODAY(): TODAY() returns only the current date.

Correct answer: Being able to work for hours without fatigue. Diligence means a computer can work for long hours without tiredness or loss of accuracy.

• Ability to do multiple things at once: Doing multiple things at once is multitasking.
• Works fast: Working fast is speed.
• None of these: “None of these” is incorrect because working without fatigue is correct.

Correct answer: Computer Hardware. The operating system controls and manages computer hardware and provides services for applications.

• Applications Software: It supports applications, but its core job is managing hardware.
• Personal Software: “Personal software” is not a standard term in this context.
• None of these: “None of these” is incorrect because computer hardware is correct.

Correct answer: Vint Cerf. Vint Cerf and Bob Kahn designed the TCP/IP protocols in the 1970s.

• Bill Gates: Bill Gates co-founded Microsoft.
• Charles Babbage: Charles Babbage designed the Difference Engine.
• Steve Jobs: Steve Jobs co-founded Apple.

Correct answer: Application Software. Application software is designed to help users perform specific tasks such as writing, calculating, or browsing.

• System Software: System software runs and manages the hardware.
• Utility Software: Utility software maintains and optimises the computer.
• Programming Software: Programming software is used by programmers to write programs.

Correct answer: To summarize and analyze data. A pivot table summarizes and analyzes large amounts of data interactively.

• Print data: Printing is done with the Print command.
• Sort data: Sorting is done with the Sort command.
• Filter data: Filtering is done with the Filter command.