latihan

MULTIMEDIA COLLEGE TMJALAN LUMBA KUDA

34672 TAIPNG

LATIHAN

KHAIRUL NOOR AZWA BINTI KAMARUDIN

(1 Hours )

NAMA : __________________________________________________________

NO MATRIK :_____________________________________________________

COURSE : ________________________________________________________

ITC2093 OFFICE AUTOMATION

SECTION A : MULTIPLE CHOICE (20 marks)

INSTRUCTIONS : Answer ALL questions

BAHAGIAN ‘GENERAL COMPUTER KNOWLEDGE’

1. ____ supports faster transfer rates when receiving data than when sending

data.

____ memberikan kadar penghantaran yang lebih pantas apabila menerima data

berbanding ketika menhantar data.

A. ADSL

B. ATM

C. ISDN

D. Dial-up

2. To prevent unauthorized users from accessing files and computers, many

routers are protected by a built-in____.

Untuk menghalang pengguna yang tidak dibenarkan daripada memasuki fail-fail

dan komputer-komputer, kebanyakan ‘routers’ adalah dilindungi oleh satu ‘built-

in’____.

A. Hub

B. Bridge

C. Hardware switch

D. Hardware firewall

3. A ____ serves as a sending and receiving device in a communications system.

Satu ___ bekerja sebagai alat menghantar dan menerima dalam satu system

komunikasi.

A. Desktop Computer

B. Tablet PC

C. Server

D. All of the above

KNA of 10


BAHAGIAN ‘MICROSOFT WORD’

4. What is a single-level list?

Apakah senarai ‘single-level’?

A. A list without sublists in any individual item.

B. A list with every bullet or number at the same indentation.

C. A list with only one item.

D. A list that uses just numbers, no bullets.

5. What should you type to automatically create a bulleted list that uses a black

dot as the bullet design?

Apakah yang anda perlu taip supaya dengan sendirinya menghasilkan satu ‘list

bulleted’ yang menggunakan satu dot hitam sebagai rekabentuk ‘bullet’?

A. 1. and a space

B. @ and a space

C. a. and a space

D. * and a space

BAHAGIAN ‘MICROSOFT EXCEL’

6. How do you create a new workbook?

Bagaimanakah anda menghasilkan satu ‘workbook’ baru?

A. On the Insert menu, click Worksheet.

B. On the File menu, click New. In the New Workbook task pane, click

Blank workbook.

C. On the Insert menu, click Workbook.

D. Type simultaneously CTRL + 0.

KNA of 10


7. What do you type to start a formula in Excel?

Apakah yang anda taip bagi memulakan satu formula di dalam Excel

A. A function.

B. Mathematical operators.

C. An equal sign (=).

D. Evaluate formula button.

BAHAGIAN ‘MICROSOFT POWER POINT’

8. In the PowerPoint window, what's the main area for adding slide content?

Dalam tetingkap Power Point, apakah kawasan utama untuk penambahan bahan

‘slide’?

A. The slides tab, located on the left of the window.

B. The notes pane.

C. The slide pane, located in the middle of the window.

D. The outline preview.

KNA of 10


9. The design template determines the look and colors of the slides, including:

Rekabentuk ‘template’ menentukan rupa persembahan dan warna bagi ‘slide’

termasuk:

A. The slide background.

B. Bullet and font styles.

C. Varied design accents.

D. All of the above.

BAHAGIAN ‘MICROSOFT ACCESS’

10. What is the purpose of the Primary Key?

Apakah tujuan sesuatu Primary Key?

A. A unique identifier that can be used to relate tables.

B. The key that precedes the secondary key.

C. The password that validates a database.

D. It is a collection of data about a person.

SECTION B : MATCHING QUESTIONS (10 Marks)

KNA of 10


INSTRUCTION : Answer ALL questions in the space given.

Match the correct term to each of the following definitions

Padankan terminologi yang betul bagi setiap definasi berikut :

Boot BIOS Disk Cache Security Log on

Desktop Operating System

Hierarchical file

Browser USB

(10 markah/marks)

Definition / Definasi Answer / Jawapan

1. An interactive program (client) that requests, retrieves and displays

pages from the world wide web.

Satu interaktfi program (klien) yang meminta, mendapatkan dan memaparkan laman daripada ‘world wide web’.

2. To load the operating system into a computer after it has been

switched on; usually applied to small computers.

Untuk membuka sistem operasi ke dalam satu komputer selepas ia di

petik buka biasanya dilaksanakan kepada komputer kecil.

3. Basic input/output system.

Asas masukan/keluaran sistem.

4. In a graphical user interface, a screen on which frequently used

software resources are represented by icons.

Bagi satu antaramuka pengguna grafik, satu skrin yang lazimnya

mengunakan sumber perisian yang diwakili oleh ikon-ikon.

5. The procedure for users to identify themselves to a computer system

KNA of 10


for authorized access to their programs and information.

Prosedure untuk pengguna mengenalpasti identiti mereka kepada

satu sistem komputer untuk laluan yang dibenarkan kepada maklumat

dan program-program meraka.

6. A portion of random-access memory that contains the data most

recently read from or written to the disk, allowing rapid access

by the central-processing unit.

Satu bahagian bagi ‘random-access memory’ yang mengandungi

data yang paling terkini dibaca daripada atau ditulis kepada cakera,

membenarkan laluan kerap oleh unit pemprosesan pusat.

7. A set of programs and routines which guides a computer or

network in the performance of its task, assists the programs with

certain supporting functions and increase the usefulness of the

computer or network hardware.

Satu set rutin dan program dimana memberi panduan kepada satu

rangkaian atau komputer dalam melaksanakan tugasnya, membantu

program-program dengan fungsi sokongan tertentu dan

meningkatkan kebergunaan bagi perkakasan rangkaian atau

komputer.

8. Universal Serial Bus

‘Universal Serial Bus’

9. A file with a grandfather-father-son structure.

Satu fail dengan satu struktur susunan datuk-ayah-anak.

KNA of 10


10. The existence of techniques which restrict access to data and the

conditions under which data may be obtained.

Teknik yang wujud dimana menghadkan laluan dan di bawah

keadaan di mana data boleh diperolehi.

MICROSOFT EXCEL 2003SECTION C : SHORT ANSWER (50 Marks)

INSTRUCTION : Answer ALL questions in the space given.

1.

(10 marks / markah)

1. Which format / icon is used to bold the headings ‘ENGLISH?

Format / ikon apakah yang digunakan untuk menebalkan tajuk

‘ENGLISH’?

2. =COUNTIF(F4:F11;"A")

KNA of 10


What does the above formula indicate?

Apakah yang dinyatakan oleh formula di atas?

MICROSOFT ACCESS 2003

(a). What is the appropriate name for the above tables?

Apakah nama yang sesuai untuk jadual-jadual di atas?(2 markah/marks)

(b). What is the purpose to keep a data in such a database?

Apakah tujuan bagi menyimpan data di dalam database seperti di atas?

(2 markah/marks)

(c). Which is the suitable primary key for Table?

Yang manakah kunci utama yang sesuai bagi Table?

(2 markah/marks)

KNA of 10


(d). Based on the figure above, what is the relationship types between these table?

Berdasarkan rajah di atas, apakah jenis hubungan di antara jadual tersebut?

(e). The figure shows CustomerDataEntry windows. What kind of object it is?

Rajah menunjukkan tetingkap ‘CustomerDataEntry’. Apakah jenis objek

tersebut?

(4 markah/marks)

KNA of 10

latihan

Technology