Excel Advance Post Test

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 =172 and C8 contain data 34? Apakah jawapan bagi formula berikut =IF(E8=C8,"Equal","Not Equal") sekiranya sel E8 mengandungi formula =172 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

Excel Advance Post Test

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)

Quiz Preview

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

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

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

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

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)

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

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

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 )

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

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?

=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

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)

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

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

Excel Advance Post Test

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)

Quiz Preview

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

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

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

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?

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)

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

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

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 )

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

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?

=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

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)

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

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

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

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

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

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