Q58.
A net sales projection for the next year is being formulated for three(3) markets, assuming
a 15% market growth rate. The formula is to be entered in cell C4, and the contents of cell
C4 will be copied to cells C5 and C6. Which of the following formulas should be entered
in cell C4?
1
A
B
Growth rate
15%
C
2
3
2009
4
Market A
8,500
5
Market B
4,000
6
Market C
15,000
2010
a) =B4*(1+B1)
b) =B4*(1+B$1)
c) =B4*1+B$1
d) =B4*B$1
Q59.
Which of the following is the image format that has all of the characteristics described
below?
Practice exam 1
(1) Used for static images.
(2) Records 24-bit RGB data as separate luminance information and chromatic information, making it suitable for images with natural colors, such as photographs.
(3) Performs finer digitization for lower-frequency components, because human vision is
less sensitive to high frequency components and more sensitive to low frequency
components.
(4) When a compressed file is decompressed, the original image may not be completely
restored.
a) BMP
b) GIF
c) JPEG
d) MPEG
Q60.
Which of the following indicates the number of pages that can be printed per minute, as a
unit for evaluating the performance of a printer?
a) cps
b) cpi
c) dpi
d) ppm
324