Ruankao Information Processing Technician (Junior) cheat sheet

Distinguish CPU, RAM, persistent storage, inputs and outputs.

A filename suffix is a format hint, not proof or a conversion operation.

Copy, move, shortcut and synchronized deletion have different consequences.

Save, AutoRecover, synchronization and independent backup serve different purposes.

Use paragraph styles and structural fields for consistent long documents.

Page breaks, section breaks, paragraph spacing and margins solve different layout problems.

Preview mail-merge records and distinguish review markup from final approval.

PDF preserves a distribution layout but is not a universal editing or secrecy barrier.

Trace relative, absolute and mixed references before filling formulas.

Formatting changes display and can hide the actual stored value.

Sorting and filtering have different effects on table data.

Chart and print settings require verification of ranges, labels, units and legibility.

Relative references shift when copied; absolute references use $ to stay fixed.

Formulas recalculate from precedent cells; pasted values do not.

Mail merge needs a main document and a data source with matching field names.

PDF targets fixed-layout distribution; editable source structure is generally maintained more conveniently in the authoring format.

Chart choice follows the question: trend, comparison, or composition.

Share files with least privilege and version control.

Tables, forms, queries and reports serve different data tasks.

Linked and embedded objects have different update and distribution dependencies.

Wi-Fi, internet access, a domain name and a URL are different concepts.

Bcc is a recipient-display mechanism, not universal confidentiality.

HTTPS does not prove that a website or message is trustworthy.

Check media quality, rights, permissions and tested recovery requirements.