Analyze Data to Answer Questions

LEFT JOIN returns all rows from the left table and only the matching rows from the right table. When there is no match in the right table, NULL values are returned for the right table's columns.

Let's examine why the other options are incorrect:

• OUTER JOIN is a broader category that includes LEFT, RIGHT, and FULL outer joins. The description given (returning only left table rows that have corresponding right table matches) is actually incorrect - that would describe an INNER JOIN behavior.

• INNER JOIN returns only the rows where there is a match in BOTH tables. It does not return all rows from the left table - it excludes left table rows that have no matching right table data.

• RIGHT JOIN does the opposite of what the question asks. RIGHT JOIN returns all rows from the RIGHT table and only matching rows from the LEFT table, not all rows from the left table as stated in this answer option.

The correct formula is =IF(B2<50,"Small",IF(B2<200,"Medium","Large"))

This formula works correctly because it uses nested IF statements with proper logical flow:

1. First, it checks if B2 is less than 50. If true, it returns "Small"
2. If the first condition is false (meaning B2 is 50 or greater), it then checks if B2 is less than 200. If true, it returns "Medium" (this covers the $50-$199 range)
3. If both conditions are false (meaning B2 is 200 or greater), it returns "Large"

Let's examine why the other formulas are problematic:

The formula checking >=200 first, then >=50, then "Small" also works correctly and produces the same results. This is actually an equally valid alternative approach that checks from the highest threshold down.

The formula that checks <50 first, then >=200, then "Medium" also works correctly because:
- Values under 50 get "Small"
- Values 200+ get "Large"
- Everything else (50-199) gets "Medium"

The formula using <=50 and <=199 with three nested IFs has an issue: it uses <=50 which means a transaction of exactly $50 would be labeled "Small" instead of "Medium", and <=199 instead of <200. The boundary conditions are slightly off from the requirements. Additionally, the third IF(B2>=200,"Large") is redundant since if we've passed the first two conditions, we already know B2 must be 200 or greater.

The first formula represents the cleanest and most intuitive approach to this categorization problem.

The format code '%Y' represents a four-digit year such as 2024.

In date formatting conventions used across spreadsheet applications and programming languages, '%Y' is a standard format specifier that outputs the full four-digit year. For example, if the date is January 15, 2024, using '%Y' would return '2024'.

The other options are incorrect:

• A two-digit year would actually be represented by '%y' (lowercase), not '%Y'. For example, '%y' for 2024 would return '24'.

• The day of the year as a three-digit number is represented by '%j', not '%Y'. This would show values from 001 to 366.

• There is no standard format code that combines month and day into a four-digit representation. Month and day are typically formatted separately using codes like '%m' (month as two digits) and '%d' (day as two digits).