Multiple Choice Identify the
choice that best completes the statement or answers the question.


1.

Format the “Numbers” column so that numbers bigger than 500 are RED
and numbers less than 500 are BLUE. What is the colour of the “Numbers” cell in
A1?
a.  Red  c.  White  b.  Blue  d.  It will not change
colour. 

Numeric Response


2.

What does 1.23E+4 mean?


3.

Use Excel to calculate the average of the numbers in the column
“Numbers.”


4.

In the column “Numbers,” how many numbers are bigger than
458?


5.

Calculate in Excel if x = 1.25


6.

Calculate in Excel using the numbers in the “Numbers”
column.:
A2 + A15 x A25


7.

Calculate x using Excel:
4x^{2} = 19813 + 13479


8.

Use the STDEV function in Excel on these numbers to get the answer. (You
don’t need to know what it means... just do
it.)
1 2 3 4 5 6 7 8 9 10


9.

Graph y vs x. What is the slope of the trend line? (best fit line)


10.

Graph y vs x. What is the axis scale? (Don’t change it yourself)


11.

G1 = 1 G2 = 3 G3 = 2 Fill down and let Excel continue the
pattern. G100 = ?


12.

Sort the “Words” column from A to Z.
The word
“the” will appear in which row number?


13.

The Pie Chart shows 4 groups of people. How many people are in Group
1?

Short Answer


14.

The Pie Chart was made using a table with 4 numbers. The table is somewhere
in the Excel Sheet. Where is the table?
Column ___ Row ___
