Microsoft Excel Pre Evaluation – Advance I
(44).webp "Microsoft Excel Pre Evaluation Advance I - Quiz")
Choose the best answer for each of the following questions.
(Pilih jawapan yang terbaik bagi setiap soalan di bawah )
Questions and Answers
- 1.
- A.
File> Info> Properties.
- B.
File > Insert> Properties
- C.
Data> Connection> Properties.
- D.
Not sure.
Correct Answer
A. File> Info> Properties.Explanation
The correct answer is "File > Info > Properties" because this option allows the user to access the properties of a file. By selecting this option, the user can view and modify various details about the file, such as its name, size, creation date, and author. This option is commonly found in file management systems and provides a convenient way to manage and organize files.Rate this question:
-
- 2.
When you convert a workbook in a compatible mode, the file is ____ . (Apabila menukar workbook ke dalam mod compatible, fail itu akan ______ .)
- A.
Replaced the original file
- B.
Replaced with a copy
- C.
Replaced with a new worksheet
- D.
Don't know
Correct Answer
B. Replaced with a copyExplanation
When you convert a workbook in a compatible mode, the file is replaced with a copy. This means that the original file remains intact and a new copy of the workbook is created in the compatible mode. This allows you to work on the copy without affecting the original file.Rate this question:
-
- 3.
How to quick identify specific information that meets a given criterion? (Bagaimanakah cara untuk mengenalpasti maklumat tertentu dengan ciri-ciri yang ditetapkan?)
- A.
Data Validation
- B.
Conditional Customization
- C.
Conditional Formatting
- D.
Don't know
Correct Answer
C. Conditional FormattingExplanation
Conditional formatting is a feature in data analysis tools that allows users to apply specific formatting to cells or ranges based on certain conditions or criteria. By using conditional formatting, users can quickly identify specific information that meets a given criterion by applying different formatting styles, such as highlighting, color-coding, or icon sets, to the cells that meet the specified conditions. This helps users visually identify and analyze data that meets specific criteria without having to manually search or filter through the entire dataset.Rate this question:
-
- 4.
File protection with password is to prevent unauthorized user to _______________ a workbook. (Melindungi fail dengan katakunci adalah untuk mengelak pengguna yang tiada kebenaran untuk __________ workbook.)
- A.
Open and modify.
- B.
Modify and share.
- C.
Share and Consolidate.
- D.
Not Sure.
Correct Answer
A. Open and modify.Explanation
File protection with a password is implemented to prevent unauthorized users from being able to open and modify a workbook. This means that only those with the correct password will be able to access and make changes to the file, ensuring the security and integrity of the workbook's content.Rate this question:
-
- 5.
Which cannot be sort in Conditional Formatting? (Mana satukah yang tidak boleh disusun dalam Conditional Formatting?)
- A.
Cell Icon
- B.
Cell Color
- C.
Cell Border
- D.
Don't know
Correct Answer
C. Cell BorderExplanation
Cell Border cannot be sorted in Conditional Formatting because it is not a sorting option in the formatting rules. Conditional Formatting allows users to apply formatting to cells based on certain criteria, such as cell value or cell color. However, sorting options like sorting by cell icon, sorting by cell color, and sorting by cell value are available in Conditional Formatting.Rate this question:
-
- 6.
What technique is used for restricting the input value or type of data based on a specific set of criteria? (Apakah cara untuk menghalang kemasukan data berpandukan kriteria yang tertentu?)
- A.
Data Formatting.
- B.
Data Validation.
- C.
Data Customizing.
- D.
Not Sure.
Correct Answer
B. Data Validation.Explanation
Data validation is the technique used for restricting the input value or type of data based on a specific set of criteria. It ensures that the data entered into a system meets the required standards and is valid. This can include checking for correct data types, range limits, and other criteria specified by the system. By implementing data validation, errors and inconsistencies in the data can be minimized, leading to improved data quality and reliability.Rate this question:
-
- 7.
Why it is important to share a workbook through a SharePoint Server instead of sharing through e-mail? (Kenapakah penting untuk berkongsi workbook melalui SharePoint Server daripada melaui emel?)
- A.
To avoid multiple copies
- B.
To prevent data theft.
- C.
To prevent data theft.
- D.
Don't know
Correct Answer
A. To avoid multiple copiesExplanation
Sharing a workbook through a SharePoint Server instead of via email is important to avoid multiple copies. When a workbook is shared through email, multiple recipients may save their own copies of the workbook, leading to multiple versions and potential confusion. By sharing through a SharePoint Server, all users can access and collaborate on the same workbook, ensuring that everyone is working on the most up-to-date version. This helps to streamline communication and prevent the creation of unnecessary duplicate copies of the workbook.Rate this question:
-
- 8.
Which one of these is NOT the way of protecting a file? (Yang mana satukah antara berikut BUKAN cara melindungi fail?)
- A.
Restrict to be viewed by everyone
- B.
Share in a secure manner.
- C.
Modify by only trusted user.
- D.
None of above.
Correct Answer
D. None of above.Explanation
The correct answer is "None of above." This means that none of the options provided are ways of protecting a file. The options given are "Restrict to be viewed by everyone," "Share in a secure manner," and "Modify by only trusted user," which are all methods of protecting a file. Therefore, the correct answer is that there is no option listed that is not a way of protecting a file.Rate this question:
-
- 9.
What is the main purpose of sharing a protected file? (Apakah tujuan utama berkongsi fail yang dilindungi?)
- A.
To view file.
- B.
To make changes.
- C.
To revise changes.
- D.
Not Sure.
Correct Answer
B. To make changes.Explanation
The main purpose of sharing a protected file is to allow others to make changes to the file. By sharing a protected file, the owner can grant permission to specific individuals or groups to edit and modify the content of the file. This is useful for collaborative work, where multiple people need to contribute and update the file. Sharing a protected file ensures that only authorized individuals can make changes, maintaining the integrity and security of the file.Rate this question:
-
- 10.
Which element is not supported in a shared workbook? (Apakah elemen yang tidakboleh disokong dalam workbook yang dikongsi?)
- A.
Picture.
- B.
Chart.
- C.
Table.
- D.
Don't know.
Correct Answer
C. Table.Explanation
Tables are not supported in a shared workbook. Shared workbooks in Excel allow multiple users to work on the same workbook simultaneously, but certain features are not compatible with this collaboration feature. Tables, which are used to organize and analyze data in Excel, cannot be used in a shared workbook. This is because tables can have complex formulas and formatting that may cause conflicts or inconsistencies when multiple users are making changes to the workbook. Therefore, tables are not allowed in shared workbooks to ensure data integrity and prevent issues during collaboration.Rate this question:
-
- 11.
How to track any changes made to a workbook? (Bagaimanakah untuk mengenalpasti perubahan yang dibuat dalam worbook?)
- A.
Revision tracking.
- B.
Reference tracking.
- C.
Review tracking.
- D.
Not Sure
Correct Answer
A. Revision tracking.Explanation
Revision tracking allows you to keep track of any changes made to a workbook. It allows you to see the history of revisions, including who made the changes and when they were made. This can be useful for collaboration purposes or for auditing purposes. With revision tracking, you can easily identify any modifications made to the workbook and revert back to previous versions if needed.Rate this question:
-
- 12.
All the formula errors will begins with _______ sign. (Semua kesilapan formula dimulakan dengan tanda ______. )
- A.
Pound sign (#).
- B.
Exclamation sign (!).
- C.
Question mark (?).
- D.
Not Sure.
Correct Answer
A. Pound sign (#).Explanation
All the formula errors will begin with the pound sign (#). This is a common convention in many spreadsheet programs, such as Microsoft Excel, to indicate that there is an error in the formula. When a formula error occurs, the cell containing the formula will display the pound sign (#) followed by an error code, such as #DIV/0! for a division by zero error. This helps users quickly identify and troubleshoot formula errors in their spreadsheets.Rate this question:
-
- 13.
What happens if a document has been “Mark As Final”? (Apakah yang terjadi pada dokumen yang telah di “Mark As Final” kan?)
- A.
Replace with a new copy
- B.
Cannot be shared
- C.
Cannot be edited
- D.
Don't know
Correct Answer
C. Cannot be editedExplanation
When a document has been "Mark As Final", it means that it cannot be edited. This feature is often used to indicate that the document is final and should not be changed. By marking the document as final, it becomes read-only, preventing any modifications or edits from being made. This helps to ensure the integrity and accuracy of the document's content.Rate this question:
-
- 14.
Which is the correct flow of four collaboration process? (Mana satukah aliran yang benar bagi proses kolaborasi?)
- A.
Saving> Protect> Sharing> Reviewing.
- B.
Protect> Saving> Sharing> Reviewing.
- C.
Reviewing > Sharing> Protect> Saving.
- D.
Don't know
Correct Answer
B. Protect> Saving> Sharing> Reviewing.Explanation
The correct flow of four collaboration process is Protect> Saving> Sharing> Reviewing. This sequence ensures that the information or data being collaborated on is first protected or secured, then saved or stored, followed by sharing it with the relevant parties, and finally reviewing the collaboration to assess its effectiveness or make necessary improvements.Rate this question:
-
- 15.
Which is NOT to trace cell that help to validate and locate a formula? (Yang manakah BUKAN untuk mengesahkan sel yang mengandungi formula?)
- A.
Trace precedent
- B.
Trace dependent
- C.
Traceresident
- D.
Not Sure
Correct Answer
C. TraceresidentExplanation
The option "Traceresident" is not used to trace cells that help to validate and locate a formula. The correct options are "Trace precedent" and "Trace dependent" which are used to trace the cells that are used by a formula (precedents) or the cells that depend on a formula (dependents). "Traceresident" is not a valid term or function used in Excel for tracing cells.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
-
Jun 29, 2023Quiz Edited by
ProProfs Editorial Team -
Apr 02, 2013Quiz Created by
Tnd_boostson
- Calculus Quizzes
- Data Handling Quizzes
- Decimal Quizzes
- Discrete Mathematics Quizzes
- Equation Quizzes
- Fraction Quizzes
- Function Quizzes
- Geometry Quizzes
- Graph Quizzes
- Measurement Quizzes
- Multiplication Quizzes
- Number Quizzes
- Percentage Quizzes
- Place Value Quizzes
- Probability Quizzes
- Problem Solving Quizzes
- Ratio Quizzes
- Shape Quizzes
- Statistics Quizzes
- Trigonometry Quizzes
Back to top