Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Excel revision

Total questions: 20

Worksheet time: 11mins

Name
Class
Date
1.

What will clicking on the icon in the image do?

a)

Make the text size bigger

b)

Make the text colour red

c)

Make the cell background colour red

d)

Underline the text

2.

What will clicking on the icon in the image do?

a)

Make the text size bigger

b)

Make the text colour red

c)

Make the cell background colour red

d)

Underline the text

3.

What will clicking on the icon in the image do?

a)

Make the text size bigger

b)

Make the text colour red

c)

Make the cell background colour red

d)

Underline the text

4.

What will clicking on the icon in the image do?

a)

Make the text size bigger

b)

Make the text colour red

c)

Make the cell background colour red

d)

Underline the text

5.

Which format is best suited to display the price of an item?

a)

Percentage

b)

Number

c)

General

d)

Currency

6.

Which format is best suited to display visually the mark you received on a test that is out of 100?

a)

Percentage

b)

Number

c)

General

d)

Currency

7.

Which format is best suited to display a whole number including the thousands (comma) separator?

a)

Percentage

b)

Number

c)

General

d)

Currency

8.

In Excel, the cell C3 contains the formula =A3/B3. If I copy this and paste it into the cell D5, what will the formula for cell D5 be?

a)

=A3/B3

b)

=C3

c)

=A5/B5

d)

=B5/C5

9.

In Excel, the cell C3 contains the formula =$A3/$B3. If I copy this and paste it into the cell D5, what will the formula for cell D5 be?

a)

=$A3/$B3

b)

=$C3

c)

=$A5/$B5

d)

=$B5/$C5

10.

In Excel, the cell C3 contains the formula =$A$3/$B$3. If I copy this and paste it into the cell D5, what will the formula for cell D5 be?

a)

=$A$3/$B$3

b)

=$C$3

c)

=$A$5/$B$5

d)

=$B$5/$C$5

11.

Looking at the image, using a formula, what would the contents of E4 be?

(a)  

12.

Looking at the image, which formula would E6 have?

a)

B6+C6+D6

b)

=ADD(B6:D6)

c)

=SUM(B6:D6)

d)

=TOTAL(B6:D6)

13.

Looking at the image, using a formula, how would you calculate the average of the cell range B5 to D5?

(a)  

14.

What will clicking on Filter do?

a)

It will sort the data in alphabetical order

b)

It will hide the rows that meet a certain criteria

c)

It will find the first row that contains the data

d)

It will only show the rows that meet a certain criteria

15.

What will clicking on Sort A to Z do?

a)

It will sort the data in alphabetical order

b)

It will hide the rows that meet a certain criteria

c)

It will find the first row that contains the data

d)

It will only show the rows that meet a certain criteria

16.

Looking at the image, what part is circled in red?

a)

Chart

b)

Chart Title

c)

Data Labels

d)

Legend

17.

Looking at the image, what part is circled in red?

a)

Chart

b)

Chart Title

c)

Data Labels

d)

Legend

18.

Looking at the image, what part is circled in red?

a)

Chart

b)

Chart Title

c)

Data Labels

d)

Legend

19.

In the image, what type of chart is it?

(a)  

20.

What type of chart would be best suited to show the lowest and highest temperatures throughout the week on the same graph?

a)

Pie

b)

Line

c)

Bar

d)

Area