Functions in Excel

A. What Is a Cell Reference (Address)?

It is a way to identify a specific cell in a worksheet. For example, A2 refers to the cell located in the first column and the second row.

B. How Does Autofill Handle References?

References can be categorized in Autofill as follows:

0

0

0

0

Exercise

In the chick daily weights dataset, what is the total weight gain each day for chick_1, relative to its weight on day 0?

C. Logical Functions - IF(), AND(), OR()

0

0

0

Exercise

Create columns that mark all records from the chick daily weights dataset:

  • If it is from diet_2 and diet_4 (tricky question alert!)
  • If it has a weight over 100g after day 10

D. Lookup Function - XLOOKUP()

0

Exercise

Which chick weighs more than 160g on day 10? And what diet does it take?

On which day does the average chick weight exceed 100 grams for each diet? (challenging question alert!)