Excel Sections 1.1-1.4

Question 1

Which formula calculates the largest value in the sheet below?

Accepted Answer

=MAX(A1:E5)

Question 2

Which commands would select all the values in column E?

Accepted Answer

=E1:E5

Question 3

The formula "$C$3" anchors formulas to row 3 only, but will allow the column to change.

Accepted Answer

False

Question 4

Which formula correctly calculates the value of 62?

Accepted Answer

=POWER(6,2)

Question 5

Which formula calculates the value of π/4?

Accepted Answer

=PI()/4

Question 6

Which cell contains "Sustainability"?

Accepted Answer

E3

Question 7

Trigonometry functions in Excel complete the operation on a number in units of radians.

Accepted Answer

True

Question 8

What is the numerical value produced by the formula: "=A2+B4*A5"?

Accepted Answer

202

Questions 8