ESIC SSO cheat sheet
ESIC SSO · Keep the key ideas within reach.
Computer Knowledge and Office Application Skills
Shortcuts: Ctrl+C copy, Ctrl+X cut, Ctrl+V paste, Ctrl+Z undo, Ctrl+Y redo, Ctrl+S save, Ctrl+P print, Ctrl+F find.
Word: Ctrl+E centre, Ctrl+J justify, Ctrl+L left, Ctrl+R right; F7 runs spelling and grammar check.
Excel: every formula begins with '='; $A$1 is absolute, A$1 mixed; SUM, AVERAGE, COUNT, IF, VLOOKUP are core functions.
Excel error codes: #DIV/0! division by zero, #REF! deleted cell reference, #VALUE! wrong data type, #N/A value not found.
PowerPoint: F5 starts slideshow from beginning, Shift+F5 from current slide; slide master controls consistent formatting.
Storage units: 1 byte = 8 bits, 1 KB = 1024 bytes, 1 MB = 1024 KB, 1 GB = 1024 MB.
Networking basics: IP address identifies a device, HTTP/HTTPS are web protocols, and a firewall filters incoming and outgoing traffic.
Email: To, Cc (visible copy) and Bcc (hidden copy); attachments are encoded and size-limited by the provider.
Computer generations: first vacuum tubes, second transistors, third integrated circuits, fourth microprocessors, fifth artificial intelligence.