Session 2

What does the formula =SUM(A1:A10) do?

• • a) Counts the number of cells from A1 to A10.

• • b) Adds up all the values in cells A1 to A10.

• • c) Finds the highest value in cells A1 to A10.

• • d) Finds the average of values in cells A1 to A10.

If you want to find the number of empty cells in a column, which function will you use?

• • a) =COUNT

• • • b) =COUNTA

• • c) =COUNTBLANK

• • d) =IF

If you want to count how many movies in a list have a budget over $50 million, which function would you use?

• • a) =COUNTIF

• • • b) =IF

• • c) =AVERAGE

• • d) =SUMIF

What does the formula =AND(A1>10, B1<20) check?

• • a) If both A1 and B1 are greater than 10.

• • b) If A1 is greater than 10 and B1 is less than 20.

• • c) If either A1 or B1 is greater than 10.

• • d) If A1 is equal to 10.

Which function is used to search for a value in a table and return a corresponding value from another column?

• • a) =VLOOKUP

• • b) =IF

• • c) =COUNTIF

• • d) =MATCH

What will =IF(A1>50, "Pass", "Fail") return if A1 contains the value 45?

• • a) Pass

• • b) Fail

• • c) 50

• • d) Error

What does =MEDIAN(A1:A10) calculate?

• • a) The sum of all values in the range A1 to A10.

• • b) The most frequently occurring value in the range.

• • c) The middle value in the range, when sorted.

• • d) The highest value in the range.

If you want to find the name of the director of a movie titled “Inception,” which function can help?

• • a) =SUMIF

• • b) =IF

• • c) =COUNTIF

• • d) =VLOOKUP

In a relational database, what does a “row” represent?

• A) A type of data visualization

• B) A record containing a single data entry

• C) formula applied to the table

• D) A set of descriptive statistics

What does Exploratory Data Analysis (EDA) help you do?

• A) Clean and validate data for errors
  

• B) Generate reports with clear recommendations
  

• C) Understand patterns, trends, and relationships within data
  

• D) Transform unstructured data into structured tables