Excel Analysis

Crestline Health Partners reviews a long cash reconciliation tab with headers in row 6 and key identifying columns in A:C.

Review objective:
The reviewer must keep both the header row and the identifying columns visible while scrolling through the detailed recon items below and to the right.

Which setup most directly meets that review objective?

Harbor Crest Logistics maintains a fixed-asset map in Excel.

Setup:
Current row key = [@Asset_Code]
Lookup field = FA_Map[Asset_Code]
Required return = FA_Map[Asset_Group]
The team wants an INDEX-MATCH formula for this column.

Which formula is correct?

A JE support file for Ironspan Distribution fills account descriptions through a lookup. Several rows are blank because the formula is suppressing errors with IFERROR, but the real issue is that six account codes are missing from the mapping table.

The file must go to review now, and the stated objective is to isolate unresolved mapping gaps without hiding other workbook problems.

Which immediate revision is safest?

Southframe Energy Services is reviewing outside-counsel invoices with fields Month, Matter Type, Invoice ID, Amount. March has many small invoices and April has fewer very large invoices.

The senior wants the Pivot to show which month had the highest total spend, not invoice volume or typical invoice size.

Which Values setup answers that question directly?

Crescent Ledger Group wants a control section that preserves the direction of a variance but still applies a 1-unit tolerance in the status test.

B2 ¦ source total
C2 ¦ included total

Which setup best meets that requirement?