COMPUTER APPLICATION WITH CAD LEVEL II DEC 2019

ATTEMPT any five question out of seven.

1.      a) Define the following terms:

                                  i.            Softcopy

                                ii.            Software

                              iii.            Processing device

                              iv.            Fill handle

                                v.            Peripheral device

            b) Differentiate system software from application software.

2.      What do you understand by the following terms as applied in spread sheet.

a)      Cell

b)      Worksheet

c)      Range

d)      Function

3.      a) A worksheet consist of the following working cell reference A2, B2, C2, D2 and user entre the following number 60,65,70  and 75. Write the function expression that could be used to calculate SUM and AVERAGE for 60, 70 and 75.

b) What will be given out if the following functions are applied in a worksheet?

i) Sumif

ii) Sum

4.      What do you understand by the following terms:

a)      Field name

b)      Data type

c)      Record

d)      Record set

5.      a) What do you understand by the following term:

                                     i.            Slide show view

                                   ii.            Slide sorter view

              b) Describe important of using slide design template when creating a slide.

6.      a) Explain on the following terms as applied in database:

                                i.            Table

                              ii.            Query

            b) Explain two advantage of primary key when creating database.

7.      Outline the procedures of doing the following in word processor:

a)      Printing a document

b)      Saving a document

c)      Inserting document to be behind the text

d)      Insert drop cap.