Advanced Microsoft Excel Test Quiz!

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: 812
SettingsSettings
Please wait...
  • 1/20 Questions

    You can consolidate data from each separate worksheet into a master worksheet to summarize and report result. / (Anda boleh consolidate data dari pelbagai lembaran kerja kepada satu lembaran kerja utama untuk diringkaskan dan melaporkan keputusan tersebut)  

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

This Advanced Microsoft Excel Test Quiz assesses proficiency in using Excel's advanced features. It covers LOOKUP functions, validation of formulas, understanding of the TODAY() function, cell naming rules, data consolidation, and locating functions within the interface.

Advanced Microsoft Excel Test Quiz! - Quiz

Quiz Preview

  • 2. 

    You can calculate automatically any figure from table filtered data. ( Anda boleh membuat pengiraan secara automatik pada jadual data yang telah disisih/ditapis)

    • True

    • False

    • I Dont Know

    Correct Answer
    A. True
    Explanation
    The given statement suggests that it is possible to perform automatic calculations on filtered data from a table. This implies that the software or tool being used has the capability to calculate figures automatically based on the filtered data. Therefore, the correct answer is True.

    Rate this question:

  • 3. 

    Is it a valid type of Chart in Micorosft Excel? (Adakah jenis Carta berikut sah di dalam Microsoft Excel?) 3-D surface and XY Scatter

    • True

    • False

    • I Dont Know

    Correct Answer
    A. True
    Explanation
    The 3-D surface and XY Scatter are valid types of charts in Microsoft Excel. These types of charts allow users to visualize and analyze data in a three-dimensional format, making it easier to identify patterns and trends. The 3-D surface chart displays data points as a continuous surface, while the XY Scatter chart plots data points on a two-dimensional plane. Both types of charts are commonly used for scientific and engineering data analysis.

    Rate this question:

  • 4. 

    You can import data from External Data into Microsoft Excel such as txt file, csv file and prn file. (Anda boleh mengimport data dari External Data ke dalam MIcrosoft Excel seperti fail txt, fail csv dan fail prn)

    • True

    • False

    • I Dont Know

    Correct Answer
    A. True
    Explanation
    The given statement is true. Microsoft Excel allows users to import data from external sources such as txt, csv, and prn files. This feature enables users to easily bring in data from different file formats into their Excel spreadsheets for analysis and manipulation.

    Rate this question:

  • 5. 

    Pivot table summarizes large amounts of data using specified calculations and formats. (Jadual Pivot meringkaskan data yang banyak menggunakan pengiraan dan format spesifik.)

    • True

    • False

    • I Dont Know

    Correct Answer
    A. True
    Explanation
    A pivot table is a powerful tool in data analysis that allows users to summarize and analyze large amounts of data. It uses specified calculations and formats to provide a concise and organized summary of the data. This helps users to gain insights and identify patterns or trends in the data. Therefore, the statement that pivot tables summarize large amounts of data using specified calculations and formats is true.

    Rate this question:

  • 6. 

    You can use data validation to Restrict data to predefined items in a list.(Anda boleh menggunakan Data Validation untuk mengawal data dari item awal yang ada di dalam senarai.)

    • True

    • False

    • I Dont Know

    Correct Answer
    A. True
    Explanation
    Data validation is a feature in Excel that allows you to set restrictions on the type and range of data that can be entered into a cell. By using data validation, you can create a drop-down list of predefined items in a list, and restrict the input to only those items. This ensures that the data entered is accurate and consistent. Therefore, the statement "You can use data validation to restrict data to predefined items in a list" is true.

    Rate this question:

  • 7. 

    3 main categories of templates you may work with in Excel  are, Installed Templates, Templates Online and Your Created Templates/ (3 kategori utama template yang boleh anda gunakan di dalam Excel adalah Template yang telah dipasang, Template secara atas talian dan Template yang anda cipta sendiri)

    • True

    • False

    • I Dont Know

    Correct Answer
    A. True
    Explanation
    The given statement is true. In Excel, there are three main categories of templates that you can work with. The first category is Installed Templates, which are pre-designed templates that come with Excel. The second category is Templates Online, which are templates that you can download from Microsoft's online template library. The third category is Your Created Templates, which are templates that you create yourself by customizing an existing template or starting from scratch. These categories provide users with a variety of options for creating and using templates in Excel.

    Rate this question:

  • 8. 

    Excel provides some LOOKUP functions which is Vector Lookup, H Lookup, V Lookup (Excel menyediakan fungsi LOOKUP seperti Vector Lookup, H Lookup dan V Lookup)

    • True

    • False

    • I Dont Know

    Correct Answer
    A. True
    Explanation
    Excel does provide some LOOKUP functions such as Vector Lookup, H Lookup, and V Lookup. These functions allow users to search for specific values in a range of cells and return corresponding values from another range. The Vector Lookup function searches for a value in a single row or column, while the H Lookup function searches for a value in the first row of a table. The V Lookup function searches for a value in the first column of a table. Therefore, the statement "Excel provides some LOOKUP functions which is Vector Lookup, H Lookup, V Lookup" is true.

    Rate this question:

  • 9. 

    Text Functions - LEFT, MID, FIND, PROPER, TRIMDate and Time Functions - DAY, EDATE, MONTH, WORKDAYAre these above functions valid for Microsoft Excel?(Adakah Function di atas sah di dalam Microsoft Excel?)

    • True

    • False

    • I Dont Know

    Correct Answer
    A. True
    Explanation
    The given functions, including LEFT, MID, FIND, PROPER, TRIM, DAY, EDATE, MONTH, and WORKDAY, are valid for use in Microsoft Excel. These functions are commonly used for manipulating and extracting data in Excel spreadsheets.

    Rate this question:

  • 10. 

    What if analysis can be use to support your decision making such as Solver, Goal Seek and Scenario Manager. What If Analysis boleh digunakan untuk membantu anda membuat keputusan seperti Solver, Goal Seek dan Scenario Manager

    • True

    • False

    • Im not sure.. what is What If Analysis?

    Correct Answer
    A. True
    Explanation
    The given answer is true because What If Analysis can indeed be used to support decision making. Solver is a tool in Excel that can be used to find the optimal solution for a problem by adjusting certain variables. Goal Seek is another tool in Excel that can be used to find the input value needed to achieve a desired output. Scenario Manager is a feature in Excel that allows users to create and compare different scenarios by changing input values. Therefore, all three tools mentioned (Solver, Goal Seek, and Scenario Manager) are examples of What If Analysis techniques that can assist in decision making.

    Rate this question:

  • 11. 

    Ms Excel 2007 dont have a slicer but for Ms Excle 2010/2013,Slicers are easy-to-use filtering components that contain a set of buttons that enables you to quickly filter the data in a Pivot Table  report without the need to open drop-down lists to find the items that you want to filter.(Ms Excel 2007 tiada fungsi slicer, teteapi ms excel 2010/2013, Slicer adalah komponen penapisan yang mudah digunakan yang mengandungi beberapa set butang yang membolehkan anda membuat penapisan data dalam Laporan Jadual Pivot secara cepat tanpa membuka senarai "drop-down" untuk mencari item yang ingin ditapis.)

    • True

    • False

    • I Dont Know

    Correct Answer
    A. True
    Explanation
    The explanation for the given correct answer is that Ms Excel 2007 does not have the slicer function, but in Ms Excel 2010/2013, slicers are available. Slicers are easy-to-use filtering components that contain a set of buttons. These buttons allow you to quickly filter the data in a Pivot Table report without the need to open drop-down lists to find the items that you want to filter. Therefore, the statement "Ms Excel 2007 don't have a slicer but for Ms Excel 2010/2013, Slicers are easy-to-use filtering components that contain a set of buttons that enables you to quickly filter the data in a Pivot Table report without the need to open drop-down lists to find the items that you want to filter" is true.

    Rate this question:

  • 12. 

    We can  find a Watch Dialog Box in Microsoft Excel at Formula Tab. (Kita boleh mendapatkan kekotak Watch di dalam Microsoft Excel pada Tab Formula)

    • True

    • False

    • I Dont Know

    Correct Answer
    A. True
    Explanation
    In Microsoft Excel, the Watch Dialog Box can be found in the Formula Tab. This feature allows users to monitor and keep track of specific cells or formulas while working on a spreadsheet. By adding cells or formulas to the watch list, users can easily observe the values and results as they change. Therefore, the statement "We can find a Watch Dialog Box in Microsoft Excel at Formula Tab" is true.

    Rate this question:

  • 13. 

    What is the answer from this formula =IF(E8=C8,"Equal","Not Equal") if cell E8 contain data value 34 and C8 contain data 43? Apakah jawapan bagi formula berikut =IF(E8=C8,"Equal","Not Equal") sekiranya sel E8 mengandungi data berniali 34 dan C8 mengandungi data 43?

    • Not Equal

    • Equal

    • I Dont Know

    Correct Answer
    A. Not Equal
    Explanation
    The formula =IF(E8=C8,"Equal","Not Equal") checks if the value in cell E8 is equal to the value in cell C8. In this case, since E8 contains the value 34 and C8 contains the value 43, the two values are not equal. Therefore, the answer is "Not Equal".

    Rate this question:

  • 14. 

    Where can you find a subtotal function in Excel ?(Dimanakah lokasi butang subtotal di dalam Excel ?)Ans:  Data Tab --> within Outline group

    • True

    • False

    • I Dont Know

    Correct Answer
    A. True
    Explanation
    In Excel, the subtotal function can be found in the Data tab within the Outline group. This function allows users to calculate subtotals for a specific range of data in a worksheet. By clicking on the Data tab and locating the Outline group, users can access the subtotal function and apply it to their data as needed.

    Rate this question:

  • 15. 

    Is it formula is valid for Vector Lookup? (Adakah formula Vector Lookup berikut sah?) =LOOKUP(B13,D3:D11,E3:E11)

    • Valid

    • Not Valid

    • I Dont Know

    Correct Answer
    A. Valid
    Explanation
    The formula "=LOOKUP(B13,D3:D11,E3:E11)" is valid for Vector Lookup. It uses the LOOKUP function to search for a value in the range D3:D11 and returns the corresponding value from the range E3:E11. This formula is commonly used to find an approximate match for a given value in a range and retrieve the corresponding value from another range.

    Rate this question:

  • 16. 

    =TODAY() function to calculate a past or future date based on starting date and a specified number of days (Fungsi =TODAY() digunakan untuk mengira tarikh sebelum atau akan datang berdasarkan tarikh permulaan dan jumlah hari yang tertentu.)

    • True

    • False

    • I Dont Know

    Correct Answer
    A. False
    Explanation
    The explanation for the given correct answer is that the TODAY() function in Excel is used to calculate the current date and does not have the capability to calculate past or future dates based on a starting date and a specified number of days. Therefore, the statement that the TODAY() function can be used to calculate a past or future date is false.

    Rate this question:

  • 17. 

    Cell/ Range can be rename either using text, symbols, number and space character Sel / Kawasan boleh dinamakan semula menggunakan teks, simbol, nombor dan ruang kosong

    • True

    • False

    • I Dont Know

    Correct Answer
    A. False
    Explanation
    The statement is false because in Excel, cell or range names cannot include symbols, numbers, or spaces. They can only consist of letters and underscores. Therefore, the given statement is incorrect.

    Rate this question:

  • 18. 

    You can prevent user from accidentally changing, moving or deleting important data from a worksheet by using only password. (Anda boleh mengelakkan pengguna dari membuat kesilapan tidak sengaja seperti mengubah, memindah atau membuang data penting dari worksheet menggunakan password sahaja)

    • True

    • False

    • I Dont Know

    Correct Answer
    A. False
    Explanation
    Using only a password cannot prevent a user from accidentally changing, moving, or deleting important data from a worksheet. While a password can provide some level of protection, it is not foolproof. Other measures such as setting specific user permissions or using data validation can also be necessary to ensure the integrity of the data.

    Rate this question:

  • 19. 

    Marks all Data Analysis Tool that Ms Excel had. Tandakan semua tool data analisis dalam Ms Excel.

    • Trendline

    • Sparkline

    • What If Analysis

    • Solver

    • I have no idea, which one

    Correct Answer(s)
    A. Trendline
    A. Sparkline
    A. What If Analysis
    A. Solver
    Explanation
    The correct answer is Trendline, Sparkline, What If Analysis, Solver. These are all data analysis tools available in Microsoft Excel. Trendline is used to show the trend or pattern in data, Sparkline is used to display small charts within a cell to show trends, What If Analysis is used to analyze different scenarios by changing input values, and Solver is used to find the optimal solution for complex problems by adjusting variables.

    Rate this question:

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

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 19, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Jul 06, 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.