First 50 of 200 questions. Each one lists the choices, the correct answer, and an explanation. The checker at the top of this page saves progress in this browser when it is available.
Continue in the practice tool above to load more questions, 50 at a time.
Question 1Information Technology Fundamentals and Computer Systems
Which unit is the smallest addressable storage location in a computer's main memory?
- A nibble
- A word
- A bit
- A byte Correct answer.
Explanation
Main memory is organised so that each location holds one byte and has its own address, which is why memory size is quoted in bytes. A bit is smaller but is not individually addressed, and a word is a processor-dependent group of bytes.
Question 2Information Technology Fundamentals and Computer Systems
In a spreadsheet used for an ITeS data-entry job, which cell reference stays fixed when copied from cell C3 to cell D4?
- C3
- $C$3 Correct answer.
- $C3
- C$3
Explanation
A dollar sign before both the column letter and the row number makes an absolute reference, so both parts stay fixed when the formula is copied. Mixed references lock only one part, and a plain reference shifts in both directions.
Question 3Information Technology Fundamentals and Computer Systems
Which type of software is an operating system such as Windows or Linux classified as?
- Utility firmware
- Programming language
- System software Correct answer.
- Application software
Explanation
An operating system manages hardware, files and processes, which places it in the system software category. Application software performs user tasks, and a programming language is a notation for writing programs.
Question 4Information Technology Fundamentals and Computer Systems
A school office wants to send the same circular letter to 500 parents with each parent's name inserted. Which feature should be used?
- Spell check
- Track changes
- Macro recording
- Mail merge Correct answer.
Explanation
Mail merge combines one main document with a data source so that personalised copies are generated for each record. Track changes records edits, spell check corrects text, and macros automate repeated actions rather than personalise documents.
Question 5Information Technology Fundamentals and Computer Systems
Which device is an example of an input device used in a computerised billing counter?
- Barcode scanner Correct answer.
- Laser printer
- Monitor
- Plotter
Explanation
An input device sends data into the computer, and a barcode scanner converts printed codes into digital data for billing. Printers, monitors and plotters present output to the user instead.
Question 6Information Technology Fundamentals and Computer Systems
What does the abbreviation ITeS stand for in the context of this vocational course?
- Information Technology enabled Services Correct answer.
- Integrated Telecommunication Services
- Internet Technology and Systems
- Information Transfer and Encryption Standards
Explanation
ITeS refers to Information Technology enabled Services, the service sector that delivers business processes using IT infrastructure. Typical examples include call centres, data entry, medical transcription and back-office operations.
Question 7Information Technology Fundamentals and Computer Systems
Which number system uses only the digits 0 and 1 and is the basis of digital circuit operation?
- Binary Correct answer.
- Decimal
- Octal
- Hexadecimal
Explanation
Binary uses two symbols, 0 and 1, which map directly onto the off and on states of digital circuits. Octal and hexadecimal are compact shorthand notations built from binary groups.
Question 8Information Technology Fundamentals and Computer Systems
In a computer network, what is the main purpose of a router?
- To forward data packets between different networks Correct answer.
- To convert analogue signals into digital form
- To cool the processor during heavy load
- To store files for a single user
Explanation
A router examines destination addresses and forwards packets between networks, which is what allows internetwork communication. Storage, signal conversion and cooling are handled by other components.
Question 9Information Technology Fundamentals and Computer Systems
A file of 2,048 bytes is stored on a disk. How many kilobytes does it occupy if 1 KB equals 1,024 bytes?
- 0.5 KB
- 4 KB
- 1 KB
- 2 KB Correct answer.
Explanation
Dividing 2,048 bytes by 1,024 bytes per kilobyte gives exactly 2 KB. The conversion relies on the binary definition where one kilobyte equals 1,024 bytes, not 1,000.
Question 10Information Technology Fundamentals and Computer Systems
What is the decimal value of the binary number 1011?
- 11 Correct answer.
- 9
- 13
- 15
Explanation
Evaluating place values from left to right gives 8 + 0 + 2 + 1, which equals 11. Each position represents a power of two starting from 2^0 on the right.
Question 11Information Technology Fundamentals and Computer Systems
Which component of a computer performs arithmetic and logical operations and holds intermediate results in registers?
- Primary memory
- Control unit
- Arithmetic Logic Unit Correct answer.
- Bus interface
Explanation
The Arithmetic Logic Unit carries out addition, subtraction and comparisons, storing operands and results in its registers. The control unit directs operations, memory stores data, and the bus carries signals between parts.
Question 12Information Technology Fundamentals and Computer Systems
A candidate must save a report so that it can be opened by any office suite without losing formatting. Which file format is most suitable?
- A proprietary binary document format
- An image format
- A plain text file
- Portable Document Format Correct answer.
Explanation
Portable Document Format preserves layout and fonts and can be opened on almost any platform with a free reader. A proprietary binary format may lose formatting elsewhere, plain text drops all formatting, and an image format cannot carry selectable text.
Question 13Information Technology Fundamentals and Computer Systems
Which of the following best describes the role of an operating system in managing memory?
- It permanently stores user files on the hard disk
- It physically expands the capacity of RAM chips
- It converts high-level code into machine code
- It allocates and reclaims memory space for running processes Correct answer.
Explanation
The operating system tracks which memory regions are in use, assigns space to processes and frees it when they finish. It cannot change physical RAM capacity, permanent storage is the file system's job, and translation is done by compilers or interpreters.
Question 14Information Technology Fundamentals and Computer Systems
In an ITeS data-processing workflow, what does the term turnaround time refer to?
- The cost of the software licence per seat
- The number of employees assigned to a shift
- The time taken to complete a task from receipt to delivery Correct answer.
- The physical distance between client and vendor sites
Explanation
Turnaround time measures the total elapsed time between receiving a request and returning the completed output. It is a key service-level measure in ITeS operations because clients expect predictable delivery.
Question 15Information Technology Fundamentals and Computer Systems
Which of these is the strongest example of a good password policy for a data-entry operator?
- Using a long passphrase with mixed characters changed at regular intervals Correct answer.
- Using the same short password on all systems for convenience
- Writing the password on a note stuck to the monitor
- Sharing the password with a supervisor so work can continue during absence
Explanation
Long passphrases with a mixture of character types resist guessing and brute-force attacks, and periodic changes limit the damage from any leak. Reuse, sharing and visible notes all weaken security.
Question 16Information Technology Fundamentals and Computer Systems
What is the primary function of an Internet Service Provider in a home connection?
- To encrypt all files on the subscriber's computer
- To manufacture the modem installed in the home
- To design web pages for subscribers
- To assign public addresses and route traffic to the internet Correct answer.
Explanation
An ISP provides the link between a subscriber's network and the wider internet, allocating addressing and carrying traffic. It does not build hardware, create websites or manage local file encryption.
Question 17Information Technology Fundamentals and Computer Systems
A spreadsheet cell contains the formula =SUM(A1:A5) and the values in those cells are 10, 20, 30, 40 and 50. What does the cell display?
- 150 Correct answer.
- 100
- 50
- 250
Explanation
The SUM function adds every value in the range A1 to A5, giving 10 + 20 + 30 + 40 + 50 = 150. The range includes all five cells, so no value is omitted.
Question 18Information Technology Fundamentals and Computer Systems
Which statement correctly distinguishes primary memory from secondary storage?
- Primary memory is non-volatile while secondary storage loses data when power is removed
- Primary memory stores files permanently while secondary storage holds only running programs
- Primary memory is volatile and directly accessed by the CPU, while secondary storage is non-volatile and slower Correct answer.
- Primary memory has larger capacity than secondary storage in every computer
Explanation
Primary memory such as RAM is fast, directly reachable by the processor and loses its contents when power is cut. Secondary storage such as a hard disk retains data without power but is slower to access.
Question 19Information Technology Fundamentals and Computer Systems
A user wants to send a message to 40 colleagues in an ITeS team without revealing each recipient's address to the others. Which field should be used?
- To
- Subject
- Cc
- Bcc Correct answer.
Explanation
Addresses placed in Bcc receive the message while remaining hidden from other recipients, which protects privacy in group mail. The To and Cc fields display every address to all receivers, and Subject carries only the topic line.
Question 20Information Technology Fundamentals and Computer Systems
Which protocol is responsible for reliably delivering web pages from a server to a browser?
- HTTP Correct answer.
- DNS
- FTP
- SMTP
Explanation
HTTP defines how a browser requests resources from a web server and how the server responds, with TCP underneath providing reliable delivery. FTP transfers files, SMTP sends mail, and DNS resolves names to addresses.
Question 21Information Technology Fundamentals and Computer Systems
A company stores customer records in a database. Which practice best supports the principle of data minimisation?
- Sharing the full dataset with every department
- Retaining all records indefinitely for future analysis
- Collecting only the fields needed for the stated purpose Correct answer.
- Collecting every possible field in case it becomes useful later
Explanation
Data minimisation means gathering only what is necessary for a defined purpose, which reduces risk and storage burden. Collecting extra fields, keeping records forever and broad internal sharing all increase exposure without a clear need.
Question 22Information Technology Fundamentals and Computer Systems
A process needs 3 pages of memory but only 2 frames are free, so the system temporarily moves a page to disk. Which mechanism is being described?
- Spooling
- Caching
- Paging with swapping Correct answer.
- Buffering
Explanation
Paging divides memory into fixed-size pages and frames, and swapping moves pages to disk when frames run short. Caching keeps copies of frequently used data, buffering smooths data flow, and spooling queues jobs for a device such as a printer.
Question 23Information Technology Fundamentals and Computer Systems
Two employees edit the same shared document simultaneously and one overwrites the other's paragraph. Which control best prevents this loss?
- Reducing the document font size
- Frequent manual saving under new file names
- Version control with change tracking and conflict review Correct answer.
- Disabling the network connection during editing
Explanation
Version control records each change with its author and supports conflict review, so simultaneous edits can be merged instead of overwritten. Renaming files creates confusion, and disconnecting the network blocks collaboration entirely.
Question 24Information Technology Fundamentals and Computer Systems
A binary number has its leftmost bit set to 1 in an 8-bit unsigned representation. What does this indicate about its value?
- The value is odd
- The value is zero
- The value is negative
- The value is at least 128 Correct answer.
Explanation
In an 8-bit unsigned representation the leftmost bit carries the place value 2^7, which is 128, so setting it makes the value at least 128. Sign is only interpreted when a signed representation is declared, and parity depends on the rightmost bit.
Question 25Information Technology Fundamentals and Computer Systems
An ITeS vendor must choose between on-premises servers and cloud hosting for a seasonal workload that spikes for three months each year. Which reasoning best supports the cloud choice?
- Cloud hosting removes the need for any data security policy
- On-premises servers cannot run business applications
- On-premises servers always have lower total cost for short periods
- Cloud capacity can scale up and down, matching cost to seasonal demand Correct answer.
Explanation
Elastic cloud capacity lets the vendor pay for resources only during the seasonal peak, avoiding idle hardware for the rest of the year. Security policy is still required in the cloud, and on-premises servers do run business applications.
Question 26Information Technology Fundamentals and Computer Systems
In an IT-enabled services office, which unit is used to express the clock speed of a processor, and what does one such unit represent?
- Watt, where one watt equals one instruction per second
- Hertz, where one hertz equals one cycle per second Correct answer.
- Byte, where one byte equals eight bits per second
- Pixel, where one pixel equals one screen refresh per second
Explanation
Clock speed measures how many operating cycles a processor completes each second, so it is expressed in hertz and its multiples such as megahertz and gigahertz. One hertz by definition equals one cycle per second, which makes it the correct unit for this quantity.
Question 27Information Technology Fundamentals and Computer Systems
A data-entry operator in an ITeS centre needs to keep 12 GB of scanned documents on a single portable device and carry it between workstations. Which storage medium is most appropriate?
- A DVD-R disc with 4.7 GB capacity
- A USB flash drive with 16 GB capacity Correct answer.
- A floppy disk with 1.44 MB capacity
- A CD-R disc with 700 MB capacity
Explanation
The requirement is a portable medium whose capacity exceeds 12 GB. Only the 16 GB flash drive holds the full set of documents, and it is rewritable and easily carried between machines.
Question 28Information Technology Fundamentals and Computer Systems
An ITeS team receives a scanned form as an image file and must extract the typed text so it can be edited in a word processor. Which technology performs this conversion?
- Vector rasterisation
- Optical character recognition Correct answer.
- Packet switching
- Disk defragmentation
Explanation
Optical character recognition analyses the shapes of characters in a scanned image and converts them into machine-editable text codes. This is the standard method used in document-processing workflows to turn paper or image scans into editable documents.
Question 29Information Technology Fundamentals and Computer Systems
A payroll clerk must total a column of 200 salary figures in a spreadsheet and later correct any single figure without redoing the whole calculation. Which approach best satisfies both requirements?
- Enter a formula that references the cell range so the total updates automatically Correct answer.
- Copy the figures into a word processor table and add them manually
- Sort the column in ascending order and read the last value as the total
- Type the total as a fixed number after adding the figures on a calculator
Explanation
A formula that references the range recalculates whenever any cell in that range changes, so a correction propagates to the total without further work. This is the defining advantage of spreadsheet formulas over values typed in by hand.
Question 30Information Technology Fundamentals and Computer Systems
A workstation in an ITeS office has 4 GB of RAM and frequently runs several large applications at once, causing heavy use of virtual memory on the hard disk. Which upgrade addresses the root cause most directly?
- Increase the installed RAM so more programs fit in primary memory Correct answer.
- Install a higher-resolution monitor
- Replace the hard disk with a larger-capacity model
- Add a second network interface card
Explanation
Virtual memory is used when active programs exceed the space available in RAM, so pages are swapped to disk and performance drops. Adding RAM reduces the need to swap and therefore attacks the cause rather than the symptom.
Question 31Office Productivity Tools (Word Processing, Spreadsheet, Presentation)
In a word processor, which paragraph alignment setting stretches the line by adding space between words so that both the left and right margins are flush?
- Align left
- Align right
- Justify Correct answer.
- Center
Explanation
Justified alignment distributes extra space between words so each full line touches both margins, producing even block edges. Center and the two single-side alignments leave one edge ragged instead of stretching word spacing.
Question 32Office Productivity Tools (Word Processing, Spreadsheet, Presentation)
A student wants the heading 'Chapter 1' to appear at the top of every printed page of a report. Where should this text be placed?
- In the header area Correct answer.
- In the footer area
- In a footnote
- In a text box on page one
Explanation
The header region repeats automatically on every page of the section, so a chapter title placed there appears on all printed pages. A footer sits at the bottom, a footnote is tied to a page's body text, and a text box stays on a single page.
Question 33Office Productivity Tools (Word Processing, Spreadsheet, Presentation)
Which spreadsheet feature is designed to display only the rows that meet a stated condition while hiding the rest?
- Sort
- Conditional formatting
- Filter Correct answer.
- Freeze panes
Explanation
A filter temporarily hides rows that fail the condition, leaving only matching records visible. Sorting only reorders rows, freezing panes locks scrolling, and conditional formatting changes appearance without hiding data.
Question 34Office Productivity Tools (Word Processing, Spreadsheet, Presentation)
In a spreadsheet, a formula begins with which character?
- = Correct answer.
- #
- &
- @
Explanation
Every spreadsheet formula starts with the equals sign, which tells the program to evaluate the following expression rather than store it as text. The other characters are used inside formulas or as text operators but cannot start one.
Question 35Office Productivity Tools (Word Processing, Spreadsheet, Presentation)
A presentation slide should show a bulleted list where each point flies in one after another when the presenter clicks. Which feature provides this?
- Slide master formatting
- Custom animation applied to each bullet Correct answer.
- Slide transition applied to the slide
- Speaker notes
Explanation
Animations control how individual objects such as bullet lines enter the slide, so each point can appear on a click. Transitions govern the change between whole slides, the slide master sets layout defaults, and speaker notes are hidden presenter text.
Question 36Office Productivity Tools (Word Processing, Spreadsheet, Presentation)
Which file format is most suitable for sending a word-processed document that must look identical on any computer but should not be easily edited?
- PDF Correct answer.
- PPTX
- TXT
- CSV
Explanation
PDF preserves fixed layout and fonts across systems and is awkward to edit, which suits final distribution copies. TXT loses all formatting, CSV stores tabular data, and PPTX is a slide format rather than a fixed document.
Question 37Office Productivity Tools (Word Processing, Spreadsheet, Presentation)
In a spreadsheet, what does the cell reference $B$4 mean when copied to another cell?
- Both the column and the row change
- The column stays fixed but the row changes
- The row stays fixed but the column changes
- Both the column and the row stay fixed Correct answer.
Explanation
Dollar signs before both the column letter and the row number create an absolute reference, so copying the formula keeps it pointing at B4. A single dollar sign would lock only one part of the reference.
Question 38Office Productivity Tools (Word Processing, Spreadsheet, Presentation)
Which spreadsheet function adds together the values in the range A1 to A10?
- =AVERAGE(A1:A10)
- =COUNT(A1:A10)
- =SUM(A1:A10) Correct answer.
- =MAX(A1:A10)
Explanation
SUM returns the total of all numeric values in the given range. COUNT reports how many numeric cells exist, AVERAGE divides the total by the count, and MAX returns only the largest value.
Question 39Office Productivity Tools (Word Processing, Spreadsheet, Presentation)
A report requires every main heading to use the same font, size, and colour, and a later change must update all of them at once. Which approach achieves this?
- Apply a heading style to each main heading Correct answer.
- Insert each heading inside a separate table cell
- Format each heading manually with the font dialog
- Copy the formatted heading and paste it as plain text
Explanation
Styles store a named set of formatting attributes, so editing the style definition updates every paragraph that uses it. Manual formatting, plain-text pasting, and table cells each require separate edits and drift out of consistency.
Question 40Office Productivity Tools (Word Processing, Spreadsheet, Presentation)
A spreadsheet cell shows #### instead of a number after a calculation. What is the most likely cause?
- The formula contains a division by zero
- The cell is formatted as text
- The workbook is read-only
- The column is too narrow to display the result Correct answer.
Explanation
Spreadsheet programs replace a numeric result with hash marks when the column width cannot fit the displayed value. Widening the column reveals the number; a division by zero would instead show a specific error value.
Question 41Office Productivity Tools (Word Processing, Spreadsheet, Presentation)
In a presentation, the slide master is edited. What is the effect?
- Only the first slide of the deck changes
- Only the speaker notes change
- The change applies to all slides that use that master layout Correct answer.
- Only the currently selected slide changes
Explanation
The slide master holds the shared design for its layouts, so edits to placeholders, fonts, or background propagate to every slide built on those layouts. Individual slides, notes, and the title slide are not the scope of the master.
Question 42Office Productivity Tools (Word Processing, Spreadsheet, Presentation)
A word processor's Find and Replace is used with 'Match case' enabled to replace 'it' with 'IT'. What happens to the word 'It' at the start of a sentence?
- It is left unchanged because the case does not match Correct answer.
- It is replaced only if it appears in a heading
- It is replaced and the case is converted to lowercase
- It is replaced because case is ignored
Explanation
With Match case active, the search is case-sensitive, so the pattern 'it' matches only lowercase occurrences. The capitalised 'It' fails the match and remains untouched.
Question 43Office Productivity Tools (Word Processing, Spreadsheet, Presentation)
A formula in cell C1 is =A1+B1. It is copied down to C2. Which formula appears in C2?
- =A2+B2 Correct answer.
- =A1+B1
- =A1+B2
- =$A$1+$B$1
Explanation
Relative references shift by the same number of rows and columns as the copy, so moving down one row changes A1 and B1 to A2 and B2. Absolute references or partial shifts would require dollar signs.
Question 44Office Productivity Tools (Word Processing, Spreadsheet, Presentation)
Which spreadsheet function counts only the cells in a range that satisfy a given condition?
- SUMIF
- IF
- COUNTIF Correct answer.
- COUNTA
Explanation
COUNTIF tallies cells matching a specified criterion such as a value or comparison. COUNTA counts all non-empty cells, SUMIF adds matching values instead of counting them, and IF returns one of two results per cell.
Question 45Office Productivity Tools (Word Processing, Spreadsheet, Presentation)
A chart in a report must update automatically when the underlying worksheet values change. Which step ensures this?
- Create the chart from the worksheet range so it stays linked Correct answer.
- Type the current values into the chart title
- Convert the chart to a static image file
- Paste the chart as a picture into the report
Explanation
A chart built directly from a worksheet range keeps a live link to those cells, so edits to the data redraw the chart. Pictures, typed labels, and image files are static snapshots that cannot refresh.
Question 46Office Productivity Tools (Word Processing, Spreadsheet, Presentation)
In a word processor, what is the main purpose of inserting a page break?
- To force the following content to start on a new page Correct answer.
- To change the orientation of the whole document
- To split a table into separate columns
- To add extra blank space between two paragraphs
Explanation
A manual page break ends the current page immediately so subsequent text begins at the top of the next page. Paragraph spacing, table structure, and page orientation are controlled by separate settings.
Question 47Office Productivity Tools (Word Processing, Spreadsheet, Presentation)
A student types 5/6 into a spreadsheet cell and the program displays 06-May. What is the best explanation?
- The entry was interpreted as a date because of the slash format Correct answer.
- The spreadsheet cannot store fractions
- The number format is set to currency
- The cell contains a formula error
Explanation
Spreadsheets recognise slash-separated entries as dates, so 5/6 is read as day and month and displayed in the default date format. To keep the fraction, the cell must be pre-formatted as a fraction or the entry prefixed as text.
Question 48Office Productivity Tools (Word Processing, Spreadsheet, Presentation)
Which presentation view lets a presenter see the current slide, the next slide, and speaker notes while the audience sees only the slide?
- Reading view
- Presenter view Correct answer.
- Outline view
- Slide sorter view
Explanation
Presenter view runs on the presenter's screen and shows the current slide, a preview of the next slide, notes, and a timer while the projector shows only the slide. Slide sorter and outline views are editing layouts, and reading view is a single-screen preview.
Question 49Office Productivity Tools (Word Processing, Spreadsheet, Presentation)
A table in a word-processed document has a header row that must repeat at the top of each page the table spans. Which setting is used?
- Repeat header rows Correct answer.
- Keep with next paragraph
- Allow row to break across pages
- Distribute columns evenly
Explanation
The repeat-header-rows option marks the first row as a heading so it is reprinted whenever the table continues onto a new page. The other settings control paragraph flow, row splitting, and column widths.
Question 50Office Productivity Tools (Word Processing, Spreadsheet, Presentation)
A worksheet lists marks in column B for 40 students. Which formula returns the highest mark?
- =MIN(B1:B40)
- =COUNT(B1:B40)
- =MAX(B1:B40) Correct answer.
- =MEDIAN(B1:B40)
Explanation
MAX scans the range and returns the largest numeric value, which is the highest mark. MIN gives the lowest, MEDIAN gives the middle value, and COUNT gives the number of entries.