1.
=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
Correct Answer
B. 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.
2.
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
Correct Answer
B. False
3.
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)
Correct Answer
A. True
Explanation
The explanation for the given correct answer is that in Microsoft Excel, the Watch dialog box can be found in the Formula tab. This dialog box allows users to monitor specific cells or ranges of cells and view their current values while working on a worksheet. By adding cells to the watch list, users can easily keep track of important values and formulas in their spreadsheet. Therefore, the statement "We can find a Watch Dialog Box in Microsoft Excel at Formula Tab" is true.
4.
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?)
Correct Answer
C. 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.
5.
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)
Correct Answer
B. 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.
6.
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 )
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.
7.
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?
Correct Answer
B. 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".
8.
________ will summarizes large amounts of data using specified calculations and formats.
(____________ akan meringkaskan data yang banyak menggunakan pengiraan dan format spesifik.)
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.
9.
Excel provides some LOOKUP functions which are as below, EXCEPT(Excel menyediakan fungsi LOOKUP seperti dibawah kecuali)
Correct Answer
B. 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.
10.
This is formula for ___ Lookup?(Berikut adalah formula untuk _____ Lookup?)=LOOKUP(B13,D2:D11,E2:E11)
Correct Answer
C. 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.
11.
*.xlsx is a default format for Ms Excel 2007/10/13 /(*.xlsx adalah format secara automatik bagi Ms Excel 2007/10/13)
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.
12.
What means of this ! symbol in Excel ?Apakah maksud simbol ! di dalam Excel ?
Correct Answer
B. 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".
13.
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)
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.
14.
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.)
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.
15.
What means of this [ ] symbol in Excel ?Apakah maksud simbol [ ] di dalam Excel ?
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.
16.
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?
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.