A financial analyst is creating a summary report. In cell C10, they need to display a custom format for sales figures that are in cell B10. The requirements are: 1. Numbers should be displayed in millions, with one decimal place (e.g., 2,550,000 should appear as 2.6 M). 2. Positive numbers should be black. 3. Negative numbers should be red and enclosed in parentheses. 4. Zero values should be displayed as a hyphen "-". Which custom number format code should be applied to cell C10?
A project manager is using the `WORKDAY.INTL` function to calculate the delivery date for a project. The start date is in cell A2, the number of working days is in A3, and a list of company holidays is in a named range `Holidays`. The company operates on a non-standard work week where only Friday is a day off. Which formula correctly calculates the end date?
You are managing a shared workbook that tracks quarterly sales data. Multiple regional managers update this single file. To maintain data integrity, you need to accept or reject changes made by others. However, the 'Accept/Reject Changes' button in the 'Changes' group on the 'Review' tab is greyed out and unavailable. What is the most likely cause of this issue?
A data analyst has a PivotTable summarizing sales by `Region` (Rows), `Product Category` (Rows), and `Year` (Columns). They need to add a new column directly within the PivotTable that calculates a 5% commission for each `Product Category` based on the total sales amount. This calculation should update dynamically as the PivotTable is filtered or refreshed. What is the most appropriate tool to achieve this?
You need to apply conditional formatting to a range of project deadlines (B2:B50). You want to highlight any date that falls on a Saturday or a Sunday. Which formula should be used in the conditional formatting rule to correctly identify weekend dates?
True or False: The 'Compare and Merge Workbooks' feature can be used to merge changes from multiple copies of a shared workbook, even if those copies have been saved with different file names.
A sales manager is creating a dashboard. They want to include a small, in-cell chart next to each salesperson's total sales figure to show their sales trend over the last 12 months. The chart should also highlight the highest and lowest sales months. Which combination of Excel features is best suited for this task? (Select TWO)
An HR manager has a worksheet with employee data. They need to ensure that when a user enters a new employee's department in column D, the entry must be one of the values from a master list of departments located in the named range `DeptList`. Additionally, when a user selects a cell in column D, an input message should appear instructing them to 'Select a department from the list'. Which feature should be configured on column D to meet all these requirements?
You are auditing a complex workbook. In cell F10, there is a formula `=SUM(Sheet2!C5, Sheet3!D8)`. You need to quickly navigate to cell C5 on Sheet2 to examine its value. Which is the most direct method to do this using Excel's formula auditing tools?
A financial analyst needs to create a chart that compares monthly revenue (in millions of dollars) against the number of units sold (in thousands). Because the scales of these two data series are vastly different, plotting them on a single value axis makes the 'units sold' series appear almost flat and unreadable. What type of chart and feature should be used to visualize this data effectively?