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

Use underscore as a name separator

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

Save new reuse workbook in your computer

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?)

Calculate data across worksheet

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

Total sum of a value based on specific criteria/ total record

Total maximum value / total record

Total minimum value / total record

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, Filters and Summary Calculations

Colour Settings and Summary Calculations

Microsoft Excel Post Evaluation – Intermediate | Attempts: 394

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

Tnd_boostson

Community Contributor

Quizzes Created: 8 | Total Attempts: 1,474

| Attempts: 394

Questions

Feedback

During the Quiz End of Quiz

Difficulty

Sequential Easy First Hard First

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

1/15 Questions

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

About This Quiz

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

2.

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

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

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

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

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

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
Correct Answer

A. Total sum of a value based on specific criteria/ total record

Explanation

The correct answer is "Total sum of a value based on specific criteria/ total record". The AVERAGEIF() function is used to calculate the average of a range of cells that meet a specific criteria. It sums up all the values that meet the criteria and divides it by the total number of records that meet the criteria. This allows you to calculate the average of a specific subset of data based on a condition.

Rate this question:
8.

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

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

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

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

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

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

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

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:

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

Microsoft Excel Post Evaluation – Intermediate

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?)

Quiz Preview

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

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)

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

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

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?)

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

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

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

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

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

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

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

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)

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)