Excel Advance 1 Pre Test

Approved & Edited by ProProfs Editorial Team

The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.

Learn about Our Editorial Process

| By Naldsauza

Naldsauza

Community Contributor

Quizzes Created: 21 | Total Attempts: 16,146

Questions: 15 | Attempts: 562 | Updated: Mar 20, 2023

Questions

Settings

Feedback

During the Quiz End of Quiz

Difficulty

Sequential Easy First Hard First

Create your own Quiz

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

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

Rate this question:
2.

Delimited is one of Lookup Formula (Delimited merupakan salah satu formula di dalam Lookup)
- A.
  
  True
- B.
  
  False
- C.
  
  I Dont Know
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.

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
- C.
  
  I Dont Know
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.

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
- C.
  
  I Dont Know
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.

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
- C.
  
  I Dont Know
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.

Rate this question:
6.

What is Data Validation? (Apa itu Data Validation?)
- A.
  
  Control data entered by user
- B.
  
  Import data from system
- C.
  
  I Dont Know
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.

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
- C.
  
  I Dont Know
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.

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
- C.
  
  I Dont Know
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.

Rate this question:
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
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.

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
- C.
  
  I Dont Know
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.

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
- C.
  
  I Dont Know
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.

Rate this question:
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
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.

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
- C.
  
  I Dont Know
Correct Answer
B. False

Explanation
The correct answer is "False" because the question asks for a statement that is not true.

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
- C.
  
  I Dont Know
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.

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
- C.
  
  I Dont Know
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".

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 20, 2023

Quiz Edited by
ProProfs Editorial Team
Jul 13, 2012

Quiz Created by
Naldsauza

Excel Advance 1 Pre Test

Data can be imported from Notepad, Database and Webpage (Data boleh diimport dari Notepad, Database dan Laman Web )

Delimited is one of Lookup Formula (Delimited merupakan salah satu formula di dalam Lookup)

Data layout can be change by using Paste Link option (Susun atur data boleh ditukar dengan cara Paste Link)

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)

By applying Range Name for list data could ease run any Function (Dengan mengaplikasikan Range Name bagi senarai data memudahkan penggunaan pelbagai fungsi )

What is Data Validation? (Apa itu Data Validation?)

Protect Sheet and Protect Workbook option can be found in View Ribbon (Pilihan Protect Sheet dan Protect Workbook boleh didapati di ribbon View)

By default cells in Microsoft Excel is unlocked. (Secara asasnya, sel di dalam Microsoft Excel tidak dikunci)

IF function is to test certain conditions is TRUE or FALSE (Fungsi IF merupakan fungsi logikal samada ia BENAR atau TIDAK BENAR)

VLOOKUP is one of function in Database Function (VLOOKUP merupakan salah satu fungsi di dalam kategori DATABASE)

There are three types of LOOKUP functions, LOOKUP, VLOOKUP and CLOOKUP (Terdapat tiga jenis fungsi didalam LOOKUP, LOOKUP, VLOOKUP dan CLOOKUP)

XFD 1,048,576 is the limitation of Excel 2007 and 2010. (Pengakhiran Worksheet Excel 2007 dan 2010 adalah XFD 1,048,576)

You can use Tracer Arrows or Watch Windows to create formula. (Anda boleh menggunakan Tracer Arrow atau Watch Windows untuk mencipta formula)

You can create a chart as simple as press F12 key button (Anda boleh mencipta graf dengan semudah menekan kekunci F12)

What is the answer for this formula? (Apakah jawapan bagi formula berikut) =if(A1>B1,"Good","Not Good") ---> A1=90 , B1=90

Excel Advance 1 Pre Test

Data can be imported from Notepad, Database and Webpage (Data boleh diimport dari Notepad, Database dan Laman Web )

​Delimited is one of Lookup Formula (Delimited merupakan salah satu formula di dalam Lookup)

Data layout can be change by using Paste Link option (Susun atur data boleh ditukar dengan cara Paste Link)

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)

By applying Range Name for list data could ease run any Function (Dengan mengaplikasikan Range Name bagi senarai data memudahkan penggunaan pelbagai fungsi )

What is Data Validation? (Apa itu Data Validation?)

Protect Sheet and Protect Workbook option can be found in View Ribbon (Pilihan Protect Sheet dan Protect Workbook boleh didapati di ribbon View)

By default cells in Microsoft Excel is unlocked. (Secara asasnya, sel di dalam Microsoft Excel tidak dikunci)

IF function is to test certain conditions is TRUE or FALSE (Fungsi IF merupakan fungsi logikal samada ia BENAR atau TIDAK BENAR)

VLOOKUP is one of function in Database Function (VLOOKUP merupakan salah satu fungsi di dalam kategori DATABASE)

There are three types of LOOKUP functions, LOOKUP, VLOOKUP and CLOOKUP (Terdapat tiga jenis fungsi didalam LOOKUP, LOOKUP, VLOOKUP dan CLOOKUP)

XFD 1,048,576 is the limitation of Excel 2007 and 2010. (Pengakhiran Worksheet Excel 2007 dan 2010 adalah XFD 1,048,576)

You can use Tracer Arrows or Watch Windows to create formula. (Anda boleh menggunakan Tracer Arrow atau Watch Windows untuk mencipta formula)

You can create a chart as simple as press F12 key button (Anda boleh mencipta graf dengan semudah menekan kekunci F12)

What is the answer for this formula? (Apakah jawapan bagi formula berikut) =if(A1>B1,"Good","Not Good") ---> A1=90 , B1=90

Delimited is one of Lookup Formula (Delimited merupakan salah satu formula di dalam Lookup)