BMO Technology & Tools 3 — Questions and Answers
Question 1: A BMO teller notices the branch POS terminal screen is frozen mid-transaction. What is the safest first step?
- Unplug the terminal from the power outlet immediately
- Attempt a soft restart using the terminal's restart option or prescribed procedure (Correct answer)
- Continue the transaction on a personal smartphone
- Open the terminal casing to reset hardware manually
Correct answer: Attempt a soft restart using the terminal's restart option or prescribed procedure
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:
- Sum all values in a range regardless of criteria
- Sum values in a range that meet a specified condition (Correct answer)
- Count cells containing text
- Calculate the average of a filtered list
Correct answer: Sum values in a range that meet a specified condition
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:
- Ransomware installed via USB drives
- Phishing attacks designed to harvest usernames and passwords (Correct answer)
- Insider trading violations
- Denial-of-service floods targeting BMO servers
Correct answer: Phishing attacks designed to harvest usernames and passwords
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?
- Microsoft Access
- Microsoft PowerPoint (Correct answer)
- Microsoft OneNote
- Microsoft Publisher
Correct answer: Microsoft PowerPoint
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:
- A Word document table
- A relational database or structured spreadsheet with defined fields (Correct answer)
- A plain text notepad file
- A PowerPoint slide with embedded tables
Correct answer: A relational database or structured spreadsheet with defined fields
Relational databases or well-structured spreadsheets allow filtering, sorting, and querying across many records and fields efficiently.
Question 6: What does 'cloud storage' mean in the context of BMO's document management systems?
- Storing files on a local hard drive within the branch
- Storing and accessing files on remote servers via the internet (Correct answer)
- Printing documents and filing them in physical storage
- Archiving emails on an on-premises mail server
Correct answer: Storing and accessing files on remote servers via the internet
Cloud storage places files on remote, internet-accessible servers, enabling retrieval from any authorized device.
Question 7: An Excel formula returns #DIV/0!. What is the most likely cause?
- The formula references a cell containing text
- The formula attempts to divide a number by zero or an empty cell (Correct answer)
- The spreadsheet file is corrupted
- The formula exceeds the maximum character limit
Correct answer: The formula attempts to divide a number by zero or an empty cell
#DIV/0! appears whenever a formula's denominator is zero or blank, which is mathematically undefined.
BMO Technology & Tools 3
A BMO teller notices the branch POS terminal screen is frozen mid-transaction.
What is the safest first step?