Office Application Software and Data Presentation Reviewer

What is the definition and scope of office productivity software?

Applications that help people create, organize, calculate, communicate, and collaborate in their work, encompassing word processing, spreadsheets, presentation software, and cloud collaboration tools.

What is a digital workplace?

An office environment where digital tools and shared online files help people work, communicate, and collaborate.

What is digital ethics, and what specific practices does it encompass?

Responsible and honest behavior when using digital tools and information, which includes avoiding plagiarism, giving proper credit or attribution, respecting copyright, handling data responsibly, following file-sharing permissions, protecting private information, not editing files you are only allowed to view, and giving honest credit for collaborative work.

Why is the belief that 'cloud means perfect safety' a misconception?

Cloud files are not automatically safe because they can still be compromised by account hacking or incorrect sharing permissions.

How do local storage and cloud storage differ across location, access, control, offline use, and main risk?

Local storage is saved on a specific device, accessed mostly from that device, completely controlled by the owner, functions offline, and risks device damage, theft, or failure. Cloud storage is saved on remote servers, accessed across devices with internet, managed by the provider, requires an internet connection, and risks account compromise or improper permissions.

What are the five essential components of the Microsoft Word window interface?

The Ribbon (containing tabs like Home, Insert, Layout, References, Review, and View), Quick Access Toolbar (Save, Undo, Redo), Ruler (margins and indentation), Status Bar (word and page count), and Document area (main typing space).

What are the four cloud permission levels and the specific capabilities granted by each?

Viewer (open and read the file only), Commenter (read the file and add comments or suggestions), Editor (read, comment, and change content), and Owner (full control, including deleting the file and managing access permissions).

What is the primary risk of relying on inherited permissions when sharing a folder?

Sharing a folder automatically grants the same access permissions to all files inside it, including any files added in the future; specific files should be shared individually whenever possible.

What four elements must be included in a consistent file naming convention, and why should the date appear first?

1. Date, 2. Clear description, 3. Status or version, and 4. Person responsible (e.g., 2026-09-04_TrimesterNotice_Draft_CherryMaeSucro.docx); placing the date first allows files to sort chronologically automatically.

What is version history, and under what circumstances should it be used?

An automatically saved record of a file's previous versions allowing users to view or restore earlier work; it should be checked before recreating a document from scratch when an edit is deleted, changes are made incorrectly, or a file is overwritten.

What is the recommended first troubleshooting step when edits in a shared file disappear?

Check the file's version history to resolve version conflicts or accidental overwrites.

What three elements are required for effective cloud collaboration?

Organized files + correct permissions + version history, adhering to the principle of giving people only the access they need.

How does direct (manual) formatting differ from using styles according to the 'uniform' analogy?

Direct formatting manually adjusts attributes piecemeal like an improvised outfit, creating inconsistencies; styles act like an agreed uniform, providing a single standard that updates simultaneously across the entire document when modified.

What are the four primary benefits of using styles in word processing?

Consistency across identical levels, Global updates document-wide from a single modification, fast navigation via the Navigation Pane, and consistent formatting standards during multi-user collaboration.

What are the standard page layout settings commonly used for business documents in the Philippines?

Letter paper size ($8.5 \times 11\,\text{inches}$), Portrait orientation, and Normal margins ($1\,\text{inch}$ on all sides).

What is a document template?

A pre-built document structure that comes with consistent styles and page setup already configured.

Why is using tables solely for visual alignment considered a violation of accessibility standards?

Screen readers do not process tables as visual columns; they read tables as meaningful tabular data relationships, confusing users when tables are used purely for visual layout.

What are the two mandatory table design best practices for screen reader accessibility?

Including a clearly defined header row (e.g., Date, Time, Topic) and avoiding merged or split cells.

What are the alt text guidelines for an informational trend chart, an organizational logo, and a purely decorative image?

Informational chart: describe the actual data trend and supply underlying data nearby; Logo/seal: identify the organization by name rather than describing visual shapes; Decorative image: mark as decorative so screen readers bypass it.

What is the function of the Citation Manager under the References tab?

It stores source details once to insert consistent in-text citations and automatically generate a formatted References or Bibliography list, establishing a functional pair that lets readers verify sources.

How do Track Changes and Comments differ under the Review tab?

Track Changes visibly and attributably logs text insertions, deletions, and formatting edits directly in the document, whereas Comments attach notes or suggestions to specific text without altering the text itself.

What are the three severity categories of Word's Accessibility Checker, and what is its primary limitation?

Errors, Warnings, and Tips; its primary limitation is that it only verifies that alt text exists, not whether it is accurate or meaningful, which still requires human judgment.

How does a visual pass differ from a systematic review according to the 'chef' analogy?

A visual pass is a single general glance that catches overall layout impressions while missing structural flaws, whereas a systematic review checks one specific standard completely before moving to the next, like a master chef verifying protein doneness, seasoning, and balance individually.

What are the five passes of the Five-Pass Systematic Review Method?

1. Styles Pass, 2. Page Layout Pass, 3. Tables and Graphics Pass, 4. Citations Pass, and 5. Accessibility Pass.

What is a pass log, and what constitutes genuine integration in document development?

A pass log is a written record documenting what each review pass found, tested, and corrected; genuine integration occurs when formatting, data, citations, and structure function together as a unified whole rather than as isolated checklist items.

Why is a visual pass incapable of properly verifying a bolded section header?

It cannot distinguish whether the text uses a genuine built-in heading style linked to the Styles gallery or merely direct manual bold formatting.

How does a spreadsheet differ fundamentally from a pocket calculator?

A pocket calculator produces a static value with no memory of input relationships, requiring manual recalculation if numbers change; a spreadsheet relies on standing cell references that recalculate formulas automatically when source data changes.

Why is hardcoding values like $=85+90$ into a spreadsheet formula considered bad practice?

Hardcoding turns the spreadsheet into a glorified calculator; using cell references like $=A2+A3$ ensures dependent formulas update dynamically whenever input values change.

What is the difference between an Excel workbook and a worksheet, and how does cross-worksheet referencing work?

A workbook is the entire spreadsheet file (e.g., .xlsx), whereas a worksheet is an individual tab or page within it; cross-worksheet referencing pulls data from another tab into a formula (e.g., $=\text{SOFAPP}!D4$).

What functional advantages does a Structured Table offer over a manually formatted grid?

A Structured Table auto-expands formatting and formula ranges when new rows are added, locks rows together to prevent partial sorting corruption, and supports structured references (e.g., $=\text{SUM}(\text{Grades}[\text{Score}])$).

What are the four components of a Four-Part Descriptive Summary, and why is an average alone insufficient?

Mean ($=\text{AVERAGE}$), Median ($=\text{MEDIAN}$), Minimum ($=\text{MIN}$), and Maximum ($=\text{MAX}$); a single average can conceal severe volatility between datasets that have the same mean.

How does a comparison between the mean and median reveal the presence of outliers in a dataset?

If the mean and median are close, the data is consistent; if they diverge noticeably, one or two extreme outliers are pulling the arithmetic mean.

What syntax rule must always be followed when writing criteria arguments in $=\text{COUNTIF}$ and $=\text{SUMIF}$?

The condition or criteria argument must always be enclosed in quotation marks (