I85PREP
⌘ K
NIELIT BCC study materials
NIELIT BCC study resources

NIELIT BCC: Office Productivity and Internet Skills

NIELIT BCC · Work through your exam, one topic at a time.

All guide sections

Office Productivity and Internet Skills

Core rules

The exam tests practical use of a word processor, spreadsheet, presentation tool, email and the web.

  • Word processing: character and paragraph formatting, styles, tables, page setup, headers and footers, mail merge, spell check. Save the editable file; export to PDF for fixed layout.
  • Spreadsheets: a cell reference such as A1 or a range A1:B5; formulas begin with =; relative references change when copied, absolute references such as $E$1 stay fixed; functions include SUM, AVERAGE, COUNT, IF and MAX; charts visualise ranges.
  • Presentations: slide layouts and master control consistency; transitions move between slides; animations act on objects within a slide; speaker notes are not shown on the slide.
  • Internet: a URL has a scheme (https), host, path and optional query; browsers store history, cookies and bookmarks; search operators include quotes for exact phrases, site: and filetype:.
  • Email: To is the primary recipient, Cc is a visible copy, Bcc is a hidden copy; attachments have size limits; reply goes to sender, reply all goes to all listed recipients.

Worked example

A tax rate of 18% is in E1. Amount 2500 is in B2. The formula =B2*$E$1 returns 450. Copy it to row 3 where B3 is 4000: the result is 720 because $E$1 remains fixed. If the formula were =B2*E1, copying down would use E2, which is empty, giving 0. The dollar signs lock the column and row.

Traps that cost marks

Confusing formula with displayed value; using Bcc when Cc was intended; mixing transitions with animations; saving only a PDF and losing editability; assuming a padlock proves a site is genuine; copying formulas without checking absolute references.