IT Stuff

Excel Quiz

Question 1

Which cell is currently selected?

D10
3B
B3
No cell is selected

Correct answer: B3

Question 2

Which cell is currently selected?

A1
1A
B3
No cell is selected

Correct answer: A1

Question 3

Which cell is currently selected?

A1
E3
AH129
No cell is selected

Correct answer: AH129

Question 4

What formula would you put in D5 to work out the total?

B4+C4=
=B4+C4
=B5xC5
=B5*C5

Correct answer: =B5*C5

Question 5

What formula would you put in E5 to work out VAT (20%) on the total?

=B5xVAT
=D5*20%
=D5xVAT
=D5+20%

Correct answer: =D5*20%

Question 6

What formula would you put in F5 to work out total charge including VAT?

=F5+E5
=D5+20%
=D5*E5
=D5+E5

Correct answer: =D5+E5

Question 7

What does this button do?

Align cell contents to the left
Align cell contents to the right
Align cell contents to the top
Align cell contents to the bottom

Correct answer: Align cell contents to the left

Question 8

What does this button do?

Align cell contents to the left
Align cell contents to the right
Align cell contents to the top
Align cell contents to the bottom

Correct answer: Align cell contents to the top

Question 9

What does this button do?

Make a cell Bold
Apply a border
Change the font size
Apply shading to a cell

Correct answer: Bold

Question 10

What does this button do?

Make a cell Bold
Apply a border
Change the font size
Apply shading to a cell

Correct answer: Border

Question 11

Which format (or formats) would put a currency symbol (pound, dollar etc) before a number?

  • General
  • Number
  • Currency
  • Accounting

Correct answer: Currency and Accounting will both do this

Question 12

Which of these functions would add a column of numbers together?

Sum
Average
Max
Min

Correct answer: Sum

Question 13

Which of these functions would find the highest value in a cell range?

Sum
Average
Max
Min

Correct answer: Max

Scroll up to see answers



top of page