BMO Technology & Tools 3

Question 1

A BMO teller notices the branch POS terminal screen is frozen mid-transaction. What is the safest first step?

Accepted Answer

Attempt a soft restart using the terminal's restart option or prescribed procedure

Answer

Following the prescribed soft-restart procedure minimizes data loss risk and avoids hardware damage compared to forced power removal.

Question 2

In Excel, the SUMIF function is used to:

Accepted Answer

Sum values in a range that meet a specified condition

Answer

SUMIF adds only those values in a sum range whose corresponding cells in a criteria range match the specified condition.

Question 3

BMO employees are instructed never to click links in unsolicited emails requesting login credentials. This policy defends against:

Accepted Answer

Phishing attacks designed to harvest usernames and passwords

Answer

Phishing emails impersonate trusted sources to trick recipients into entering credentials on fake login pages.

Question 4

Which Microsoft Office tool is best suited for creating a professional client presentation with charts and branded visuals?

Accepted Answer

Microsoft PowerPoint

Answer

PowerPoint is the standard Office application for slide-based presentations featuring charts, images, and transitions.

Question 5

A BMO branch manager needs to track loan applications with multiple related data fields across hundreds of clients. The most appropriate tool is:

Accepted Answer

A relational database or structured spreadsheet with defined fields

Answer

Relational databases or well-structured spreadsheets allow filtering, sorting, and querying across many records and fields efficiently.

(BMO) Bank of Montreal Assessment Practice Test