Highlight the best answer $($use yellow highlighter$)$

$1.$ To arrange rows in alphabetical order based on column A$,$ you need to use the command $\_\_\_\_\_.$

a$.$ Tools $|$ Sort

b$.$ Data $|$ Sort

c$.$ Edit $|$ Data $|$ Sort

d$.$ none of the above

$2.$ To edit existing data in a cell, you should $\_\_\_\_\_.$

a$.$ double$-$click the cell

b$.$ click in the Formula bar

c$.$ hold SHIFT down while clicking the cell

d$.$ none of the above $-$ you must retype.

$3.$ If you select a cell with a date in it and drag the fill handle down across several cells, what happens is that $\_\_\_\_\_.$

a$.$ the date is copied to each cell

b$.$ the date is increased by $1$ day into each cell

c$.$ the date is increased by $1$ week into each cell

d$.$ nothing as AutoFill applies only to numbers

$4.$ To print just part of a sheet, you would select what you want to print and $\_\_\_\_\_$

a$.$ click the Print button

b$.$ press the PRINT SCREEN key

c$.$ select Print selection on Page Setup $|$ Sheet and then print

d$.$ select Print selection in the Print dialog and then print

$5.$ To remove the contents of several cells at once, you can $\_\_\_\_\_.$

a$.$ select the cells and press DELETE.

b$.$ select the cells and choose Edit $|$ Clear... $|$ Contents

c$.$ select the cells and drag the fill handle back up over them

d$.$ all of the above

$6.$ The formula that will add the value of cell D$4$ to the value of C$2$ and then multiply by the value in B$2$ is $\_\_\_\_\_.$

a$.($D$4+$C$2)*$B$2$

b$.$ D$4+$C$2*$B$2$

c$.=($D$4+$C$2)*$B$2$

d$.=($B$2*($D$4+$C$2)$

$7.$ Cell A$4=2$ and A$5=4.$ You select both cells and drag the fill handle down to A$8.$ The contents of cells A$6,$ A$7,$ and A$8$ are $\_\_\_\_\_.$

a$.8,16,32$

b$.2,4,2$

c$.2,2,2$

d$.6,8,10$

$8.$ If a cell shows ####### $,$ it means that $\_\_\_\_\_.$

a$.$ your formula has a syntax error

b$.$ the row is too short to show the number at the current font size

c$.$ the column is too narrow to show all the digits of the number

$9.$ Find the Average, Mode, median, and Standard Deviation $($using EXCEL$)$ for the following set of numbers:

$77,81,99,100,25,48,80,100$

$10.$ Graph the following data in EXCEL with X being the independent variable and Y being the dependent variable: $($make sure to leave the first two rows of the sheet empty.$)$

X $=1,$ Y $=1$

X $=2,$ Y $=8$

X $=3,$ Y $=27$

X $=4,$ Y $=65$

X $=5,$ Y $=80$

X $=6,$ Y $=110$

What do you think is the best fit curve for this data?

What do you think is the best fit curve for this data? What is the R$2$ value?

$11.$ In the same excel sheet, create a column and populate it using the following equation

Z $=($X$^2+$ Y$)*$ cell A$2,$ where the cell A$2$ holds a value of $4.$

On the same graph, plot Y vs$.$ X and Z v$.$ X