BMO Technology & Tools 2

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?

Accepted Answer

Conditional Formatting with Highlight Duplicates

Answer

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?

Accepted Answer

Credential theft and unauthorized account access

Answer

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?

Accepted Answer

Ctrl + N

Answer

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:

Accepted Answer

Track and manage customer interactions and relationship history

Answer

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?

Accepted Answer

$A$1

Answer

Dollar signs before the column letter and row number ($A$1) create an absolute reference that stays fixed when a formula is copied.

(BMO) Bank of Montreal Assessment Practice Test

(BMO) Bank of Montreal Assessment Practice Test

BMO Technology & Tools 2