Excel Advance 1 Pre Test
15 Questions
| Total Attempts: 498
Select either True, False or I Don't Know
Questions and Answers
- 1.Data can be imported from Notepad, Database and Webpage (Data boleh diimport dari Notepad, Database dan Laman Web )
- A.
True
- B.
False
- C.
I Dont Know
- 2.​Delimited is one of Lookup Formula (Delimited merupakan salah satu formula di dalam Lookup)
- A.
True
- B.
False
- C.
I Dont Know
- 3.Data layout can be change by using Paste Link option (Susun atur data boleh ditukar dengan cara Paste Link)
- A.
True
- B.
False
- C.
I Dont Know
- 4.Conditional Formatting is a formatting technique that applies a specified format to a cell or range based upon a set of creteria (Conditional Formatting adalah teknik mengformat sel atau range berdasarkan set kriteria tertentu)
- A.
True
- B.
False
- C.
I Dont Know
- 5.By applying Range Name for list data could ease run any Function (Dengan mengaplikasikan Range Name bagi senarai data memudahkan penggunaan pelbagai fungsi )
- A.
True
- B.
False
- C.
I Dont Know
- 6.What is Data Validation? (Apa itu Data Validation?)
- A.
Control data entered by user
- B.
Import data from system
- C.
I Dont Know
- 7.Protect Sheet and Protect Workbook option can be found in View Ribbon (Pilihan Protect Sheet dan Protect Workbook boleh didapati di ribbon View)
- A.
True
- B.
False
- C.
I Dont Know
- 8.By default cells in Microsoft Excel is unlocked. (Secara asasnya, sel di dalam Microsoft Excel tidak dikunci)
- A.
True
- B.
False
- C.
I Dont Know
- 9.IF function is to test certain conditions is TRUE or FALSE (Fungsi IF merupakan fungsi logikal samada ia BENAR atau TIDAK BENAR)
- A.
True
- B.
False
- C.
I Dont Know
- 10.VLOOKUP is one of function in Database Function (VLOOKUP merupakan salah satu fungsi di dalam kategori DATABASE)
- A.
True
- B.
False
- C.
I Dont Know
- 11.There are three types of LOOKUP functions, LOOKUP, VLOOKUP and CLOOKUP (Terdapat tiga jenis fungsi didalam LOOKUP, LOOKUP, VLOOKUP dan CLOOKUP)
- A.
True
- B.
False
- C.
I Dont Know
- 12.XFD 1,048,576 is the limitation of Excel 2007 and 2010. (Pengakhiran Worksheet Excel 2007 dan 2010 adalah XFD 1,048,576)
- A.
True
- B.
False
- C.
I Dont Know
- 13.You can use Tracer Arrows or Watch Windows to create formula. (Anda boleh menggunakan Tracer Arrow atau Watch Windows untuk mencipta formula)
- A.
True
- B.
False
- C.
I Dont Know
- 14.You can create a chart as simple as press F12 key button (Anda boleh mencipta graf dengan semudah menekan kekunci F12)
- A.
True
- B.
False
- C.
I Dont Know
- 15.What is the answer for this formula? (Apakah jawapan bagi formula berikut) =if(A1>B1,"Good","Not Good") ---> A1=90 , B1=90
- A.
Good
- B.
Not Good
- C.
I Dont Know
Microsoft Excel has given a lot of people sleepless nights trying to figure it out, and some give up on it ultimately. Do you want to test your basic knowledge on an excel sheet? Play this excel practice quiz and prove yourself....
Questions: 10 | Attempts: 71039 | Last updated: Mar 22, 2022
-
Sample QuestionLabels are aligned at the ________ edge of the cell.
Microsoft excel quiz: test on functions! Microsoft Excel is considered to be one of the most diverse Microsoft office tools as it not only allows calculations but can also allow processing of different sets of data. Are you...
Questions: 10 | Attempts: 62254 | Last updated: Mar 22, 2022
-
Sample QuestionAn Excel Workbook is a collection of …….
Do you want to become familiar with Microsoft Excel? Do you think you can pass this quiz? Microsoft Excel helps to organize information in an easy to navigate way. It does complicated math problems so that you don’t have...
Questions: 10 | Attempts: 45747 | Last updated: Mar 22, 2022
-
Sample QuestionWhich language is used to create macros in Excel?
Back to top