Computer Knowledge

1.       Cell address A$4 in a formula means it is a

            1) mixed cell reference     2) absolute cell reference   
            3) Relative cell reference 

            4) All  of  the above         5) None of the above

2.       Using the F11 shortut key to create a hart on chart sheet creates

            1) A default chart

            2) A 2-dimensional coulumn chart

            3) A2-dimenasional bar chart

            4) A 3- dimensional line chart

            5) None of the above

3.       You can print

            1) a range of cells by range name   2) an entire worksheet

            3) a single worksheet                    4)  All of the above

            5) None of the above

4.       You can create only a horizonatal page break by firs selecting

            1) a row below the row where you want the page break to occur

            2) a cell in row 1          3) a cell in column A

            4) Bot ‘1’ and ‘3’         5) All of the above

5.       You can create hyperlinks from the Excel work book to

            1) a web page on company internet

            2) a web page on the internet

            3) other office 97 application documents

            4) All of the above

            5) None of above

6.       The advatage of using a spradsheet is

           1) calculations can be done automatically     

2) changing data automatically updates calculations

3) more flexibility

4) All of the above  

5) None of  the above

7.       You can not link excel worksheet data to a word document

            1) with the right drag method 

            2) with a hyperlink

            3) with the copy and paste special commands

            4) with the copy and paste buttons on the standard toolbar

      5) None of the above

8.       Which of the following is a popular DOS based spreadsheet package?

      1) Word    2) Smart cell         3) Excel    4) Lotus 1-2-3 

       5) None of these

9.       Which file format can be added to a PowerPoint show?

      1) .jpg      2) .giv           3) .wav   4) All of these 

      5) None of these

10.       In Microsoft Power Point two kind of sound effects files that can be added                 to the presentation are

      1) .wav files and .mid files        2) .wav files and .gif files

      3) .wav files and .jpg files         4) .jpg files and .gif files

      4) . None of the above

11.       Material consisting of text and numbers is best presented as

      1) a table slide      2) a bullet slide     3) a title slide

      4) All of these      5) None of these

12.       What is a motion path ?

      1) A type of animation entrance effect 

      2) A method of advacing slides

      3) A method of moving items on a slide

      4) All of the above

      5) None of  the above

13.       What is slide-title master pair?

      1) The title area and text area of a specific slide       

2) A slide master and title master merged into a single slide

3)  A slide master and title master for a specific design template

4) All of the above

5) None of the above

14.       Which of the following should you use if you want all the slides in the presentation to have the same ‘look’?

      1)  The slide layout option      2) Add a slide option

      3) Outline view                      4) A presentation design template

      5) None of the above

15.       In the context of animations, what is a trigger?

      1) An action button that advances to the next slide

      2) An item on the slide that performs an action  when clicked

      3) The name of a motion path

      4) All of the above

      5) None of the above

16.       To select oned hyperink after another during a slide presentation, what do                 you press?

      1) Tab          2) Ctrl + K       3) Ctrl + H     4) All of the above 

      5) None of the above

17.       Special effects used to introduce slides in a prsentation are called

      1) effects         2) custom animations    3) transitions 

      4)  present animations     5) None of the above

18.       You can edit an ecmbedded Organization chart object by

      1) clicling edit object  

      2) double clicking the Organization chart object

      3) right clicking the chart object, then cliking edit MS-Organization chart                 object

      4) Both ‘2’ and ‘3’                                                                                   

      5) None of the above

19.       Which of the following toolbars provide different options in various                  master views?

      1) Common tasks toolbar  2) Drawing toolbar   3) Formatting toolbar

      4) Standard toolbar           5) None of the above

20.       How can you create a uniform appearance  by adding a background image                 to all slides?

      1) Create a template    2) Edit the slide master     
            3) Use the atocorrect wizard  

      4) All of the above      5) None of the above

21.       How do you create speaker note pages that show the slides,  related notes and your company logo on each page?

      1) Edit the notes master and add your company logo

      2) Edit the slide master and insert your company logo and notes space

            3) Edit the handout master to include your company logo and one slide                  per page with additional note space

      4) All of the above

      5) None of these

  

22.       Which of the following tool enables you to add text to a slide without                       using the standard placeholders?

      1) Text tool box          2) Line tool         3) Drawing tool

      4) Auto shapes tool     5) None  of these

23.       In notes master view, how do  you modify the font size of text for all the                 notes of a presentation?

      1) Modify the slide design                 

2) Modify the notes master layout

      3) Modify the text within the body placeholder

      4) All of the above                             

5) None of the above

24.     Which of the following views is the best view to use when setting transition effects for all slides in presentation?

      1) Slide sorter view   2) Notes pages view     3) Slide view  

      4) Outline view             5) None of these

25.       Which command brings you to the first slide in your presentation?

      1) Next slide button   2) Page up   3) Ctrl + Home    
          4) Ctrl + End            5) None of these

26.       In normal view, how can you quickly chage to handout master view?

      1) Click the outline tab and select handout maser view

      2) Press the shift key and click the handout master view button

      3) On the view menu, click slide sorter and click hadouts

      4) All of the above

      5) Non of the above

27.       How can you quickly reinstate a deleted footer placeholder in master view?

      1) Create a new slide master          2) Re- apply the footer placeholder

      3) Re- apply the slide layout          4) All of the above

      5) None of the above

28.     Which of the following can you use to add times to the slides in a                               presentation?

      1) Slide show menu  

      2) Rehearse timings button  

      3) Slide transition button

      4) All of the above    

      5) None of the above

29.       To select all of the boxes of Organization chart

      1) clicking and edit and select all                  

2) right click the chart background and then click select all

3) press and hold the Shift key and click each box

4) All of the above

5) None of the above

30.       You can Show the shortcut menu during the slide show by

      1) clicking the shortcut button on the formatting toolbar

       2) right clicking the current slide

      3) clicking an icon on the current slide

      4) Both ‘1’ and ‘2’

        5) None of  the above

31.       Auto clipart is afeature that

      1) automatically places clipare in your presentation

     2) scans your presentation for incorrect spelling in your words on each slide

      3) scans your presentation for incorrect spelling in Word Arts objects

      4) All of the above 
           5) None of the above

32.       Which of the following allow you to select more than one slide in a                             presentation?

      1) Alt + Click each slide                                 2) Shift + Drag each slide

      3) Shift + Click each slide                              4) Ctrl + Click each slide

      5) None of the above

33.       Which bar is usually located below the title bar that provides categorized                options?

      1) Menu bar    2) Status bar    3) Tool bar       4) Scroll bar

      5) None of these

34.       Examples of centralized multi-user databases are

      1) airline reservations and other national global booking systems

      2) barclay’s bank customer accounts

      3) supermarket stock control, organ donor databse client database

           4) All of the above

           5) None of these 

35.       When a customer makes an online hotel booking, the database update in

            1) batch mode     2) pseudo real time        3) 2 days    

           4) All of these      5) None of these

36.       What is the name for math between the words or phrases being seached and the items found in an electronic database?

            1) Bug      2) Hit        3) It      4) Default    5) None of these

37.       A database that contains tabes linked by common fields is called a

            1) centralized database       2) flat file database        3) relational database

            4) All of these                   5) None of these

38.       DBMS is

            1) collection of data          2) set of programs to access those data

            3) set of programs to update those data

            4) All of the above           5) None of the above

39.       COPY STRUCTURE command is used to

            1) copy contents of an active database to a new file

            2) copy all records of an active database to disk

            3) copy contents of an active database to disk

            4) copy structure of an active database to a new file

            5) None of the above

40.       COUNT command is used to

            1) count the number of data fields in an active database file

            2) count the number of data files which are active

            3) count the records which are updeated

            4) count the number of records in an active database file

            5) None of the above

ANS KEY

Question No.	Answer	Question No.	Answer
1	1	21	3
2	2	22	1
3	4	23	3
4	4	24	1
5	4	25	3
6	4	26	2
7	4	27	2
8	4	28	2
9	4	29	4
10	1	30	2
11	1	31	4
12	3	32	3
13	3	33	1
14	4	34	1
15	2	35	2
16	1	36	2
17	3	37	3
18	4	38	4
19	1	39	4
20	2	40	4