BMO Technology & Tools 2 — Questions and Answers
Question 1: A BMO analyst receives a large dataset in CSV format and needs to quickly identify duplicate customer records. Which Excel feature is most efficient for this task?
- VLOOKUP formula
- Conditional Formatting with Highlight Duplicates (Correct answer)
- PivotTable with count field
- Data Validation rules
Correct answer: Conditional Formatting with Highlight Duplicates
Conditional Formatting's 'Highlight Duplicate Values' rule instantly flags repeated entries across a selected range without requiring formulas.
Question 2: In BMO's online banking platform, two-factor authentication (2FA) primarily protects against which threat?
- SQL injection attacks
- Credential theft and unauthorized account access (Correct answer)
- Distributed denial-of-service (DDoS) attacks
- Man-in-the-middle SSL stripping
Correct answer: Credential theft and unauthorized account access
2FA adds a second verification step so stolen passwords alone cannot grant account access.
Question 3: Which keyboard shortcut in Microsoft Word quickly creates a new blank document without using the ribbon?
- Ctrl + N (Correct answer)
- Ctrl + W
- Ctrl + O
- Ctrl + D
Correct answer: Ctrl + N
Ctrl + N opens a new blank document in Word, Excel, and most Office applications.
Question 4: BMO uses CRM (Customer Relationship Management) software primarily to:
- Process payroll for branch employees
- Track and manage customer interactions and relationship history (Correct answer)
- Monitor network firewall logs
- Generate regulatory compliance filings
Correct answer: Track and manage customer interactions and relationship history
CRM systems centralize customer data, communication history, and sales pipeline information to improve service and retention.
Question 5: A financial analyst at BMO wants to lock a specific cell reference in an Excel formula so it does not shift when the formula is copied. What notation achieves this?
- &A&1
- $A$1 (Correct answer)
- #A#1
- @A@1
Correct answer: $A$1
Dollar signs before the column letter and row number ($A$1) create an absolute reference that stays fixed when a formula is copied.
Question 6: Which network protocol does BMO's online banking most critically rely on to encrypt data transmitted between a customer's browser and the server?
- FTP
- SMTP
- TLS/HTTPS (Correct answer)
- TELNET
Correct answer: TLS/HTTPS
TLS (Transport Layer Security) underpins HTTPS, encrypting data in transit to prevent eavesdropping and tampering.
Question 7: When sharing a confidential BMO client report via email, which practice best protects the document?
- Attaching it as a plain .txt file
- Password-protecting the PDF and sharing the password via a separate channel (Correct answer)
- Compressing it with ZIP and no password
- Embedding it in the email body as plain text
Correct answer: Password-protecting the PDF and sharing the password via a separate channel
Password-protecting the file and transmitting the password separately ensures that intercepting the email alone is insufficient to access the content.
BMO Technology & Tools 2
A BMO analyst receives a large dataset in CSV format and needs to quickly identify duplicate customer records.
Which Excel feature is most efficient for this task?