Excel Advance Post Test
Select the best answer. (Pilih jawapan yang paling tepat)
Questions and Answers
- 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
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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:
-
- 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
- A.
True
- B.
False
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)
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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.Rate this question:
-
- 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?)
- A.
Text Only
- B.
Date and Time Only
- C.
Text & Date and Time
- D.
Statistic & Math and Trig
Correct Answer
C. Text & Date and TimeExplanation
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:
-
- 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)
- A.
Stop
- B.
Critical
- C.
Warning
- D.
Information
Correct Answer
B. CriticalExplanation
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:
-
- 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 )
- A.
True
- B.
False
- C.
Password is just for securing file while saving not securing data.
Correct Answer
A. TrueExplanation
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:
-
- 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?
- A.
Not Equal
- B.
Equal
- C.
Not Valid
- D.
34
Correct Answer
B. EqualExplanation
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:
-
- 8.
________ will summarizes large amounts of data using specified calculations and formats. (____________ akan meringkaskan data yang banyak menggunakan pengiraan dan format spesifik.)
- A.
Pivot Table
- B.
Validation Data
- C.
MATCH
- D.
Bubble Chart
Correct Answer
A. Pivot TableExplanation
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:
-
- 9.
Excel provides some LOOKUP functions which are as below, EXCEPT(Excel menyediakan fungsi LOOKUP seperti dibawah kecuali)
- A.
Vector Lookup
- B.
Hector Lookup
- C.
Vertical Lookup
- D.
Horizontal Lookup
Correct Answer
B. Hector LookupExplanation
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.
This is formula for ___ Lookup?(Berikut adalah formula untuk _____ Lookup?)=LOOKUP(B13,D2:D11,E2:E11)
- A.
Hector
- B.
V
- C.
Vector
- D.
H
Correct Answer
C. VectorExplanation
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:
-
- 11.
*.xlsx is a default format for Ms Excel 2007/10/13 /(*.xlsx adalah format secara automatik bagi Ms Excel 2007/10/13)
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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:
-
- 12.
What means of this ! symbol in Excel ?Apakah maksud simbol ! di dalam Excel ?
- A.
Name of Workbook
- B.
Name of Worksheet
- C.
Absolute Reference
- D.
Name of Cell
Correct Answer
B. Name of WorksheetExplanation
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:
-
- 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)
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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:
-
- 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.)
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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:
-
- 15.
What means of this [ ] symbol in Excel ?Apakah maksud simbol [ ] di dalam Excel ?
- A.
Name of Workbook
- B.
Name of Worksheet
- C.
Absolute Reference
- D.
Name of Cell
Correct Answer
A. Name of WorkbookExplanation
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:
-
- 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?
- A.
Data Validation
- B.
Solver
- C.
Goal Seek
- D.
Scenario Manager
Correct Answer
A. Data ValidationExplanation
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:
-
Back to top