Spreadsheet Quiz

  1. Developed by: Mr Murphy

Short quiz designed to test your knowledge of spreadsheets

Question 1: What do we use Excel for?
Spreadsheets
Databases
Videos

Question 2: Which of the following will add two cells together?
A1+B1
=A1+B1
=A1-B1

Question 3: What should all formulas start with in Excel?
If
=
+

Question 4: What should a professional spreadsheet look like?
No colour
A little colour to make it easier to read
Lots of colour

Question 5: Which describes absolute cell referencing?
Never reference the same cell
Always reference the cell to the left
Always reference the same cell

Question 6: Which is an example of absolute cell referencing?
=A1-B1
=ŁAŁ1-B1
=$A$1-B1

Question 7: If we change a cell format to currency what can we do?
Make it display money
Make it show the time
Make it show colour

Question 8: Which best describe conditional cell formatting?
The colour changes depending on the results.
The results change depending on the colour
The colour stays the same in cells

Question 9: Which formula will add up lots of cells?
=A1: G1
=A1++G1
=A1(G1)

Question 10: Which data below could NOT be put into a chart?
2,5,1,4,3,7,9,6,4,5,3,2,1
0.3,0.4,0.5,0.5,0.2,0.9
A,1, c,5, g, blue, monkey, seven,3

t < 10 min

User Rating:

2.58 of 5.0 - 78
Votes

19678 taken
The quiz is developed on: 2009-02-01

Developed by:

  1. The flash version
  2. This Quiz on your Homepage?
  3. More quizzes from Mr Murphy?
  4. Quiz statistics
  5. More Knowledge Tests Trivia Tests Tests
  6. More Computer / Internet
  7. Change this quiz?
  1. Develop your own quiz
  2. Mail this website to your friends
  3. Report illegal content

Rate this quiz!

Very bad   Very good
 
1 2 3 4 5

partner: SheKnows

quizzes und tests   quizzen en tests