Ms Excel Pre-Assesment

1. To begin a formula, start with (Untuk memulakan formula, perlu dimulakan dengan_)

-

=

*

I am not sure

2. Part of the worksheet can be protected from being edited. (Sebahagian daripada worksheet boleh dikunci daripada sebarang penambahan)

True

False

I am not sure

3. You can adjust print area with manual page breaks. (Anda boleh mengubah kawasan cetakan dengan cara Page Break secara manual)

True

False

I am not sure

4. You can sort on more than one column at a time. (Anda boleh menyusun data lebih dari satu lajur pada satu-satu masa)

True

False

I am not sure

5. Chart can be placed either in the same sheet as the data or in a separate sheet. (Carta boleh diletakkan di dalam sheet yang sama atau dalam sheet yang berbeza dengan data)

True

False

I am not sure

6. To insert a row/column, right-click on the row number/column letter and select Insert (Untuk memasukkan baris/lajur, right-click pada nombor/huruf baris/lajur dan pilih Insert)

True

False

I Am not sure

7. By default, you can enter any type of data into Excel. (Secara amnya, anda boleh memasukkan sebarang data kedalam Excel)

True

False

I am not sure

8. Text can be rotated as shown in Fig 4. (Teks boleh dipusingkan seperti gambarajah di Fig 4 .

True

False

I am not sure

9. In an Excel formula, use _ to multiply and _ to divide (Dalam formula Excel, simbol _ untuk darab dan _____ untuk bahagi

* , \

* , /

X , /

I am not sure

10. When you press ENTER, cursor _ (Apabila anda menekan ENTER, cursor_)

Doesn't move

Moves right

Move down

I am not sure

11. To total a range of numbers, use _ function. (Untuk menambah senarai nombor, gunakan fungsi ________)

SUM

SUBTOTAL

TOTAL

I am not sure

12. You can format more than one sheet at the same time. (Anda boleh menformat lebih dari satu sheet pada satu-satu masa)

True

False

I am not sure

13. Clicking on the drop-down arrow will _ (Klik pada anak panah tersebut, ia akan ______)

Edit Formula

List more functions

Erase formula

I am not sure

14. Once a Pivot Table is created, it can be copied and edited. (Apabila PivotTable dicipta, ia boleh disalin dan di edit).

True

False

I am not sure

15. You CANNOT UNDO once a sheet is deleted. (Anda tidak boleh menekan UNDO apabila satu sheet telah dihapuskan)

True

False

I Am Not Sure

16. By default, each time you start a new file/book, you have ...... sheets. (Secara amnya, bagi setiap workbook yang baru, anda akan mempunyai ...... sheets)

1

2

3

I am not sure

17. A workbook is a _ (Workbook ialah____)

Collection of cells

Collection of files

Collection of sheets

I am not sure

18. Merge & Center command CANNOT be undone (Merge & Center tidak boleh dipecahkan cell yang telah bercantum)

True

False

I Am Not Sure

19. An intersection between row and column is..... (Pertembungan antara baris dan lajur dipanggil ....)

Range

Cell

Table

I am not sure

20. To select non-continuous cell(s), press while highlighting. (Untuk memilih sel-sel pilihan, tekan ______ semasa memilih)

ALT

Shift

CTRL

I am not sure

21. To rename a sheet,.................. (Untuk menamakan sheet,..............)

Insert--> Name

Double click

Just clik and type

I am not sure

22. To calculate number of cells in a range that match a certain condition, use (Untuk mengira jumlah cell bernombor yang memenuhi kriteria tertentu, gunakan)

If

Countif

Whatif

I am not sure

23. IF function can be nested with another IF function. (Fungsi IF boleh digelungkan dengan fungsi IF yang lain)

True

False

I am not sure

24. Excel doesn't recognize the following date format when calculated in a formula. (Excel tidak mengenal format tarikh berikut, semasa mengira dalam formula)

1-Jan-2011

01.01.2011

01/01/2011

I am not sure

25. In a formula, Range names works as the same as absolute reference (Di dalam formula,Range Names berfungsi sama seperti Absolute Reference)

True

False

I Am Not sure

26. In an Employee database, which of the following CANNOT be done with AutoFilter (Dalam pangkalan data Employee, yang manakah TIDAK boleh dibuat dengan AutoFilter)

List all Admin or Sales employees that are Male

List all Female employees between age 40 to 50

List Male employees from Admin and Female employees from Sales

I am not sure

27. To edit a cell entry, the only way is to double-click on it. (Untuk mengedit data yang telah dimasukkan, hanya satu cara sahaja iaitu dengan double click)

True

False

I Am Not Sure

28. When the data (Fig 3) is filled to the next 3 cells, it appears as _____ (Jika data (Rujuk Rajah 3) di tarik 3 cell kebawah, ia akan memaparkan)

105,105,105

105,106,107

ERROR#!

I Am Not Sure

29. One of the following is NOT a logical function (Salah satu dari dibawah BUKAN fungsi logikal)

IF

AND

VLOOKUP

I am not sure

30. Using keyboard, you can go to next worksheet by pressing _ (Dengan menekan kekunci__, anda boleh pergi ke sheet yang berikutnya)

CTRL + G

CTRL + PG DOWN

CTRL + N

I am not sure

31. To calculate the highest value in a range ___ (Untuk mengira nombor tertinggi dalam senarai adalah)

TOP

HIGH

MAX

I am not sure

32. The only way to create a chart is to use the Chart Wizard. (Hanya satu cara dalam membangunkan carta iaitu: Chart Wizard)

True

False

I am not sure

33. A formula that is linked to cell A5 in Sheet 2 is (Formula yang dihubungkan to sel A5 dalam sheet 2 ialah____)

=sheet2+A5

=sheet2!A5

=sheet2&a5

I am not sure

34. Cells change colour according to a set of criteria. What method is used? (Sel bertukar warna mengikut kteritea tertentu. Apakah proses yang digunakan?)

Table Format

Styles

Conditional Formatting

I am not sure

35. Cell comments CANNOT be printed out. (Komen bagi cell TIDAK boleh dicetak)

True

False

I am not sure

36. To have date updated automatically, the function used is _ (Fungsi digunakan bagi mendapatkan tarikh terkini secara automatic)

=CURRENT

=TODAY

=DATE

I am not sure

37. Which of the following statements about Consolidate is NOT true? (Penyataan yang manakah menerangkan Consolidate yang SALAH?)

Enables you to summarize data according to column/row labels

The size and layout of data in all range must be different

The data source can be from either the same or different workbook.

I am not sure

38. Macro is ......... (Macro adalah..............)

A set of rules formulas

Set of recorded tasks

A set of criteria

I am not sure

39. You CANNOT perform filter when one of the column that does not have a heading. (Anda TIDAK boleh membuat tapisan (filter) apabila lajur tidak mempunyai sebarang tajuk)

True

False

I am not sure

40. You can hide rows/columns but NOT entire worksheet. (Anda boleh menyembunyikan baris/lajur, tetapi tidak seluruh worksheet)

True

False

I am not sure

41. When mouse pointer appears as shown in Fig 1, you can (Jika mouse pointer bertukar seperti gambar 1, ia digunakan sebagai)

Move cells

Copy cells

Highlight/select cells

I am not sure

42. To create a drop-down list with values such as Mr, Mrs, Dr, Prof, use _. (Untuk mencipta senarai drop-down seperti Mr, Mrs, Dr, Prof, gunakan_______.)

LIST function

Data Validation

Table

I am not sure

43. If you forget the File Open password, you can retry 3 times. (Jika anda terlupa kata kunci bagi File Open, anda diberi cubaan sebanyak 3 kali)

True

False

I am not sure

44. Which statement regarding formatting is true? (Penyataan yang manakah yang benar?)

You can only change the font type and size for text data

Cells with accounting format, CANNOT be aligned left

Strikethrough (Strikethrough) format is not available in Excel

I am not sure

45. When the formula =A1+B1 is copied to the next row, it changes to _ (Apabila formula =A1+B1 di salin ke baris yang seterusnya, ia akan bertukar kepada ___)

=A2+B2

=a1+B2

No changes in the formula

I am not sure

46. In order to perform VLOOKUP, the reference table must be in the same file. (Dalam membuat VLOOKUP, jadual rujukan mesti berada dalam fail yang sama)

True

False

I am not sure

47. There are _ type of absolute references. (Terdapat _______ jenis bagi absolute references)

1

2

3

I am not sure

48. The following is NOT true about range names (Berikut merupakan penyataan yang TIDAK benar tentang Range Names)

Range names CANNOT start with a number

S01 is a valid range name

Total_2000 is a valid range name

I am not sure

49. To calculate the 2ND highest value in a range _ (Untuk mengira nomor kedua tertinggi dalam senarai adalah____)

TOP

LARGE

HIGH2

I am not sure

50. You must always highlight the range before sorting. (Anda mesti memilih seluruh senarai sebelum menyusun data)

True

False

I am not sure

MS Excel Pre-assesment

1. To begin a formula, start with ____ (Untuk memulakan formula, perlu dimulakan dengan_____)

2.

What first name or nickname would you like us to use?

2. Part of the worksheet can be protected from being edited. (Sebahagian daripada worksheet boleh dikunci daripada sebarang penambahan)

3. You can adjust print area with manual page breaks. (Anda boleh mengubah kawasan cetakan dengan cara Page Break secara manual)

4. You can sort on more than one column at a time. (Anda boleh menyusun data lebih dari satu lajur pada satu-satu masa)

5. Chart can be placed either in the same sheet as the data or in a separate sheet. (Carta boleh diletakkan di dalam sheet yang sama atau dalam sheet yang berbeza dengan data)

6. To insert a row/column, right-click on the row number/column letter and select Insert (Untuk memasukkan baris/lajur, right-click pada nombor/huruf baris/lajur dan pilih Insert)

7. By default, you can enter any type of data into Excel. (Secara amnya, anda boleh memasukkan sebarang data kedalam Excel)

8. Text can be rotated as shown in Fig 4. (Teks boleh dipusingkan seperti gambarajah di Fig 4 .

9. In an Excel formula, use ___ to multiply and ___ to divide (Dalam formula Excel, simbol _______ untuk darab dan ___________ untuk bahagi

10. When you press ENTER, cursor _________ (Apabila anda menekan ENTER, cursor_________)

11. To total a range of numbers, use _____ function. (Untuk menambah senarai nombor, gunakan fungsi ____________)

12. You can format more than one sheet at the same time. (Anda boleh menformat lebih dari satu sheet pada satu-satu masa)

13. Clicking on the drop-down arrow will _____ (Klik pada anak panah tersebut, ia akan __________)

14. Once a Pivot Table is created, it can be copied and edited. (Apabila PivotTable dicipta, ia boleh disalin dan di edit).

15. You CANNOT UNDO once a sheet is deleted. (Anda tidak boleh menekan UNDO apabila satu sheet telah dihapuskan)

16. By default, each time you start a new file/book, you have ...... sheets. (Secara amnya, bagi setiap workbook yang baru, anda akan mempunyai ...... sheets)

17. A workbook is a _____ (Workbook ialah________)

18. Merge & Center command CANNOT be undone (Merge & Center tidak boleh dipecahkan cell yang telah bercantum)

19. An intersection between row and column is..... (Pertembungan antara baris dan lajur dipanggil ....)

20. To select non-continuous cell(s), press ______ while highlighting. (Untuk memilih sel-sel pilihan, tekan ____________ semasa memilih)

21. To rename a sheet,.................. (Untuk menamakan sheet,..............)

22. To calculate number of cells in a range that match a certain condition, use (Untuk mengira jumlah cell bernombor yang memenuhi kriteria tertentu, gunakan)

23. IF function can be nested with another IF function. (Fungsi IF boleh digelungkan dengan fungsi IF yang lain)

24. Excel doesn't recognize the following date format when calculated in a formula. (Excel tidak mengenal format tarikh berikut, semasa mengira dalam formula)

25. In a formula, Range names works as the same as absolute reference (Di dalam formula,Range Names berfungsi sama seperti Absolute Reference)

26. In an Employee database, which of the following CANNOT be done with AutoFilter (Dalam pangkalan data Employee, yang manakah TIDAK boleh dibuat dengan AutoFilter)

27. To edit a cell entry, the only way is to double-click on it. (Untuk mengedit data yang telah dimasukkan, hanya satu cara sahaja iaitu dengan double click)

28. When the data (Fig 3) is filled to the next 3 cells, it appears as _____ (Jika data (Rujuk Rajah 3) di tarik 3 cell kebawah, ia akan memaparkan)

29. One of the following is NOT a logical function (Salah satu dari dibawah BUKAN fungsi logikal)

30. Using keyboard, you can go to next worksheet by pressing _____ (Dengan menekan kekunci______, anda boleh pergi ke sheet yang berikutnya)

31. To calculate the highest value in a range _____ (Untuk mengira nombor tertinggi dalam senarai adalah__)

32. The only way to create a chart is to use the Chart Wizard. (Hanya satu cara dalam membangunkan carta iaitu: Chart Wizard)

33. A formula that is linked to cell A5 in Sheet 2 is ________ (Formula yang dihubungkan to sel A5 dalam sheet 2 ialah____________)

34. Cells change colour according to a set of criteria. What method is used? (Sel bertukar warna mengikut kteritea tertentu. Apakah proses yang digunakan?)

35. Cell comments CANNOT be printed out. (Komen bagi cell TIDAK boleh dicetak)

36. To have date updated automatically, the function used is _____ (Fungsi ____ digunakan bagi mendapatkan tarikh terkini secara automatic)

37. Which of the following statements about Consolidate is NOT true? (Penyataan yang manakah menerangkan Consolidate yang SALAH?)

38. Macro is ......... (Macro adalah..............)

39. You CANNOT perform filter when one of the column that does not have a heading. (Anda TIDAK boleh membuat tapisan (filter) apabila lajur tidak mempunyai sebarang tajuk)

40. You can hide rows/columns but NOT entire worksheet. (Anda boleh menyembunyikan baris/lajur, tetapi tidak seluruh worksheet)

41. When mouse pointer appears as shown in Fig 1, you can (Jika mouse pointer bertukar seperti gambar 1, ia digunakan sebagai)

42. To create a drop-down list with values such as Mr, Mrs, Dr, Prof, use _____. (Untuk mencipta senarai drop-down seperti Mr, Mrs, Dr, Prof, gunakan___________.)

43. If you forget the File Open password, you can retry 3 times. (Jika anda terlupa kata kunci bagi File Open, anda diberi cubaan sebanyak 3 kali)

44. Which statement regarding formatting is true? (Penyataan yang manakah yang benar?)

45. When the formula =A1+B1 is copied to the next row, it changes to _____ (Apabila formula =A1+B1 di salin ke baris yang seterusnya, ia akan bertukar kepada _______)

46. In order to perform VLOOKUP, the reference table must be in the same file. (Dalam membuat VLOOKUP, jadual rujukan mesti berada dalam fail yang sama)

47. There are _____ type of absolute references. (Terdapat ___________ jenis bagi absolute references)

48. The following is NOT true about range names (Berikut merupakan penyataan yang TIDAK benar tentang Range Names)

49. To calculate the 2ND highest value in a range _____ (Untuk mengira nomor kedua tertinggi dalam senarai adalah________)

50. You must always highlight the range before sorting. (Anda mesti memilih seluruh senarai sebelum menyusun data)

1. To begin a formula, start with (Untuk memulakan formula, perlu dimulakan dengan_)

9. In an Excel formula, use _ to multiply and _ to divide (Dalam formula Excel, simbol _ untuk darab dan _____ untuk bahagi

10. When you press ENTER, cursor _ (Apabila anda menekan ENTER, cursor_)

11. To total a range of numbers, use _ function. (Untuk menambah senarai nombor, gunakan fungsi ________)

13. Clicking on the drop-down arrow will _ (Klik pada anak panah tersebut, ia akan ______)

17. A workbook is a _ (Workbook ialah____)

20. To select non-continuous cell(s), press while highlighting. (Untuk memilih sel-sel pilihan, tekan ______ semasa memilih)

30. Using keyboard, you can go to next worksheet by pressing _ (Dengan menekan kekunci__, anda boleh pergi ke sheet yang berikutnya)

31. To calculate the highest value in a range ___ (Untuk mengira nombor tertinggi dalam senarai adalah)

33. A formula that is linked to cell A5 in Sheet 2 is (Formula yang dihubungkan to sel A5 dalam sheet 2 ialah____)

36. To have date updated automatically, the function used is _ (Fungsi digunakan bagi mendapatkan tarikh terkini secara automatic)

42. To create a drop-down list with values such as Mr, Mrs, Dr, Prof, use _. (Untuk mencipta senarai drop-down seperti Mr, Mrs, Dr, Prof, gunakan_______.)

45. When the formula =A1+B1 is copied to the next row, it changes to _ (Apabila formula =A1+B1 di salin ke baris yang seterusnya, ia akan bertukar kepada ___)

47. There are _ type of absolute references. (Terdapat _______ jenis bagi absolute references)

49. To calculate the 2ND highest value in a range _ (Untuk mengira nomor kedua tertinggi dalam senarai adalah____)