$2\mathrm{.}0$ Excel Activity $1-$ Basic Excel Functions $($Tutorial$)$will be working in MindTap. You will be using the Microsoft Excel Online file below to work in the spreadsheet and then answer the questions. Feel free to

click on the Excel Online link now to open the spreadsheet. It will open in a separate browser tab.

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$.$

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?

$806$

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

$77\mathrm{.}27272$:

What is the median of the data?Excel Activity Video $$

Trin pruvienis ucsigneu cu rammanice you with basic Microsoft Excel functions that are commonly used in data analysis and in other Excel problems you

will be working in MindTap. You will be using the Microsoft Excel Online file below to work in the spreadsheet and then answer the questions. Feel free to

click on the Excel Online link now to open the spreadsheet. It will open in a separate browser tab.

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$)?$

$77\mathrm{.}27272$

What is the median of the data?