(a) Complete Table 1 wih the appropriate criteria for each medium. Table 1 Criteria/Medium DVD-ROM Hard Disk Magnetic Tape Location of storage media Externa...

Answer Details

(a) Completed Table 1 - Criteria for each storage medium.

Each medium is compared by where it is located, whether it can be removed, and how files are accessed on it.

Reasoning: A hard disk is normally fixed inside the system unit, so it is internal and non-removable, while a DVD-ROM and a magnetic tape are inserted into a drive from outside, so they are external and removable. Both the DVD-ROM and the hard disk allow the read head to jump straight to any location, giving random (direct) access, whereas a magnetic tape must be read in order from the beginning to the required record, giving sequential (serial) access.

(b) Three examples of spreadsheet applications:

• Microsoft Excel
• Lotus 1-2-3
• Apple Numbers (or Google Sheets / VisiCalc)