Cell Formulas 1

Download: Formulas1_init.xlsx

Learning Goals

• Learn how to create, copy, and edit Excel formulas
• Learn about A1 and R1C1 reference styles
• Learn the difference between COUNT and COUNTA functions
• Learn conditional counting with COUNTIF

Tasks

• Calculate sulfate measurement error for each student
• Count the number of rows in sulfate data using COUNT and COUNTA
• Count the number of males and females in the dataset

By the end of the screencast your Excel file should look something like the image below.