Question 1 :

Lakeview Payroll has this control snapshot:
Filename ¦ Cover status
Lakeview_Payroll_2026-02_Working_v05.xlsx ¦ Working
Lakeview_Payroll_2026-02_Final.xlsx ¦ Working
Lakeview_Payroll_2026-02_Issued.xlsx ¦ Issued

Which row most clearly signals a labeling conflict?

The second row

The first row

The third row

None of the rows

MCQ

Answered

0

Pending

5

Back to Assessment Details

Question 2 :

Crestview Tax Services imported a support tab where some amounts look numeric but were brought in as text.

Amount column: B2:B6
The preparer wants cell C2, copied down, to flag entries that are stored as text.

Which formula should be used in C2?

=ISNUMBER(B2)

=COUNT(B2)

=LEN(B2)=0

=ISTEXT(B2)

MCQ

Answered

0

Pending

5

Back to Assessment Details

Question 3 :

Bluewater Equipment Finance's expense listing uses:
B2:B40 = category
C2:C40 = employee name
D2:D40 = amount

A preparer used this formula to total Travel costs:
=SUMIF(C2:C40,"Travel",D2:D40)

Which specific flaw makes the formula wrong?

The formula should use COUNTIF because Travel is text.

The criteria range points to employee names instead of the category column.

The formula can only work if the amount column is placed before the criteria column.

SUMIF cannot be used when the sum range contains currency values.

MCQ

Answered

0

Pending

5

Back to Assessment Details

Question 4 :

Sterling SALT Partners uses a state apportionment grid. In B8, the formula is ' =$A8*B$3, where column A holds each state's base amount and row 3 holds state rates by column.

If that formula is copied from B8 to D8, what formula will appear in D8?

=$A8*D$3

=C8*D$3

=$A8*$D$3

=$A8*B$3

MCQ

Answered

0

Pending

5

Back to Assessment Details

Question 5 :

Workbook: Payroll change log
Field: Effective Date

Task: The workbook owner wants to allow only dates in April 2026. Dates before 04/01/2026, dates after 04/30/2026, and text such as ASAP should be blocked at entry.

Which validation setup is most appropriate?

Date validation greater than or equal to 04/01/2026

Date validation between 04/01/2026 and 04/30/2026

Date validation less than or equal to 04/30/2026

Date validation equal to 04/01/2026

MCQ

Answered

0

Pending

5

Back to Assessment Details

Excel Foundation

Lakeview Payroll has this control snapshot: Filename ¦ Cover status Lakeview_Payroll_2026-02_Working_v05.xlsx ¦ Working Lakeview_Payroll_2026-02_Final.xlsx ¦ Working Lakeview_Payroll_2026-02_Issued.xlsx ¦ Issued Which row most clearly signals a labeling conflict?

MCQ

0

5

Crestview Tax Services imported a support tab where some amounts look numeric but were brought in as text. Amount column: B2:B6 The preparer wants cell C2, copied down, to flag entries that are stored as text. Which formula should be used in C2?

MCQ

0

5

Bluewater Equipment Finance's expense listing uses: B2:B40 = category C2:C40 = employee name D2:D40 = amount A preparer used this formula to total Travel costs: =SUMIF(C2:C40,"Travel",D2:D40) Which specific flaw makes the formula wrong?

MCQ

0

5

Sterling SALT Partners uses a state apportionment grid. In B8, the formula is ' =$A8*B$3, where column A holds each state's base amount and row 3 holds state rates by column. If that formula is copied from B8 to D8, what formula will appear in D8?

MCQ

0

5

Workbook: Payroll change log Field: Effective Date Task: The workbook owner wants to allow only dates in April 2026. Dates before 04/01/2026, dates after 04/30/2026, and text such as ASAP should be blocked at entry. Which validation setup is most appropriate?

MCQ

0

5

Lakeview Payroll has this control snapshot:
Filename ¦ Cover status
Lakeview_Payroll_2026-02_Working_v05.xlsx ¦ Working
Lakeview_Payroll_2026-02_Final.xlsx ¦ Working
Lakeview_Payroll_2026-02_Issued.xlsx ¦ Issued

Which row most clearly signals a labeling conflict?

Crestview Tax Services imported a support tab where some amounts look numeric but were brought in as text.

Amount column: B2:B6
The preparer wants cell C2, copied down, to flag entries that are stored as text.

Which formula should be used in C2?

Bluewater Equipment Finance's expense listing uses:
B2:B40 = category
C2:C40 = employee name
D2:D40 = amount

A preparer used this formula to total Travel costs:
=SUMIF(C2:C40,"Travel",D2:D40)

Which specific flaw makes the formula wrong?

Sterling SALT Partners uses a state apportionment grid. In B8, the formula is ' =$A8*B$3, where column A holds each state's base amount and row 3 holds state rates by column.

If that formula is copied from B8 to D8, what formula will appear in D8?

Workbook: Payroll change log
Field: Effective Date

Task: The workbook owner wants to allow only dates in April 2026. Dates before 04/01/2026, dates after 04/30/2026, and text such as ASAP should be blocked at entry.

Which validation setup is most appropriate?