Excel Advance Post 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,311
| Attempts: 405
SettingsSettings
Please wait...
  • 1/17 Questions

    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
Please wait...
About This Quiz

The 'Excel 2010 Advance Post Test' assesses advanced skills in Microsoft Excel 2010, focusing on functions like LOOKUP and file formats, and understanding of Excel symbols and chart types. This quiz enhances proficiency for academic or professional use.

Excel Advance Post Test - Quiz

Quiz Preview

  • 2. 

    There is No Slicer in Excel 2007. In 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.(Slicer tiada di dalam Excle 2007 tetapi  di dalam 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

    Correct Answer
    A. True
    Explanation
    The explanation for the given correct answer, "True," is that there is no slicer in Excel 2007. Slicers were introduced in Excel 2010/2013 as easy-to-use filtering components that allow users to quickly filter data in a Pivot Table report without the need to open drop-down lists. Therefore, the statement is true because slicers are not available in Excel 2007 but are available in Excel 2010/2013.

    Rate this question:

  • 3. 

    ________ will summarizes large amounts of data using specified calculations and formats. (____________ akan meringkaskan data yang banyak menggunakan pengiraan dan format spesifik.)

    • Pivot Table

    • Validation Data

    • MATCH

    • Bubble Chart

    Correct Answer
    A. Pivot Table
    Explanation
    Pivot tables are a powerful tool in data analysis that can summarize large amounts of data using specified calculations and formats. They allow users to manipulate and organize data by grouping and summarizing it based on different variables. By selecting the desired calculations and formats, pivot tables can quickly generate summaries, such as sums, averages, counts, or percentages, for different categories or groups within the data. They are commonly used in spreadsheet software, such as Microsoft Excel, to analyze and present complex data in a simplified and organized manner.

    Rate this question:

  • 4. 

    *.xlsx is a default format for Ms Excel 2007/10/13 /(*.xlsx adalah format secara automatik bagi Ms Excel 2007/10/13)

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The given statement is true because the .xlsx format is indeed the default format for Microsoft Excel versions 2007, 2010, and 2013. This format was introduced in Excel 2007 and is widely used for saving and exchanging spreadsheet files. It replaced the older .xls format and offers various advantages such as smaller file sizes, improved data recovery, and better compatibility with other software applications.

    Rate this question:

  • 5. 

    LEFT, MID, FIND, PROPER, TRIM DAY, EDATE, MONTH, WORKDAY What type of Function valid for All above functions ? (Jenis fungsi apakah yang sah bagi semua fungsi di atas?)

    • Text Only

    • Date and Time Only

    • Text & Date and Time

    • Statistic & Math and Trig

    Correct Answer
    A. Text & Date and Time
    Explanation
    All of the functions listed above, including LEFT, MID, FIND, PROPER, TRIM, DAY, EDATE, MONTH, and WORKDAY, are valid for both text and date and time data. These functions can be used to manipulate and extract information from both text and date and time values in a spreadsheet.

    Rate this question:

  • 6. 

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

    • Not Equal

    • Equal

    • Not Valid

    • 34

    Correct Answer
    A. Equal
    Explanation
    The answer is "Equal" because the formula is comparing the value in cell E8 (which is the result of the formula =17*2, equal to 34) with the value in cell C8 (which is 34). Since the values are equal, the formula returns the value "Equal".

    Rate this question:

  • 7. 

    3 type of error alerts in data validataion are as below except (3 jenis amaran kesalahan yang boleh di pilih ketika validasi data adalah seprti berikut kecuali)

    • Stop

    • Critical

    • Warning

    • Information

    Correct Answer
    A. Critical
    Explanation
    The given answer is "Critical". This suggests that there are three types of error alerts in data validation, which include "Stop", "Warning", and "Information", but "Critical" is not one of them.

    Rate this question:

  • 8. 

    What means of this ! symbol in Excel ?Apakah maksud simbol ! di dalam Excel ?

    • Name of Workbook

    • Name of Worksheet

    • Absolute Reference

    • Name of Cell

    Correct Answer
    A. Name of Worksheet
    Explanation
    In Excel, the "!" symbol is used to separate the name of the worksheet from the cell reference. It is used to specify a cell or range of cells within a specific worksheet. For example, if we have a worksheet named "Sheet1" and we want to refer to cell A1 in that worksheet, we would write "Sheet1!A1". Therefore, the correct answer is "Name of Worksheet".

    Rate this question:

  • 9. 

    Excel provides some LOOKUP functions which are as below, EXCEPT(Excel menyediakan fungsi LOOKUP seperti dibawah kecuali)

    • Vector Lookup

    • Hector Lookup

    • Vertical Lookup

    • Horizontal Lookup

    Correct Answer
    A. Hector Lookup
    Explanation
    The correct answer is "Hector Lookup" because it is not a valid lookup function in Excel. Excel provides lookup functions such as Vertical Lookup, Vector Lookup, and Horizontal Lookup, but there is no function called Hector Lookup.

    Rate this question:

  • 10. 

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

    • True

    • False

    • Password is just for securing file while saving not securing data.

    Correct Answer
    A. True
    Explanation
    The given statement is true. You can prevent users from accidentally changing, moving, or deleting important data from a worksheet by using password protection. When you protect a worksheet with a password, users will need to enter the correct password in order to make any changes to the worksheet. This helps to ensure that important data remains intact and prevents accidental modifications. However, it is important to note that password protection is only for securing the worksheet and not the actual data within the worksheet.

    Rate this question:

  • 11. 

    What means of this [ ] symbol in Excel ?Apakah maksud simbol [ ] di dalam Excel ?

    • Name of Workbook

    • Name of Worksheet

    • Absolute Reference

    • Name of Cell

    Correct Answer
    A. Name of Workbook
    Explanation
    The [ ] symbol in Excel is used to represent the name of a workbook. It is used to enclose the name of the workbook when referencing it in formulas or when creating links between different workbooks. This symbol helps to identify and differentiate the workbook from other elements in Excel, such as worksheets, cells, or absolute references.

    Rate this question:

  • 12. 

    Which one is not one of What If Analysis tools in Ms Excel. Yang mana antara berikut BUKAN contoh tool What if analysis dalam Ms Excel?

    • Data Validation

    • Solver

    • Goal Seek

    • Scenario Manager

    Correct Answer
    A. Data Validation
    Explanation
    Data Validation is not one of the What If Analysis tools in Ms Excel. What If Analysis tools in Excel are used to explore different possibilities and scenarios by changing input values. Data Validation, on the other hand, is a tool used to control the type and format of data entered into a cell. It ensures that only valid data is entered, but it does not involve analyzing different scenarios or changing input values.

    Rate this question:

  • 13. 

    =Today() function to calculate a past or future date based on starting date and a specified number of days / Fungsi =Today() digunakna untuk mengira tarikh sebelum atau akan datang berdasarkan tarikh eprmulaan dan jumlah hari yg specifik

    • True

    • False

    Correct Answer
    A. False
    Explanation
    The explanation for the given answer "False" is that the Today() function in Excel is used to return the current date, not to calculate past or future dates based on a starting date and a specified number of days. To calculate a past or future date, the DATE function or other date-related functions need to be used. Therefore, the statement that the Today() function is used for calculating past or future dates is incorrect.

    Rate this question:

  • 14. 

    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

    Correct Answer
    A. True
    Explanation
    The statement is true because 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 and use it within Excel for analysis, calculations, and other purposes.

    Rate this question:

  • 15. 

    This is  formula  for ___ Lookup?(Berikut adalah formula untuk _____ Lookup?)=LOOKUP(B13,D2:D11,E2:E11) 

    • Hector

    • V

    • Vector

    • H

    Correct Answer
    A. Vector
    Explanation
    The formula given is LOOKUP(B13,D2:D11,E2:E11). This formula is used to perform a vector lookup. A vector lookup is a type of lookup where the values being searched for are in a single column or row, and the values being returned are in a corresponding column or row. In this case, the formula is searching for the value in cell B13 in the range D2:D11, and returning the corresponding value from the range E2:E11.

    Rate this question:

  • 16. 

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

    • True

    • False

    Correct Answer
    A. False

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

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

  • Current Version
  • Mar 18, 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.