1.
Data can be imported from Notepad, Database and Webpage
(Data boleh diimport dari Notepad, Database dan Laman Web )
Correct Answer
A. True
Explanation
Data can be imported from various sources such as Notepad, Database, and Webpage. This means that information can be extracted and transferred from these sources into a different system or application for further analysis or use. Therefore, the statement "Data can be imported from Notepad, Database, and Webpage" is true.
2.
​Delimited is one of Lookup Formula
(Delimited merupakan salah satu formula di dalam Lookup)
Correct Answer
B. False
Explanation
The given statement is false. Delimited is not a formula in Lookup. It is a term used to describe a method of separating or dividing data using a specific character or symbol. In the context of lookup formulas, delimited may refer to using a delimiter (such as a comma or semicolon) to separate multiple values within a single cell or string. However, it is not a standalone formula in the Lookup category.
3.
Data layout can be change by using Paste Link option
(Susun atur data boleh ditukar dengan cara Paste Link)
Correct Answer
B. False
Explanation
The statement is false because the Paste Link option does not allow for changing the data layout. The Paste Link option is used to create a link between the source data and the destination, so any changes made to the source data will be reflected in the destination. However, it does not provide the capability to change the layout of the data itself.
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)
Correct Answer
A. True
Explanation
Conditional Formatting is indeed a formatting technique that applies a specified format to a cell or range based upon a set of criteria. It allows users to highlight or emphasize certain cells or ranges based on specific conditions or rules. This feature is commonly used in spreadsheets or data analysis tools to visually identify patterns, outliers, or trends in the data.
5.
By applying Range Name for list data could ease run any Function
(Dengan mengaplikasikan Range Name bagi senarai data memudahkan penggunaan pelbagai fungsi )
Correct Answer
A. True
Explanation
Applying range names to a list of data allows users to easily use various functions. Range names provide a way to refer to a specific range of cells in a worksheet by using a descriptive name instead of cell references. This makes it easier to understand and remember which cells are being referenced in formulas or functions. By using range names, users can quickly apply functions to specific ranges of data without having to manually select the cells each time. Therefore, the given statement that applying range names for list data eases the use of various functions is true.
6.
What is Data Validation?
(Apa itu Data Validation?)
Correct Answer
A. Control data entered by user
Explanation
Data validation refers to the process of ensuring that the data entered by a user is accurate, complete, and meets certain criteria or standards. It involves implementing checks and rules to validate the data before it is accepted and stored in a database or system. This helps to maintain data integrity and reliability, preventing errors and inconsistencies. By controlling the data entered by the user, organizations can ensure the quality and validity of their data, leading to better decision-making and more efficient operations.
7.
Protect Sheet and Protect Workbook option can be found in View Ribbon
(Pilihan Protect Sheet dan Protect Workbook boleh didapati di ribbon View)
Correct Answer
B. False
Explanation
The correct answer is False. The Protect Sheet and Protect Workbook options cannot be found in the View Ribbon. These options are actually located in the Review Ribbon.
8.
By default cells in Microsoft Excel is unlocked.
(Secara asasnya, sel di dalam Microsoft Excel tidak dikunci)
Correct Answer
B. False
Explanation
By default, cells in Microsoft Excel are actually locked. This means that when you protect a worksheet, all the cells are locked by default and cannot be edited. To allow editing of specific cells, you need to unlock them manually. Therefore, the correct answer is False.
9.
IF function is to test certain conditions is TRUE or FALSE
(Fungsi IF merupakan fungsi logikal samada ia BENAR atau TIDAK BENAR)
Correct Answer
A. True
Explanation
The given correct answer is "True" because the IF function is indeed used to test certain conditions and determine whether they are true or false. It allows for conditional execution of different actions based on the outcome of the test.
10.
VLOOKUP is one of function in Database Function
(VLOOKUP merupakan salah satu fungsi di dalam kategori DATABASE)
Correct Answer
B. False
Explanation
The given statement is false. VLOOKUP is not a function in the Database category. VLOOKUP is actually a function in the Lookup & Reference category in Excel. It is used to search for a value in the first column of a table array and retrieve a corresponding value from a specified column in the same row.
11.
There are three types of LOOKUP functions, LOOKUP, VLOOKUP and CLOOKUP
(Terdapat tiga jenis fungsi didalam LOOKUP, LOOKUP, VLOOKUP dan CLOOKUP)
Correct Answer
B. False
Explanation
The statement is false because there are only two types of LOOKUP functions, which are VLOOKUP and HLOOKUP. CLOOKUP is not a valid function.
12.
XFD 1,048,576 is the limitation of Excel 2007 and 2010.
(Pengakhiran Worksheet Excel 2007 dan 2010 adalah XFD 1,048,576)
Correct Answer
A. True
Explanation
The statement is true because in Excel 2007 and 2010, the maximum number of rows in a worksheet is 1,048,576 and the maximum number of columns is XFD, which is the 16384th column. Therefore, XFD 1,048,576 is indeed the limitation of Excel 2007 and 2010.
13.
You can use Tracer Arrows or Watch Windows to create formula.
(Anda boleh menggunakan Tracer Arrow atau Watch Windows untuk mencipta formula)
Correct Answer
B. False
Explanation
The correct answer is "False" because the question asks for a statement that is not true.
14.
You can create a chart as simple as press F12 key button
(Anda boleh mencipta graf dengan semudah menekan kekunci F12)
Correct Answer
B. False
Explanation
The statement suggests that creating a chart is as simple as pressing the F12 key button. However, this is not true as creating a chart requires more than just pressing a single key. It involves selecting data, choosing a chart type, formatting the chart, and customizing it according to the desired output. Therefore, the answer is false.
15.
What is the answer for this formula?
(Apakah jawapan bagi formula berikut)
=if(A1>B1,"Good","Not Good") ---> A1=90 , B1=90
Correct Answer
B. Not Good
Explanation
The formula is using the "if" function to compare the value in cell A1 with the value in cell B1. If the value in A1 is greater than the value in B1, it will display "Good", otherwise it will display "Not Good". In this case, since A1=90 and B1=90, the condition is not met and the formula will display "Not Good".