Name:    
 
Email: 

MS Excel Quiz

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

nr005-1.jpg

 

 6. 

Calculate in Excel using the numbers in the “Numbers” column.:

A2 + A15 x A25

 

 7. 

Calculate x using Excel:

4x2 = 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 ___
 



 
         Start Over