wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

ICDL Excel

Total questions: 40

Worksheet time: 20mins

Name
Class
Date
1.

Which of the following would make this spreadhsheet easier to read?

a)

Sorting the data

b)

adding images

c)

adding sound

d)

linking the data

2.

Which of the following is correctly formatted?

a)
b)
c)
d)
3.

How do you set up a list correctly?

a)
b)
c)
d)
4.
In Excel rows are labeled by
a)
letters
b)
numbers
c)
rows and numbers
5.
In excel, columns are labeled by
a)
Letters
b)
Numbers
c)
Letters and numbers
6.
What button will add up a group of numbers
a)
Equals button
b)
Plus symbol button
c)
Auto-sum button
7.
Excel refers to files as
a)
Documents
b)
Workbooks
c)
data bases
8.
Where rows and columns meet are referred to as
a)
Blocks
b)
Cells
c)
Boxes
9.
When inserting a formula, always start with
a)
equals symbol
b)
plus symbol
c)
minus symbol
10.
What kind of chart should you use to show the pieces (percentages) of a whole
a)
Bar Chart
b)
Column Chart
c)
Pie Chart
11.
To see what math formulas are used in a cell, click on the
a)
Show formulas button
b)
Show the math button
c)
the auto sum button
12.
What key should you use to take you to the cell to the right
a)
Tab key
b)
Right arrow key
c)
just click in it
13.
To allow you to evenly distribute a title over a table of numbers, use the
a)
Center button
b)
Merge and Center button
c)
Merge cells only button
14.
If you see a series of "######" in a cell, that means the following:
a)
You keyed in an incorrect number
b)
The row height is too high
c)
The text is incorrectly spelled
d)
The column width is not wide enough
15.
You can only work in one cell at a time. The actual cell that you are working in is called what?
a)
Column
b)
Name Box
c)
Active Cell
d)
Row
16.
Cells are identified by the following:
a)
Column Letter followed by their Row Number
b)
Row Number followed by their Column Letter
c)
Row Number Only
d)
Column Letter Only
17.
Which of the following would make the data in the image easier to read?
a)
Sorting the Data
b)
Sorting the numbers
c)
Sorting the letters
18.

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

19.

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

20.

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

21.

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

a)

Percentage

b)

Number

c)

General

d)

Currency

22.

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

23.

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

a)

Percentage

b)

Number

c)

General

d)

Currency

24.

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

25.

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

26.

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

27.

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

(a)  

28.

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)

29.

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

(a)  

30.

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

a)

Chart

b)

Chart Title

c)

Data Labels

d)

Legend

31.

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

a)

Chart

b)

Chart Title

c)

Data Labels

d)

Legend

32.

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

a)

Chart

b)

Chart Title

c)

Data Labels

d)

Legend

33.

In the image, what type of chart is it?

(a)  

34.
What is the FUNCTION that will add cells D14, D15, D16, D17, D18, and D19?
a)

=sum(D14:D19)

b)

=D14:d19

c)

=sum(D14-D19)

d)

=D14+D15+D16+D17+D18+D19

35.

What does this tool do?

a)

Add a table

b)

Add a border

c)

Add a Pie chart

d)

Add an image

36.

Fill in the missing word 'To add a pie chart I go to the (a)   tab'

37.

What Cell have I selected

a)

A4

b)

B5

c)

C5

d)

D5

e)

B6

38.

What is the tool used for?

a)

Change colour of Text

b)

Change colour of the Cell (Box)

c)

Fill the whole sheet

39.

Every chart must have a

a)

chart name

b)

chart title

c)

chart slogan

d)

chart word

40.
Error in your formula
a)
#div/0!
b)
AutoFill
c)
#name?
d)
Columns 

Similar Resources on Wayground

LPI Linux Essentials (40 Questions)

40 questions

LPI Linux Essentials (40 Questions)

quiz

Worksheet

•

Professional Development

SIMULASI DIGITAL - X

40 questions

SIMULASI DIGITAL - X

quiz

Worksheet

•

KG - Professional Dev...

Data Preprocessing - 1

40 questions

Data Preprocessing - 1

quiz

Worksheet

•

Professional Development

HTML CSS JS

43 questions

HTML CSS JS

quiz

Worksheet

•

Professional Development

Pre_Place_Batch_2027_SET_F

40 questions

Pre_Place_Batch_2027_SET_F

quiz

Worksheet

•

Professional Development

Foundation_Batch_2025

40 questions

Foundation_Batch_2025

quiz

Worksheet

•

Professional Development

Java Script

39 questions

Java Script

quiz

Worksheet

•

9th Grade - Professio...

HTML and CSS

36 questions

HTML and CSS

quiz

Worksheet

•

University - Professi...