Open spreadsheet

Column A contains a generic dataset. Column $C$ is a list of questions that correspond to the questions below. Column D indicates which Excel function$($s$)$ that question is designed to teach. Column $E$ is where you will work with the function$($s$)$ to generate the answer to each question. And finally Column $F$ displays the formula you used to generate your answer in Column $E.$

To place your answers from Column $E$ into the blanks below, use the copy$/$paste keyboard shortcut: $Ctrl+C$ and $Ctrl+V$ on a $PC$ or $Cmd+C$ and $Cmd+V$ on a Mac.

If you would like to learn more about a specific function, you can always visit the Microsoft Office Support site and type the function into the search box at the top$-$right of the page.

How many data observations are present $($sample size$)?$

What is the sum of the data?

What is the mean $($average$)$ of the data $($unrounded$)?$

What is the median of the data?