Q58.
b
Section
8-3 Software
Answer
Explanation
The net sales for the next fiscal year is calculated by multiplying the sales in the current fiscal
year for each market by the market growth rate plus one (1). When the formula is entered in
cell C4, it is copied to cells C5 and C6, so the reference to the market growth rate must be
fixed to the first column. Therefore, the correct answer is =B4*(1+B$1) in b).
Q59.
c
Section
9-2 Multimedia
Answer
Explanation
The JPEG file format reflects all of the characteristics.
JPEG is a file format for the compression and storage of static images. It can handle 24-bit
full color (16,770,000 colors) data, making it suitable for images with many color variations
such as photographs.
a): The BMP format is a file format for static images, but does not employ compression, in
contrast with characteristic (4).
b): The GIF format is a file forma t for the compression and storage of static images, but can
only handle 8-bit color (256 colors) data. This does not make it suitable for images with
natural color such as photographs, and contrasts with characteristic (2). Furthermore, GIF
compression is fully reversible to restore the original static image, in contrast with characteristic (4).
)
d : The MPEG format is a file format for the compression and storage of video images, in
contrast with characteristic (1).
Q60.
d
Section
8-4 Hardware
Answer
Explanation
The number of pages that can be printed per minute is called ppm. It is used as a unit to indicate the printing speed of a page printer.
Q61.
a
Section
8-1 Computer component
Answer
Explanation
Cache memory is a type of memory used to speed up data transfer. Data is read from the main
memory and stored in the cache memory, which offers fast access speeds to speed up data
transfer.
Q62.
c
Section
8-3 Software
Answer
Explanation
The statement “when at least one (1) of the processing units must operate normally” indicates
the same availability as if the processing units are connected in parallel. The overall availability factor is calculated as follows:
1− (1 − 0.9) × (1 − 0.9) = 0.99
The statement “when both processing units must operate normally” indicates the same availability as if the processing units are connected in series. The availability factor for both
processing units is calculated as follows:
0.9 × 0.9 = 0.81
Therefore, the difference in the availability factor is:
0.99 − 0.81 = 0.18
29