Office Automation and Business Communication Skills
Domain 7 - Office Automation and Business Communication Skills
This domain tests the spreadsheet, document and email skills a documentation assistant uses daily: cleaning data, matching rates, flagging deadlines, and writing messages that get action.
Spreadsheet rules
- SUMIFS totals freight by lane, transporter or month: =SUMIFS(Freight, Lane, "Ludhiana-Delhi", Month, "Apr").
- VLOOKUP with FALSE / XLOOKUP for exact-match rate and HS-code lookups. An approximate match silently returns wrong rates.
- IF for compliance flags; TRIM/PROPER to clean names and GSTINs pasted from emails; data validation to block invalid dates or codes.
- Use ROUND where money must be rounded - cell formatting changes display only, not the stored value.
- Dates must be true dates, not text, or e-way bill validity formulas fail.
Communication rules
- Subject line carries document number and action: "GRN 4471 - shortage - approval needed".
- One topic per email; state what you need, by when and from whom; name attachments with version and date (Invoice_INV-2291_2024-06-12.pdf).
- CC keeps the supervisor informed; BCC protects recipient lists and should not be used to hide information from colleagues.
- Minutes record decision, owner and deadline - not the discussion.
Worked example
Column D holds the e-way bill validity end date. To flag expiry: =IF(TODAY()>D2,"EXPIRED","VALID"). To total freight paid to one transporter on expired trips: =SUMIFS($F$2:$F$500,$B$2:$B$500,"GATI",$C$2:$C$500,"EXPIRED"). Reasoning: SUMIFS sums only rows meeting all criteria, so the result is that transporter's expired-trip freight, not his whole billing.
Traps
- Pasting values over formulas and losing the audit trail.
- VLOOKUP without FALSE and accepting the nearest match.
- Sending a phone photo of a document instead of a readable PDF.
- Replying-all with rate sheets that contain confidential margins.