Computer Applications - MS Office Complete Study Summary

Comprehensive fill-in-the-blank flashcards covering Microsoft Word, Excel, PowerPoint, Outlook, Publisher, and OneNote based on the lecture summary.

Microsoft Word is a word-processing application primarily used to create and edit documents such as __________.

Reports, Letters, Memos, and Proposals

Microsoft Excel is a __________ application used for data management, numerical calculations, and financial models.

spreadsheet

Microsoft Outlook serves as an email client and a __________ manager.

personal information

In Microsoft Office, __________ are predefined sets of formatting used to maintain consistency for headings, subheadings, and body text.

Styles

Excel allows users to perform calculations using cell values through basic formulas, such as __________.

$$=SUM(A1:A10)$$

In Excel, __________ applies formatting based on specified conditions to highlight patterns or outliers.

Conditional formatting

To switch between open windows using a keyboard shortcut, a user should press __________.

Alt+Tab

Sequences of actions that can be triggered with a single command to automate repetitive tasks are called __________.

Macros

The feature in Word and Excel that records additions, deletions, and formatting changes made by collaborators is __________.

Track Changes

The main command center of Microsoft Word, containing tabs like Home, Insert, and Page Layout, is known as the __________.

Ribbon

A feature useful for creating personalized documents in bulk is __________.

Mail Merge

In Word, a __________ can communicate the status of a document, such as indicating it is a "Draft."

Watermark

A __________ is a legally binding agreement that defines terms and conditions.

Contract

The Excel workspace is based on a grid composed of rows, columns, and __________.

cells

In Excel formulas, all equations must begin with the __________ symbol.

$$=$$

The Excel function used for showing trends over time is the __________.

Line chart

In PowerPoint, the __________ controls the overall design and helps maintain visual consistency across all slides.

Master Slide

The __________ in PowerPoint provides the speaker with upcoming slides, notes, and elapsed time during a presentation.

Presenter View

In terms of slide accessibility, __________ provides descriptions of images for individuals with visual impairments.

Alt text

In Outlook, __________ can be created to automatically organize incoming emails based on predefined criteria.

Rules

To notify a sender that their email has been opened by the recipient, Outlook uses __________.

Read Receipts

Microsoft Publisher is a __________ application used for creating flyers, brochures, and newsletters.

desktop publishing

When preparing a publication for professional printing, __________ settings are used to prevent unwanted white borders when design elements extend to the page edge.

Bleed

Professional printing services typically use the __________ colour mode.

CMYK

The organizational hierarchy of Microsoft OneNote is Notebook → __________ → Page.

Section

The OneNote feature that converts handwritten notes into editable text is called __________.

Ink-to-Text