Experimental Design & Practice 1 (Excel Training)

Question 1

Formula:

Answer 1

always begin with =
if ignored then entry treated as a text entry

Question 2

Arithmetic Operators include:

Answer 2

*
/

()

same precedence as on a cal (BIDMAS)

Question 3

Excel has host of other functions found on scientific calc, such as:=

Answer 3

=EXP(C2)
=SQRT(Q12)
=10RAND()
=INT(10RAND())
=SIN(PI()/2)
=LN()

Question 4

some functions require more than just one argument, examples:

Answer 4

=AVERAGE(C1,C2,C3,C4)
=MAX(12,34,56,32,12)
=SUM(A1:A5)
=MIN(A1:C3)

Question 5

Relative Cell Address

If cell A3=A2*2 is copied, what is the output in cell C3

Answer 5

These are relative cell addresses, so excel will adjust the cell address as it is moved to a different location

so whatever is in C2 is also multiplied by 2 and displayed in C3

Question 6

Absolute Cell Address

If cell A3 =$A$2*2 is copied to all other cells what is the output in cell C3

Answer 6

$ symbols denote absolute cell addresses, so the formula remains unchanged as it is moved to a different location.

so whatever is in A3 is also now in C3

Question 7

Plotting Graphs (procedure):

Answer 7

-Highlight data and select create new chart
-Single column against simple uniform step, bar charts, pie chart, etc.
-At least 2 columns of data to plot a scatter or X-Y chart.