Microsoft Excel Post Evaluation – Intermediate

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 Tnd_boostson
T
Tnd_boostson
Community Contributor
Quizzes Created: 8 | Total Attempts: 1,481
| Attempts: 394
SettingsSettings
Please wait...
  • 1/15 Questions

    AVERAGEIF () function can be define as (Fungsi Average () boleh diertikan sebagai)

    • Total maximum value / total record
    • Total sum of a value based on specific criteria/ total record
    • Total minimum value / total record
Please wait...
About This Quiz

Choose the best answer for each of the following questions.
(Pilih jawapan yang terbaik bagi setiap soalan di bawah)

Microsoft Excel Quizzes & Trivia

Quiz Preview

  • 2. 

    True or False.  SUM() function and AutoSUM function performs total values in a table (Benar atau Salah.  Fungsi SUM() dan AUTOSUM() mengira jumlah nilai di dalam satu jadual)

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The given answer is true. The SUM() function and AutoSUM function are used to calculate the total values in a table. The SUM() function is a mathematical function in Excel that adds up a range of cells, while the AutoSUM function is a shortcut in Excel that automatically inserts the SUM() function for the selected range of cells. Both functions help in calculating the total values in a table.

    Rate this question:

  • 3. 

    List down three lookup that can be found in Microsoft Excel (Senaraikan tiga jenis lookup yang boleh ditemui di dalam Microsoft Excel)

    • VLOOKUP(), LLOOKUP(), LOOKUP()

    • VLOOKUP(),HLOOKUP(),LOOKUP()

    • VLOOKUP(),LOOKUP(),MLOOKUP()

    Correct Answer
    A. VLOOKUP(),HLOOKUP(),LOOKUP()
    Explanation
    The correct answer is VLOOKUP(), HLOOKUP(), LOOKUP(). These are three types of lookup functions that can be found in Microsoft Excel. VLOOKUP() is used to search for a value in the first column of a table and retrieve a corresponding value from a specified column. HLOOKUP() is similar to VLOOKUP() but searches horizontally instead of vertically. LOOKUP() is a more generic lookup function that can be used to search for a value in a range and retrieve a corresponding value from the same position in a different range.

    Rate this question:

  • 4. 

    How to filter data based on specific criteria in an existing table? (Bagaimana untuk menapis data berdasarkan syarat tertentu di dalam jadual?)

    • Data > Sort

    • Data > Filter

    • Data > Sub Total

    Correct Answer
    A. Data > Filter
    Explanation
    To filter data based on specific criteria in an existing table, the correct option is "Data > Filter". This option allows you to apply filters to the table, specifying the criteria you want to use for filtering. By selecting this option, you can easily narrow down the data in the table to show only the rows that meet the specified criteria, making it easier to analyze and work with the relevant data.

    Rate this question:

  • 5. 

    How to create hyperlink between sheets? (Bagaimana mencipta hubungan antara dua sheet berbeza?)

    • Insert > Link

    • Insert > Hyperlink

    • Insert > Text Box

    Correct Answer
    A. Insert > Hyperlink
    Explanation
    To create a hyperlink between two sheets, you need to use the "Insert > Hyperlink" option. This allows you to link a specific cell or text in one sheet to another sheet within the same workbook. By selecting the cell or text you want to link, you can then choose the "Insert > Hyperlink" option and select the desired sheet from the list of available sheets. This will create a clickable link that will take you directly to the linked sheet when clicked.

    Rate this question:

  • 6. 

    True or False.  Relative Reference is one type of calculations in Microsoft Excel (Betul atau Salah.  Relative Reference merupakan salah satu jenis pengiraan dalam Microsoft Excel)

    • True

    • False

    Correct Answer
    A. True
    Explanation
    Relative Reference is indeed one type of calculation in Microsoft Excel. When creating formulas in Excel, you can use relative references to refer to cells relative to the current cell. This means that when you copy the formula to other cells, the references adjust automatically based on the relative position of the formula and the new cell. Relative references are useful when you want to perform the same calculation on multiple cells or when creating formulas that need to be flexible and adaptable.

    Rate this question:

  • 7. 

    Template in Excel allows you to (Template di dalam Excel membolehkan anda)

    • Save new reuse workbook in your computer

    • Do calculations easier

    • Have standard report layout

    Correct Answer
    A. Have standard report layout
    Explanation
    Using a template in Excel allows you to have a standard report layout. This means that you can create a predefined format for your reports, with specific sections, headings, and formatting. By using the template, you can ensure consistency in the appearance of your reports, making it easier for others to understand and interpret the information. Additionally, having a standard report layout can save time and effort, as you don't have to start from scratch every time you need to create a report.

    Rate this question:

  • 8. 

    By pressing CTRL G allows you to (Dengan menekan butang CTRL G membenarkan anda)

    • Go to Function

    • Group object

    • Sum Function

    Correct Answer
    A. Go to Function
    Explanation
    By pressing CTRL G, you can go to a specific function within a document or program. This shortcut allows you to quickly navigate to the desired function without having to manually search for it.

    Rate this question:

  • 9. 

    Which key to switch between sheets in a workbook? (Apakah kekunci untuk menukar antara sheet didalam workbook?)

    • CTRL Home and End

    • CTRL Page Up and Page Down

    • CTRL Arrow Up and Arrow Down

    Correct Answer
    A. CTRL Page Up and Page Down
    Explanation
    The correct answer is CTRL Page Up and Page Down. This key combination allows the user to switch between sheets in a workbook. By pressing CTRL Page Up, the user can move to the previous sheet, while pressing CTRL Page Down will move the user to the next sheet. This is a convenient way to navigate through multiple sheets within a workbook without having to use the mouse or scroll through the tabs.

    Rate this question:

  • 10. 

    By applying Format as Table in an existing table, it allows you to produce (Dengan memilih Format as Table pada jadual, ia membenarkan kita menghasilkan)

    • Colour settings and Formatting

    • Colour Settings and Summary Calculations

    • Colour Settings, Filters and Summary Calculations

    Correct Answer
    A. Colour Settings, Filters and Summary Calculations
    Explanation
    By applying Format as Table in an existing table, it allows you to produce colour settings, apply filters, and perform summary calculations.

    Rate this question:

  • 11. 

    Below are the criteria in giving names in a Range Name except (Dibawah merupakan syarat dalam menamakan Range Name kecuali)

    • Starts with alphabet

    • Use underscore as a name separator

    • Starts with symbols or number

    Correct Answer
    A. Starts with symbols or number
    Explanation
    The given criteria state that a Range Name should start with an alphabet and use an underscore as a name separator. However, it should not start with symbols or numbers. This means that Range Names cannot begin with any symbol or number, but they must start with an alphabet.

    Rate this question:

  • 12. 

    C$4 is one of the Mixed Reference calculations.  On which area that is locked? (C$4 merupakan salah satu dari pengiraan bagi Mixed Reference.  Pada bahagian manakah ia dikunci?)

    • All

    • Column

    • Row

    Correct Answer
    A. Row
    Explanation
    The correct answer is "Row". This means that when using the mixed reference C$4, only the row number will be locked while the column can still be adjusted. This allows for easy copying and pasting of formulas across different columns while keeping the reference to the same row.

    Rate this question:

  • 13. 

    Choose the best answer.  How to calculate summary data from a different worksheet easily? (Pilih jawapan terbaik.  Bagaimana untuk mengira kumpulan data dari sheet yang berbeza dengan mudah?)

    • SubTotal

    • Calculate data across worksheet

    • Data Consolidate

    Correct Answer
    A. Data Consolidate
    Explanation
    Data Consolidate is the best answer because it refers to the process of combining data from different worksheets or ranges into a single summary report. This feature allows users to easily calculate summary data by selecting the desired worksheets or ranges and specifying the calculation method. SubTotal and Calculate data across worksheet do not specifically refer to the process of calculating summary data from a different worksheet.

    Rate this question:

  • 14. 

    Which one of these functions is under Database Function category? (Yang mana satukah fungsi dibawah adalah di dalam kategori Fungsi Database?)

    • VLookup()

    • DSUM()

    • Average()

    Correct Answer
    A. DSUM()
    Explanation
    DSUM() is the function under the Database Function category because it is commonly used to sum the values in a column of a database based on specified criteria. It allows users to perform calculations on a specified set of records in a database, making it a useful tool for data analysis and manipulation. VLookup() and Average() are not specifically categorized as database functions, as they are more commonly used for searching and calculating averages in a range of cells, respectively.

    Rate this question:

  • 15. 

    True or False.  You could use Pie Chart to compare data. (Benar atau Salah.  Anda boleh menggunakan Pie Chart untuk membuat perbandingan data)

    • True

    • False

    Correct Answer
    A. False
    Explanation
    A pie chart is not suitable for comparing data as it represents parts of a whole. It is used to show the proportion or percentage of each category within a dataset. To compare data, it is more appropriate to use bar charts, line graphs, or scatter plots.

    Rate this question:

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

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

  • Current Version
  • Mar 22, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Mar 28, 2013
    Quiz Created by
    Tnd_boostson
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.