# Microsoft Excel Post Evaluation – Intermediate

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Tnd_boostson
T
Tnd_boostson
Community Contributor
Quizzes Created: 8 | Total Attempts: 1,439
Questions: 15 | Attempts: 394

Settings

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

• 1.

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

• A.

All

• B.

Column

• C.

Row

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

• 2.

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

• A.

Starts with alphabet

• B.

Use underscore as a name separator

• C.

Starts with symbols or number

C. 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)

• A.

True

• B.

False

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

• A.

VLookup()

• B.

DSUM()

• C.

Average()

B. 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)

• A.

Save new reuse workbook in your computer

• B.

Do calculations easier

• C.

Have standard report layout

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

• A.

SubTotal

• B.

Calculate data across worksheet

• C.

Data Consolidate

C. 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)

• A.

Total maximum value / total record

• B.

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

• C.

Total minimum value / total record

B. 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)

• A.

VLOOKUP(), LLOOKUP(), LOOKUP()

• B.

VLOOKUP(),HLOOKUP(),LOOKUP()

• C.

VLOOKUP(),LOOKUP(),MLOOKUP()

B. 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)

• A.

Go to Function

• B.

Group object

• C.

Sum Function

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

• A.

• B.

• C.

Insert > Text Box

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

• A.

Data > Sort

• B.

Data > Filter

• C.

Data > Sub Total

B. 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)

• A.

True

• B.

False

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

• A.

CTRL Home and End

• B.

CTRL Page Up and Page Down

• C.

CTRL Arrow Up and Arrow Down

B. 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)

• A.

True

• B.

False

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)

• A.

Colour settings and Formatting

• B.

Colour Settings and Summary Calculations

• C.

Colour Settings, Filters and Summary Calculations

C. 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 +

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

Related Topics