ature.com$/$courses$/96685/$assignments$/1719889$

II Excel Template

Question $2$

Use the table to answer the following

Notice the table includes column and row labels $($eg$.$ A$,$ B$,$ and $1,2,3,4,...).$ You must copy and paste the labels along with the data $-$ it's not pretty but necessary to extract the data

a$.$ What is the Excel formula, including inputs, used to calculate the total of the data set? $=$SUM

$(A1vv$:$A31vv)$

$[$hint: click Jump to Answer below to see this answer. You'll then need to attempt the question again$]$

b$.$ Calculate the total of the list of data by coping and pasting the table into Excel. Use the same function you selected in part a$.-$ probably with different inputs.

Copy and Paste

$\backslash$table$[[,,B$