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
Lots of colour
A little colour to make it easier to read

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

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

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

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

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?
0.3,0.4,0.5,0.5,0.2,0.9
A,1, c,5, g, blue, monkey, seven,3
2,5,1,4,3,7,9,6,4,5,3,2,1

t < 10 min

User Rating:

2.74 von 5.0 - 58
Stimmen

12536 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

Rate this quiz!

Very bad   Very good
 
1 2 3 4 5

SheKnows

quizzes und tests   quizzen en tests