BCOMP Recitation

Given a full name in cell A2 (e.g., "John Doe"), write a formula to extract the first name.

=____(A2, ____(" ", A2) - 1)

(a)  

You have a list of product sales in column B. Write a formula to count how many times "Laptop" appears in the range B2:B10.

= (a)   (B2:B10, "Laptop")

You have sales figures in C2:C10, but some cells contain errors. Write a formula to return the highest sales value while ignoring errors.

= (a)   (4, 6, C2:C10)

A full name is in A2 (e.g., "John Michael Doe"). Write a formula to extract the last word (last name).

=TRIM(RIGHT(A2, LEN(A2) - FIND("#", SUBSTITUTE(A2, " ", "#", LEN(A2) - LEN( (a)   (A2, " ", ""))))))

A product code is in cell A2 (e.g., "ABC12345"). Write a formula to extract the last 4 characters.

(a)  

You have a sales record where column A contains product names, column B contains regions, and column C contains sales amounts. Write a formula to calculate the total sales of "Laptop" in the "North" region (range A2:A20 for products, B2:B20 for regions, and C2:C20 for sales).

=______(C2:C20, A2:A20, "______", B2:B20, "North")

(a)  

If cell A2 contains the start date and cell B2 contains the end date, write a formula to calculate the number of days between them.

(a)  

A department code is in cell A2 (e.g., "HR001"). Write a formula to extract the first 3.

(a)  

You have a date in cell A2 (e.g., 12/25/2024). Write a formula to extract the year.

(a)  

You want to check if cell A2 is empty. Write a formula that returns "Empty" if the cell is blank and "Not Empty" otherwise.

=__(__=" ", "Empty", "Not Empty")

(a)