Microsoft Excel Post Evaluation – Advance I

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 certain requirements and is valid. This can include checking for the correct format, range, length, or data type of the input. By implementing data validation, errors and inconsistencies can be minimized, and the integrity and accuracy of the data can be maintained.

The term "workspace" refers to the area where a user can open and work on multiple documents or files. In the context of opening a workbook with predefined size and position, the workspace would provide the necessary environment or platform to do so. It is the correct answer as it aligns with the concept of creating a designated space for working on the workbook.

Data consolidation is the process of combining data from multiple ranges or sources into a single range. This is often done to create a summary or overview of the data, making it easier to analyze and interpret. By consolidating the data, you can eliminate duplicates, organize it in a structured manner, and perform calculations or other operations on the consolidated range. This can be particularly useful when working with large datasets or when you need to compare and analyze data from different sources or time periods.

The correct answer is "Update a workbook properties." This option suggests that to locate a workbook, one can update its properties. By updating the properties of a workbook, such as its title, author, or other identifying information, it becomes easier to locate the workbook based on specific criteria or information.

The function of Top/Bottom Rules in Conditional Formatting is to search for the minimum and maximum value in a range of data. It allows users to easily identify the highest and lowest values in a dataset, making it useful for data analysis and visualization.

To apply conditional formatting in a table, you need to go to the "Home" tab and click on the "Conditional Formatting" option. This option allows you to specify certain conditions or rules that will determine how the data in the table is formatted. By selecting this option, you can easily apply conditional formatting to highlight specific values, apply color scales, or add data bars to the table based on the specified conditions.

The Review Tracked Revision is used to ensure that any revisions made to a file are correct before the core content is changed. This means that the purpose of the Review Tracked Revision is to review and verify any changes made to the file, ensuring that they are accurate and appropriate before implementing them.

The correct answer is "Workbook" because file protection options typically include the ability to password protect the entire workbook, preventing unauthorized access or modifications to the file. This is different from password protection at the worksheet level, which only restricts access to specific sheets within the workbook.

All formula errors in Excel begin with the pound sign (#). This symbol is used to indicate that there is an error in the formula, such as a reference to a cell that does not exist or a calculation that cannot be performed. When Excel detects this symbol, it alerts the user to the presence of an error and provides suggestions for correcting it.

Exporting an Excel data in .txt format will save a workbook as a text file with quotation marks, tab delimited, or comma separated, but not with a dash mark.

To lock a sheet with Track Changes options active, you need to go to the "Review" tab in the Excel toolbar. From there, you can select the "Protect and Share Workbook" option. This will allow you to protect the workbook and enable the Track Changes feature at the same time. By selecting this option, you can prevent others from making changes to the sheet while still being able to track any revisions made by authorized users.

Freezing cells is not supported in a shared workbook. Freezing cells allows users to lock certain rows or columns so that they remain visible while scrolling through a large worksheet. However, in a shared workbook, this feature is not available as it could cause conflicts between multiple users trying to freeze or unfreeze cells simultaneously.

When an Excel document is saved to the web using "Save to Web" feature on Windows Live SkyDrive, it will share the path of the document through email. The path refers to the location or address where the document is stored on the web. This allows the recipient of the email to access the document by clicking on the shared path.

In a shared workbook, all users can make changes simultaneously. However, tables in Excel have special features such as structured referencing and automatic filtering, which can cause conflicts when multiple users are editing the workbook. Therefore, tables are not supported in a shared workbook to prevent any potential issues or data inconsistencies.

The term "contains formula referring to other cells" suggests that the formula in a cell is dependent on the values or calculations in other cells. Therefore, the best description for this is "Cell dependent."