Angola Civil Service Entry Competition: Basic Computer Skills and Digital Literacy

What you must master

Practical office computing: file systems (folders, paths, extensions, save vs save-as), word processing (formatting, styles, headers, tables, spell-check), spreadsheets (cell references, relative vs absolute with $, basic functions such as SOMA/SUM, MÉDIA/AVERAGE, SE/IF, sorting and filtering), presentations, email (to, cc, bcc, attachments, spam), internet and browsers (URL structure, HTTPS, cookies), and digital security (strong passwords, phishing, malware, backups). Also basic awareness of e-government services and digital signatures.

Traps that appear

• Confusing cc (visible copy) with bcc (blind copy).
• Mixing relative (A1) and absolute ($A$1) references when copying formulas - copying =A1*$B$1 down keeps the column B fixed.
• Believing HTTPS guarantees a trustworthy site - it only encrypts the connection.
• Confusing Save (overwrite) with Save As (new file/format).
• Deleting a shortcut thinking the program is removed.

Rule of thumb (worked example)

When copying a formula, read each reference: a $ “locks” the row or column. Formula =SOMA(A1:A5) in B1, copied to B2, becomes =SOMA(A2:A6) because both ends are relative. If you need the total of a fixed range, write =SOMA($A$1:$A$5) so the range does not shift.