MS Excel Pre-assesment

50 Questions | By Naldsauza | Updated: Mar 8, 2013 | Attempts: 292

Questions

Settings

Feedback

During the Quiz End of Quiz

Play as

Quiz Flashcard

Create your own Quiz

Enter all particular below and press "START" button. Please answer the questions honestly and to the best of your ability. If you have no idea what the answer is, choose the "not sure" answer. Please do not leave the answer blank or "wild guess" any of the questions. The purpose of this assessment is to obtain accurate information on your skill level, and provide personally tailored training based on your scores.
(Sila penuhkan butir-butir dibawah dan tekan butang "START". Sila jawab soalan dengan tulus dan berdasarkan pemahaman anda. Jika anda tidak pasti dengan jawapan, anda boleh memilih “Not Read moreSure”. Sila jangan tinggalkan sebarang soalan tanpa jawapan. Tujuan penilaian ini adalah bagi mendapatkan data yang tepat berdasarkan tahap skil anda dan menawarkan program yang bersesuaian)

Questions and Answers

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

Current Version
Mar 08, 2013

Quiz Edited by
ProProfs Editorial Team
Jan 20, 2013

Quiz Created by
Naldsauza

MS Excel Pre-assesment

A workbook is a _____ (Workbook ialah________)

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

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

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

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

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)

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

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)

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

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

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

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)

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

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

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

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

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

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

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

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

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

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 _______)

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

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

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

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

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)

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

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

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

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

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

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

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

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

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

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

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

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)

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

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

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

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)

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

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

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___________.)

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

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)

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

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

A workbook is a _ (Workbook ialah____)

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

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

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

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

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

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

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

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 ___)

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

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

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

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

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

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_______.)