ICT AND ADULT EDUCATION - QUESTIONS

INSTITUTE OF ADULT EDUCATION

ADVANCED DIPLOMA IN ADULT EDUCATION AND COMMUNITY DEVELOPMENT - THIRD YEAR 2010/11

END OF SEMESTER 1 TEST 1 – FEBRUARY 2011

SUBJECT: ICT AND ADULT EDUCATION

CODE: AA 513         DATE:             FEBRUARY 2011                  DURATION: 1HR

INSTRUCTIONS:    Answer any ALL questions. The paper carries 20 marks Circle the correct answer

Official Name (Start with Surname)	Registration Number (Write correctly)

             I.      A program which helps to create written document and lets you go back and make corrections as necessary
a. Home row keys     b. Tool bar     c. Folder         d. Word processor

          II.      Graphics for word processor
a. Peripheral  b. Clip art       c. Highlight   d. Execute

       III.      What type of software is used for creating letters papers and other documents?
a. Database    b. Word Processor   c. Spreadsheet    d. Operating Program

        IV.      What does the Ctrl + I shortcut key accomplish in Ms-Word?
a. It converts selected text into the next larger size of the same font
b. It adds a line break to the document
c. It makes the selected text bold
d. It applies Italic formatting t the selected text.

           V.      What is the file extension of Ms-Word document?
a. Dot          b. Doc                 c. Dom           d. Txt

        VI.      In H2O the figure 2 is appeared lowered. Which effect has been applied?
a. Superscript                        b. Lowered                 c. Subscript                d. Laid down

     VII.      Why are headers and footers used in document?
a. To enhance the overall appearance of the document
b. To mark the starting and ending of a page
c. To make large document more readable
d. To allow page headers and footers to appear on document when it is printed

  VIII.      All formula in Excel start with

a.   %               b.   +               c.   =               d.   -

        IX.      You can use a function to combine text from two cells into one cell. But you can use an operator to do the same thing. Which operator is that?

a.   & (ampersand)   b.   = (equal sign)     c.   (space)     d.   All of the above

           X.      Two common wildcard characters that Excel recognizes are

a.   * and ?                  b.   < and >                c.   ^ and /                 d.   + and -

        XI.      The divide symbol is

a.   /                b.   D               c.   \                d.   )

     XII.      The multiplication arithmetic operator is represented by which of the following symbols?

a.   ^                b.   *                c.   /                d.   X

  XIII.      To add two cells (A1 and A2) together you use the following formula

a.   =A1 + A2     b.   =Add(A1+A2)  c.   =together(A1:A2)   d.   A1 plus A2

  XIV.       To make a number in cell C1 10% smaller than the number in C3 you enter

a.   =C3*1.10               b.   +C3*110               c.   =C3%10                d.   =C3*.90

     XV.      On an excel sheet the active cell in indicated by …

a. A dark wide boarder   b. A dotted border    c. A blinking border   d.None of above

XVI)     The view that puts a blue a blue line around each page that would be printed is the …..

a.Print Preview    b.Normal View      c.Page Break Preview       d.Split View

XVII)  AutoCalculate will quickly add selected cells if you…..

a.      right click on the status bar and select Sum

b.      click the AutoCalculate button on the toolbar

c.      use the key combination Ctrl+$

d.      Double click the selection

XVIII) The cell labeled 23. 54 the cell labeled F5 refers to

a. row F column 5                b. column F row 5              c. function available in cells   d. function key F4

XIX)    A certain spreadsheet shows in Page Break Preview that cells in Rows 1-25 have white background. The cells in row 26 that contain data have a dark grey background, when you click the Print button…..

a.      nothing will print because some cells with data have been omitted

b.      only the cells with gray background will print

c.      the whole sheet will print

d.      only the cells with white background will print

XX)     A constant is another name for this type of data:

a.      number          b.         equation         c.         formula d.      description