Excel Advance 1 Post Test
Select either True, False or I Don't Know
Questions and Answers
- 1.
Data can be imported from (Data boleh diimport dari )
- A.
Notepad, Database and Webpage
- B.
Notepad, GIF and TIFF
Correct Answer
A. Notepad, Database and WebpageExplanation
Data can be imported from Notepad, Database, and Webpage. This means that information or data can be transferred or brought into a system or software from these three sources. Notepad is a simple text editor where data can be stored and accessed. A database is a structured collection of data that can be organized, managed, and accessed easily. A webpage can contain various forms of data, such as text, images, videos, etc., which can be extracted and imported into a system.Rate this question:
-
- 2.
​Delimited is one of Lookup Formula (Delimited merupakan salah satu formula di dalam Lookup)
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
The statement is false because "Delimited" is not a formula in the Lookup function. Therefore, the correct answer is false.Rate this question:
-
- 3.
Data layout can be change by using Paste Link option (Susun atur data boleh ditukar dengan cara Paste Link)
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
The statement is false because the data layout cannot be changed by using the Paste Link option. The Paste Link option is used to create a link between two cells or ranges in a spreadsheet, so that the linked cell or range automatically updates when the source cell or range changes. It does not have the capability to change the layout or arrangement of the data.Rate this question:
-
- 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
Correct Answer
A. TrueExplanation
Conditional Formatting is a feature in spreadsheet software that allows users to apply formatting to cells or ranges based on specific criteria. This allows for the automatic highlighting or formatting of cells that meet certain conditions, making it easier to identify and analyze data. By using conditional formatting, users can quickly identify trends, outliers, or specific values in their data without manually sorting or filtering. Therefore, the given answer, "True," is correct as it accurately states that conditional formatting is a technique that applies a specified format to a cell or range based on a set of criteria.Rate this question:
-
- 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
Correct Answer
A. TrueExplanation
Applying range names to a list of data makes it easier to use various functions. By assigning a range name to a specific set of data, users can refer to that range name instead of manually selecting the data each time they want to use a function. This simplifies the process and reduces the chances of errors.Rate this question:
-
- 6.
What is Data Validation? (Apa itu Data Validation?)
- A.
Control data entered by user
- B.
Import data from system
Correct Answer
A. Control data entered by userExplanation
Data validation refers to the process of controlling and verifying the data entered by a user. It ensures that the data meets certain criteria, such as format, range, or type, before it is accepted and stored in a system or database. This helps to maintain data accuracy, integrity, and reliability by preventing the entry of incorrect or invalid data. Importing data from a system, on the other hand, is a separate process and not directly related to data validation.Rate this question:
-
- 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
Correct Answer
B. FalseExplanation
The statement is false because the Protect Sheet and Protect Workbook options can be found in the Review Ribbon, not the View Ribbon.Rate this question:
-
- 8.
By default cells in Microsoft Excel is unlocked. (Secara asasnya, sel di dalam Microsoft Excel tidak dikunci)
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
The given answer is false because by default, cells in Microsoft Excel are actually locked, not unlocked. This means that when you protect a worksheet, all cells are locked and cannot be edited unless you specifically unlock them.Rate this question:
-
- 9.
Limitation of Column and Row for Excel 2007, 2010 and 2013?
- A.
XFD, 1,048,576
- B.
IV, 65,536
Correct Answer
A. XFD, 1,048,576Explanation
The given answer, XFD, 1,048,576, represents the limitation of the maximum number of columns and rows in Excel 2007, 2010, and 2013. In these versions, the maximum number of columns is 16,384 (XFD), and the maximum number of rows is 1,048,576. This means that users cannot exceed these limits when working with data in Excel sheets.Rate this question:
-
- 10.
VLOOKUP is one of function in Database Function (VLOOKUP merupakan salah satu fungsi di dalam kategori DATABASE)
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
The given statement is false because VLOOKUP is not a function in the Database category. VLOOKUP is actually a function in the Lookup & Reference category. The Database category includes functions like DGET, DMAX, DMIN, etc.Rate this question:
-
- 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
Correct Answer
B. FalseExplanation
The statement is false because there are only two types of LOOKUP functions, not three. The correct types of LOOKUP functions are VLOOKUP and HLOOKUP. CLOOKUP is not a valid LOOKUP function.Rate this question:
-
- 12.
Examples of Conditional Formatting (Contoh-contoh Conditional Formatting )
- A.
Data Bar, Colour Scale and Highlight Cell Rules
- B.
Colour Scale, Data Bar and Fill Colour
- C.
Font Colour, Cell Colour and Range Name Colour
Correct Answer
A. Data Bar, Colour Scale and Highlight Cell RulesExplanation
This answer lists examples of conditional formatting techniques, namely Data Bar, Colour Scale, and Highlight Cell Rules. These techniques are used to visually highlight and analyze data based on certain conditions. Data Bar creates a horizontal bar within a cell to represent the value, Colour Scale applies a gradient color scale to the cells based on the values, and Highlight Cell Rules applies different formatting styles to cells based on specified rules. These techniques help to easily identify patterns, trends, and variances in the data.Rate this question:
-
- 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
Correct Answer
B. FalseExplanation
The given answer is "False." This suggests that the statement or question being asked is not true or accurate. Without further context or information, it is difficult to determine the specific reason why the answer is false.Rate this question:
-
- 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
Correct Answer
B. FalseExplanation
This statement is false because creating a chart is not as simple as pressing the F12 key button. Creating a chart typically involves selecting data, choosing a chart type, and customizing the chart's appearance and layout. Pressing the F12 key button may be a shortcut for certain actions in specific software programs, but it is not a universally simple way to create a chart.Rate this question:
-
- 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
Correct Answer
A. GoodExplanation
The formula states that if the value in cell A1 is greater than or equal to the value in cell B1, then the result is "Good", otherwise it is "Not Good". In this case, since A1=90 and B1=90, the condition A1>=B1 is true, so the answer is "Good".Rate this question:
-
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 18, 2023Quiz Edited by
ProProfs Editorial Team -
Jul 13, 2012Quiz Created by
Naldsauza