query_builder

You have started a time-based quiz! Pay attention to the displayed countdown.

Knowledge / Trivia tests -» Computers / Internet -» Software

Spreadsheet Quiz

10 Questions - Developed by: - Developed on: 2009-02-01 - 79,055 taken - User Rating: 2.6 of 5 - 96 votes - 36 people like it

Short quiz designed to test your knowledge of spreadsheets

1

What do we use Excel for?

Spreadsheets
Videos
Databases

2

Which of the following will add two cells together?

=A1-B1
A1+B1
=A1+B1

3

What should all formulas start with in Excel?

+
If
=

4

What should a professional spreadsheet look like?

Lots of colour
A little colour to make it easier to read
No colour

5

Which describes absolute cell referencing?

Always reference the cell to the left
Never reference the same cell
Always reference the same cell

6

Which is an example of absolute cell referencing?

=$A$1-B1
=£A£1-B1
=A1-B1

7

If we change a cell format to currency what can we do?

Make it show colour
Make it show the time
Make it display money

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

9

Which formula will add up lots of cells?

=A1: G1
=A1(G1)
=A1++G1

10

Which data below could NOT be put into a chart?

0.3,0.4,0.5,0.5,0.2,0.9
2,5,1,4,3,7,9,6,4,5,3,2,1
A,1, c,5, g, blue, monkey, seven,3

Comments (4)

soulless male (11734)

382 days ago

Q9 Has wrong answers

THANOS (05180)

1611 days ago

Q9 Does work the answer is A1: G1

joe (87187)

1720 days ago

q9 has wrong answers for everyone of them

MrAco (82181)

2528 days ago

Question 9 appears to have only wrong answers...

•1•