Q1. A finance team is collaborating on a shared workbook that contains sensitive data. They need to allow multiple users to edit the workbook while preventing unauthorized modifications. Which of the following features should be used?
A.Enable Track Changes and Protect Workbook with a password
B. Use the Share Workbook feature and enable Read-Only mode
C. Enable Workbook Protection and apply worksheet-level permissions
D. Use Co-Authoring in Excel Online and disable automatic changes
Answer: C
Q2. You want to create a custom number format that displays negative numbers in red with parentheses, while positive numbers appear in green. Which format string should you use?
A.[Green]#,##0.00;[Red](#,##0.00)
B. #,##0.00_);[Red](#,##0.00)
C. [Red]#,##0.00;[Green]-#,##0.00
D. #,##0.00;[Red](#,##0.00);0
Answer: A
Q3. You are working with a dataset and need to retrieve the third highest value from a range (B2:B100). Which formula should you use?
A.=MAX(B2:B100)-2
B. =LARGE(B2:B100,3)
C. =RANK(B2:B100,3,0)
D. =INDEX(B2:B100,3,1)
Answer: B
$ 39
Reviews
There are no reviews yet.