RBC Technical Skills Assessment 3 — Questions and Answers
Question 1: Which Excel function counts only the cells in a range that meet a specific condition?
- COUNT()
- COUNTA()
- COUNTIF() (Correct answer)
- SUM()
Correct answer: COUNTIF()
COUNTIF() counts cells within a range that satisfy a given criterion.
Question 2: A network engineer needs to divide a single IP network into multiple smaller subnetworks. This process is called:
- Routing
- Subnetting (Correct answer)
- Switching
- NAT
Correct answer: Subnetting
Subnetting divides a large IP network into smaller, more manageable sub-networks.
Question 3: In object-oriented programming, what allows a subclass to provide a specific implementation of a method already defined in its parent class?
- Encapsulation
- Abstraction
- Overriding (Correct answer)
- Overloading
Correct answer: Overriding
Method overriding lets a subclass replace the parent's method implementation with its own version.
Question 4: A database table has 10,000 rows and a query without a WHERE clause returns all rows. Adding an index on a frequently filtered column will most likely:
- Increase storage and slow reads
- Slow writes slightly but speed up filtered reads (Correct answer)
- Have no effect on query performance
- Eliminate the need for a primary key
Correct answer: Slow writes slightly but speed up filtered reads
Indexes speed up read queries on indexed columns but add slight overhead to write operations.
Question 5: Which number system uses only the digits 0 and 1?
- Decimal
- Octal
- Hexadecimal
- Binary (Correct answer)
Correct answer: Binary
The binary (base-2) number system represents all values using only 0 and 1.
Question 6: A user receives an email asking them to click a link and enter bank credentials. This attack is best described as:
- SQL injection
- Phishing (Correct answer)
- Brute force
- Ransomware
Correct answer: Phishing
Phishing uses deceptive messages to trick users into revealing sensitive credentials or personal information.
Question 7: In a spreadsheet, the formula =IF(C5>100,"High","Low") will display 'High' when:
- C5 equals 100
- C5 is less than 100
- C5 is greater than 100 (Correct answer)
- C5 is empty
Correct answer: C5 is greater than 100
The IF condition C5>100 is true only when the value strictly exceeds 100, returning 'High'.
RBC Technical Skills Assessment 3
Which Excel function counts only the cells in a range that meet a specific condition?