MENU
A business analyst creates a document with two sheets, Sheetl and Sheet2 The analyst needs to add a button on Sheetl. which will open Sheet2 and lock atl fields.
How should the analyst create this trigger?
Suggested Answer: C
Get Premium QV12BA Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
11 comments · newest first
VA
Valda
11 months ago
I’m surprised there’s no option for just locking the whole sheet directly!
MO
Mollie
11 months ago
Definitely not A, that won't trigger the lock on Sheet2.
AU
Audra
12 months ago
Wait, can you really lock all fields just by activating a sheet?
DO
Dottie
12 months ago
I think D is better, locking specific fields makes more sense.
SH
Sharan
1 year ago
Option C seems right, it covers both actions needed.
JO
Joseph
1 year ago
I’m leaning towards D because it mentions activating Sheet2 and locking fields, but I’m not completely confident.
MI
Mi
1 year ago
I remember practicing something similar, and I think the OnOpen trigger is important for locking fields. So maybe A could be right?
CH
Chara
1 year ago
I'm not entirely sure, but I feel like locking fields should happen when you open Sheet2, not when leaving Sheet1.
JE
Jeffrey
1 year ago
I think the button should trigger actions directly related to it, so maybe option C makes sense?
MY
Myra
1 year ago
Hmm, this looks like a pretty straightforward question about upgrading a VSP E790 with a SAS Expansion feature. I think I can handle this one.
CA
Carlene
1 year ago
I have a similar practice question that listed Eclipse and Sybil as key attacks; I think those are right for this question!