# Microsoft Excel Pre 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,447
Questions: 15 | Attempts: 490

Settings

Choose the best answer for each of the following questions.

(Pilih jawapan yang terbaik bagi setiap soalan di bawah)

• 1.

### Which on these formulas represent locked calculations of a cell? (Yang mana satukah mewakili pengiraan berkunci bagi satu sel?)

• A.

A1 + A2

• B.

A1 / \$A\$2

• C.

A1 / A\$2

• D.

Not Sure

B. A1 / \$A\$2
Explanation
The formula A1 / \$A\$2 represents locked calculations of a cell. The use of the dollar sign (\$) before the column and row reference (\$A\$2) indicates that the reference is absolute and will not change when the formula is copied to other cells. This ensures that the division calculation will always be performed with the value in cell A1 and the value in cell A2, regardless of where the formula is copied.

Rate this question:

• 2.

### What function that can be used to calculate total years of service? (Apakah fungsi yang boleh digunakan untuk mengira jumlah tahun bertugas?)

• A.

Date()

• B.

DateDif()

• C.

Year()

• D.

Not Sure

B. DateDif()
Explanation
The correct answer is DateDif(). The DateDif() function is used to calculate the difference between two dates in terms of years, months, or days. It can be used to calculate the total years of service by providing the start date and end date as arguments to the function.

Rate this question:

• 3.

### What function to return True or False? (Apakah fungsi yang boleh menghasilkan nilai Benar atau Salah?)

• A.

And()

• B.

Else()

• C.

If()

• D.

Not Sure

C. If()
Explanation
The function "If()" can return either True or False based on the condition provided. It evaluates a given condition and returns True if the condition is true, and False if the condition is false.

Rate this question:

• 4.

### What function to calculate total Male in a department? (Apakah fungsi untuk mengira jumlah Lelaki dalam satu jabatan?)

• A.

COUNTIF()

• B.

COUNTA()

• C.

COUNTBLANK()

• D.

Not Sure

A. COUNTIF()
Explanation
The COUNTIF() function is used to calculate the total number of males in a department. It allows you to specify a criteria or condition, in this case, "male", and counts the number of cells that meet that criteria. Therefore, it can be used to count the total number of males in a department by applying the criteria to a range of cells that contain the gender information.

Rate this question:

• 5.

### What function to sum a value based on 2 different criteria in a table? (Apakah fungsi bagi mengira jumlah berdasarkan 2 syarat yang berbeza dalam jadual?)

• A.

SUMIF()

• B.

SUMIFS()

• C.

SUM()

• D.

Not Sure

B. SUMIFS()
Explanation
The correct answer is SUMIFS(). This function allows you to sum values in a table based on multiple criteria or conditions. It can be used to sum a value based on 2 different criteria in a table by specifying the range of cells to sum, as well as the criteria range and criteria for each condition.

Rate this question:

• 6.

### How to create Total sum in Format as Table? (Bagaimana untuk memcipta Total Sum dalam Format as Table?)

• A.

TOTAL SUM

• B.

TOTAL ROW

• C.

TOTAL COLUMN

• D.

Not Sure

B. TOTAL ROW
Explanation
To create a Total Sum in Format as Table, you can use the "TOTAL ROW" option. This option allows you to add a row at the bottom of the table that calculates the total sum of each column. By selecting this option, you can easily view the total sum of the data in the table without having to manually calculate it.

Rate this question:

• 7.

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

• D.

Not Sure

B. Calculate data across worksheet
Explanation
The correct answer is "Calculate data across worksheet." This option suggests that to calculate summary data from a different worksheet easily, one should use a method or function that allows for the consolidation or calculation of data across multiple worksheets. This could involve using formulas, such as SUM or AVERAGE, that reference cells or ranges on different worksheets. By doing so, the user can easily calculate summary data without manually transferring or copying data between worksheets.

Rate this question:

• 8.

### Which key is used to transfer chart to a new worksheet? (Apakah jenis kekunci untuk memindahkan carta ke muka yang baru?)

• A.

F12

• B.

F10

• C.

F11

• D.

Not Sure

C. F11
Explanation
The F11 key is used to transfer a chart to a new worksheet.

Rate this question:

• 9.

### How to create 2 axes in one chart? (Bagaimana untuk mencipta 2 paksi dalam satu carta?)

• A.

Change bar to line Chart > Double click > Secondary Axis

• B.

Double click on bar chart > Secondary Axis

• C.

Chart Tools Design > Change Chart Type

• D.

Not Sure

A. Change bar to line Chart > Double click > Secondary Axis
Explanation
To create 2 axes in one chart, you need to change the chart type from bar to line chart. Then, double click on the chart to open the chart options. From there, select the option for adding a secondary axis. This will create a second axis in the chart, allowing you to plot two different sets of data on separate axes.

Rate this question:

• 10.

### How to create customize data display in chart? (Bagaimana untuk mencipta paparan yang terpilih didalah Carta?)

• A.

Select Data

• B.

Select Data Row

• C.

Save as template

• D.

Not Sure

A. Select Data
Explanation
The correct answer is "Select Data". This option allows users to choose the specific data they want to display in the chart. By selecting the data, users can customize the chart to show only the relevant information and create a more tailored data display.

Rate this question:

• 11.

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

• D.

Not Sure

C. Have standard report layout
Explanation
The correct answer is "Have standard report layout." Templates in Excel provide pre-designed layouts and formatting for creating standard reports. This saves time and effort as users can simply fill in the necessary data and the template will automatically generate a professional-looking report with consistent formatting.

Rate this question:

• 12.

### __________ to ease your calculation process (____________ memudahkan proses pengiraan)

• A.

Cell name

• B.

Range name

• C.

Table name

• D.

Not Sure

B. Range name
Explanation
A range name is a defined name or label given to a specific range of cells in a spreadsheet. By using range names, it becomes easier to refer to and perform calculations on specific sets of data within the spreadsheet. This helps to simplify the calculation process and make it more efficient.

Rate this question:

• 13.

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

• A.

Total sum of a value / total record

• B.

Total maximum value / total record

• C.

Total minimum value / total record

• D.

Not Sure

A. Total sum of a value / total record
Explanation
The average function calculates the total sum of a value and divides it by the total number of records. This gives the average value of the dataset.

Rate this question:

• 14.

### True or False.  There are 3 types of Lookup function in Excel (Betul atau salah.  Terdapat 3 jenis fungsi Lookup dalam Excel)

• A.

True

• B.

False

• C.

Not sure

A. True
Explanation
There are indeed three types of Lookup functions in Excel: VLOOKUP, HLOOKUP, and INDEX/MATCH. VLOOKUP is used to search for a value in the first column of a table and return a corresponding value in the same row from a different column. HLOOKUP is similar to VLOOKUP, but it searches for a value in the first row of a table and returns a value from a different row. INDEX/MATCH is a combination of the INDEX and MATCH functions, which allows for more flexible and powerful lookup capabilities. Therefore, the statement "There are 3 types of Lookup function in Excel" is true.

Rate this question:

• 15.

### True or False.  There are three types of references in Excel.  (Betul atau salah.  Terdapat tiga cara pengiraan dalam Excel)

• A.

True

• B.

False

• C.

Not sure

A. True
Explanation
The given answer is true because there are indeed three types of references in Excel. The three types are relative references, absolute references, and mixed references. Relative references adjust when copied or filled, absolute references remain constant, and mixed references have a combination of relative and absolute references. These types of references are used to refer to cells or ranges in formulas and calculations in Excel.

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