Consider the String Below

question 24

Multiple Choice

Consider the String below:
String r = "a toyota";
Which of the following will create the String r1 = "a TOYOTa"?

• A) String r1 = r.replace("toyot", TOYOT");
• B) String r1 = r.replace('t','T');
• r1 = r.replace('o','0');
• r1 = r.replace('y','Y');
• C) String r1 = r.replace('t','T').replace('o', '0').replace('y', 'Y');
• D) String r1 = r.substring(2, 4).toUpperCase();

---

Definitions:

Sparkline Chart

A mini-chart embedded within a cell in a spreadsheet to show a visual summary or trend.

Absolute Cell Reference

In spreadsheet applications, a cell reference that remains constant even if the formula is copied to a different location.

Nested IF

In programming and spreadsheet formulas, a condition within another IF statement, allowing for multiple conditions to be tested in sequence.

Clustered Column Chart

A type of chart in Excel that groups similar data in columns that are clustered together, useful for comparing multiple categories.