Excel Advance 1 Pre Test

Reviewed by 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
N
Naldsauza
Community Contributor
Quizzes Created: 21 | Total Attempts: 16,239
| Attempts: 563
SettingsSettings
Please wait...
  • 1/15 Questions

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

    • True
    • False
    • I Dont Know
Please wait...
About This Quiz

The 'Excel Advance 1 Pre Test' evaluates advanced Excel skills, focusing on data import capabilities, the use of formulas, conditional formatting, and data validation. This quiz is designed to test proficiency and enhance user understanding of Excel's complex functionalities.

Excel Advance 1 Pre Test - Quiz

Quiz Preview

  • 2. 

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

    • True

    • False

    • 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:

  • 3. 

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

    • True

    • False

    • 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:

  • 4. 

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

    • True

    • False

    • 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:

  • 5. 

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

    • Control data entered by user

    • Import data from system

    • 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:

  • 6. 

    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)

    • True

    • False

    • 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:

  • 7. 

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

    • True

    • False

    • I Dont Know

    Correct Answer
    A. 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:

  • 8. 

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

    • Good

    • Not Good

    • I Dont Know

    Correct Answer
    A. 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:

  • 9. 

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

    • True

    • False

    • I Dont Know

    Correct Answer
    A. 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:

  • 10. 

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

    • True

    • False

    • I Dont Know

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

    Rate this question:

  • 11. 

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

    • True

    • False

    • I Dont Know

    Correct Answer
    A. 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:

  • 12. 

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

    • True

    • False

    • I Dont Know

    Correct Answer
    A. 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:

  • 13. 

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

    • True

    • False

    • I Dont Know

    Correct Answer
    A. 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:

  • 14. 

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

    • True

    • False

    • I Dont Know

    Correct Answer
    A. 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:

  • 15. 

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

    • True

    • False

    • I Dont Know

    Correct Answer
    A. 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:

Quiz Review Timeline (Updated): Mar 20, 2023 +

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
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.