Question 1 :

Duplicate-pair flag

Data
Entity ¦ Ref
Arden Steel ¦ 4102
Arden Steel ¦ 4102
Arden Steel ¦ 4103
Belltide Energy ¦ 4102

Formula in C2 copied down:
'=COUNTIFS($A$2:$A$5,A2,$B$2:$B$5,B2)>1'

Which statement is correct?

All four rows return TRUE because Ref 4102 appears more than once somewhere in the list.

Only the two Arden Steel ¦ 4102 rows return TRUE.

All rows with Ref 4102 return TRUE, regardless of Entity.

Only the second Arden Steel ¦ 4102 row returns TRUE because it is the duplicate occurrence.

MCQ

Answered

0

Pending

5

Back to Assessment Details

Question 2 :

A KPI tile should display Gross Margin % as Gross Margin divided by Revenue.

B5 contains Gross Margin and B6 contains Revenue. If Revenue is 0, the tile should show a dash rather than an error or 0%.

Which formula best matches that requirement?

=IFERROR(B5/B6,"-")

=IF(B6=0,"-",B5/B6)

=IF(B5=0,"-",B5/B6)

=B5/B6

MCQ

Answered

0

Pending

5

Back to Assessment Details

Question 3 :

A review lead wants a first-open control tab that answers three questions before any detail testing begins.

1. Is this the approved release?
2. Are any required tabs missing?
3. Were formulas overwritten in the protected calculation range?

Which design best supports that review objective?

A cover tab with file name, preparer name, and a color legend for input cells

A visible control tab showing release-match status, required-tab exceptions, and a count of non-formula cells in the protected calculation range

A hidden review sheet containing narrative instructions for managers

A separate email reminder asking preparers to confirm that they used the right file

MCQ

Answered

0

Pending

5

Back to Assessment Details

Question 4 :

Rivermark Assurance maintains a 90,000-row exception log.

Current design:
Six formula-based conditional-formatting rules apply across nearly the entire used range, including old archive columns.

Goal:
Improve open and save performance while keeping exception highlighting in the live review area.

Which first correction is best?

Add another rule that shades blank rows white

Hide the archive columns instead of changing the rules

Restrict the applies-to ranges to the real live data block and consolidate overlapping rules

Replace the conditional formatting with manual fill colors before each review

MCQ

Answered

0

Pending

5

Back to Assessment Details

Question 5 :

Workbook: Monthly close control summary
Need: A banner at the top should turn red only when the workbook is not safe to issue
Control objective: The banner must reflect unresolved control failures, not just whether checks were run

Which trigger is strongest?

Red when the preparer has not signed off the cover tab

Red when any control cell contains text

Red when the latest refresh date is older than today

Red when unresolved exception count is above zero or any required control status is Fail

MCQ

Answered

0

Pending

5

Back to Assessment Details

Excel Analysis

Duplicate-pair flag Data Entity ¦ Ref Arden Steel ¦ 4102 Arden Steel ¦ 4102 Arden Steel ¦ 4103 Belltide Energy ¦ 4102 Formula in C2 copied down: '=COUNTIFS($A$2:$A$5,A2,$B$2:$B$5,B2)>1' Which statement is correct?

MCQ

0

5

A KPI tile should display Gross Margin % as Gross Margin divided by Revenue. B5 contains Gross Margin and B6 contains Revenue. If Revenue is 0, the tile should show a dash rather than an error or 0%. Which formula best matches that requirement?

MCQ

0

5

A review lead wants a first-open control tab that answers three questions before any detail testing begins. 1. Is this the approved release? 2. Are any required tabs missing? 3. Were formulas overwritten in the protected calculation range? Which design best supports that review objective?

MCQ

0

5

MCQ

0

5

Workbook: Monthly close control summary Need: A banner at the top should turn red only when the workbook is not safe to issue Control objective: The banner must reflect unresolved control failures, not just whether checks were run Which trigger is strongest?

MCQ

0

5

Duplicate-pair flag

Data
Entity ¦ Ref
Arden Steel ¦ 4102
Arden Steel ¦ 4102
Arden Steel ¦ 4103
Belltide Energy ¦ 4102

Formula in C2 copied down:
'=COUNTIFS($A$2:$A$5,A2,$B$2:$B$5,B2)>1'

Which statement is correct?

A KPI tile should display Gross Margin % as Gross Margin divided by Revenue.

B5 contains Gross Margin and B6 contains Revenue. If Revenue is 0, the tile should show a dash rather than an error or 0%.

Which formula best matches that requirement?

A review lead wants a first-open control tab that answers three questions before any detail testing begins.

1. Is this the approved release?
2. Are any required tabs missing?
3. Were formulas overwritten in the protected calculation range?

Which design best supports that review objective?

Workbook: Monthly close control summary
Need: A banner at the top should turn red only when the workbook is not safe to issue
Control objective: The banner must reflect unresolved control failures, not just whether checks were run

Which trigger is strongest?