wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Form 2 CL

Total questions: 65

Worksheet time: 22mins

Name
Class
Date
1.

What is the next column letter after "Z"?

a)

A

b)

ZA

c)

AA

d)

No such column letter

2.

A pie chart is used to

a)

show a trend over a period of time

b)

show the average value of some categoreis of data

c)

show the difference between the smallest and the largest values in a set of data

d)

show the proportions of different categories of data

3.

Sort the numbers 15, 27, 15, 8, 15, 7 in ascending order

a)

7, 8, 15, 27

b)

7, 8, 15, 15, 15, 27

c)

27, 15, 8, 7

d)

27, 15, 15, 15, 8, 7

4.

Sort the numbers 15, 27, 15, 8, 15, 7 in descending order

a)

7, 8, 15, 27

b)

7, 8, 15, 15, 15, 27

c)

27, 15, 8, 7

d)

27, 15, 15, 15, 8, 7

5.

It is known that cell A1 stores number. But why does it show "####" instead of a number?

a)

The cell is not wide enough to show the numner

b)

The number stores in the cell is a fraction

c)

The cell is locked

d)

The cell is blank

6.

Which of the following spreadsheet formulae can calculate the square of the value stored in cell B7?

a)

=B7*B7

b)

=2^B7

c)

=SQRT(B7)

d)

=B7*2

7.

Which of the following formulae CANNOT add up the values stored in cells C4, C5 and C6?

a)

=C6+C5+C4

b)

=SUM(C4:C6)

c)

=SUM(C6, C5, C4)

d)

=SUM(C4!C6)

8.

Which of the following spreadsheet formulae can correct the number 34.5 to its nearest integer?

a)

=round(34.5,0)

b)

=round(0, 34.5)

c)

=round(34.5,1)

d)

=round(34.5, -1)

9.

Worksheet

a)

An area that contains cells for data input in a spreadsheet

b)

A basic storage unit of a spreadsheet

c)

A graphical way to present the relationship between data

d)

Formed by a column letter and a row number

10.

Cell address

a)

An area that contains cells for data input in a spreadsheet

b)

A basic storage unit of a spreadsheet

c)

A graphical way to present the relationship between data

d)

Formed by a column letter and a row number

11.

Chart

a)

An area that contains cells for data input in a spreadsheet

b)

A basic storage unit of a spreadsheet

c)

A graphical way to present the relationship between data

d)

Formed by a column letter and a row number

12.

Cell

a)

An area that contains cells for data input in a spreadsheet

b)

A basic storage unit of a spreadsheet

c)

A graphical way to present the relationship between data

d)

Formed by a column letter and a row number

13.

Line chart

a)

Good at showing the distribution of a large number of data

b)

Good at comparing the proportions of various categories of data

c)

Good at showing a trend over a period of time

d)

Good at comparing data in different categories

14.

Plot area

a)

The name of an axis that makes a chart easier to understand

b)

The name of a whole chart that makes the chart easier to understand

c)

The function which adds or changes chart elements or formatting the chart

d)

The rectangular area that shows the graphical data on a chart

15.

Chart Layout

a)

The name of an axis that makes a chart easier to understand

b)

The name of a whole chart that makes the chart easier to understand

c)

The function which adds or changes chart elements or formatting the chart

d)

The rectangular area that shows the graphical data on a chart

16.

Chart Title

a)

The name of an axis that makes a chart easier to understand

b)

The name of a whole chart that makes the chart easier to understand

c)

The function which adds or changes chart elements or formatting the chart

d)

The rectangular area that shows the graphical data on a chart

17.

Axis Title

a)

The name of an axis that makes a chart easier to understand

b)

The name of a whole chart that makes the chart easier to understand

c)

The function which adds or changes chart elements or formatting the chart

d)

The rectangular area that shows the graphical data on a chart

18.

Row heading

a)

Rows are numbered from 1 to 1,048,576.

b)

Columns are lettered from A to Z and then from AA to XFD.

c)

Display the content or the formula of the selected cell.

d)

Display the cell address of the selected cell.

19.

Column heading

a)

Rows are numbered from 1 to 1,048,576.

b)

Columns are lettered from A to Z and then from AA to XFD.

c)

Display the content or the formula of the selected cell.

d)

Display the cell address of the selected cell.

20.

Name box

a)

Rows are numbered from 1 to 1,048,576.

b)

Columns are lettered from A to Z and then from AA to XFD.

c)

Display the content or the formula of the selected cell.

d)

Display the cell address of the selected cell.

21.

Formula bar

a)

Rows are numbered from 1 to 1,048,576.

b)

Columns are lettered from A to Z and then from AA to XFD.

c)

Display the content or the formula of the selected cell.

d)

Display the cell address of the selected cell.

22.

Data can be arranged in a worksheet in a easy to understand manner using

a)

auto formatting

b)

applying styles

c)

changing fonts

23.

Why might charts and graphs be a way of making the data in a spreadsheet easier to understand?

a)

Because primary school children can use bar charts.

b)

Because the data is presented in a more visual way.

c)

Because they don't require you to enter any formula.

24.

Wrap text is an option which can be applied to cells in order to do what?

a)

Put a border around a cell containing text

b)

Put a background on a cell containing text

c)

Resize a cell to fit the text inside

25.

What term describes changing the horizontal or vertical position of text?

a)

Font

b)

Alignment

c)

Format

26.

You want to track the progress of the stock market on a daily basis. Which type of chart should you use?

a)

Pie chart

b)

Row chart

c)

Line chart

d)

Column chart

27.

To create a formula, you first:

a)

Select the cell you want to place the formula into

b)

Type the equals sign (=) to tell Excel that you’re about to enter a formula

c)

Enter the formula using any input values and the appropriate mathematical operators that make up your formula

d)

Choose the new command from the file menu

28.

When a word is too long to fit within a worksheet cell, you typically must

a)

Shorten the word

b)

Increase the column width

c)

Decrease the column width

d)

Adjust the row height

29.

Excel files have a default extension of

a)

docx

b)

xlw

c)

txt

d)

xlsx

30.

Sort & Filter

a)

Letters arranged from A to Z

b)

Arranging data from the largest to the smallest.

c)

A button that can be used to sort and filter data in a worksheet

d)

Arranging data from the smallest to the largest.

e)

Making hidden columns or rows visible

31.

Unhide

a)

Letters arranged from A to Z

b)

Arranging data from the largest to the smallest.

c)

A button that can be used to sort and filter data in a worksheet

d)

Arranging data from the smallest to the largest.

e)

Making hidden columns or rows visible

32.

Ascending order

a)

Letters arranged from A to Z

b)

Arranging data from the largest to the smallest.

c)

A button that can be used to sort and filter data in a worksheet

d)

Arranging data from the smallest to the largest.

e)

Making hidden columns or rows visible

33.

Descending order

a)

Letters arranged from A to Z

b)

Arranging data from the largest to the smallest.

c)

A button that can be used to sort and filter data in a worksheet

d)

Arranging data from the smallest to the largest.

e)

Making hidden columns or rows visible

34.
‘Dog’ appears before ‘Dolphin’ when the two words are sorted in descending order.
a)
true
b)
false
35.
A chart cannot be resized once it is created.
a)
true
b)
false
36.
A condition must be provided in a formula containing COUNTIF() function.
a)
true
b)
false
37.
A pie chart is good at showing a trend over a period of time.
a)
true
b)
false
38.
An IP address can only be represented in dotted-decimal notation.
a)
true
b)
false
39.
An IP address is used for identifying uniquely a device on the Internet.
a)
true
b)
false
40.
An IPv6 address can simply be called an IP address.
a)
true
b)
false
41.
Domain names are developed to replace IPv4 addresses.
a)
true
b)
false
42.
Each 32-bit IP address contains 4 bytes.
a)
true
b)
false
43.
Each cell address is formed by a column letter and a row number.
a)
true
b)
false
44.
Each piece of data in a spreadsheet is stored in a basic storage unit called a worksheet.
a)
true
b)
false
45.
Font size in a chart changes after the chart has been resized.
a)
true
b)
false
46.
Formulae in a spreadsheet can be used for doing statistical analysis.
a)
true
b)
false
47.
If a column in a spreadsheet is hidden, the content in the cells in that column will be deleted.
a)
true
b)
false
48.
In Microsoft Excel 2007, a function can be placed inside another function.
a)
true
b)
false
49.
In Microsoft Excel 2007, spaces cannot be inserted between a number and an operator in a formula.
a)
true
b)
false
50.
IPv6 is the most commonly used version of IP addresses nowadays.
a)
true
b)
false
51.
Mathematical functions in a spreadsheet usually return numerical results.
a)
true
b)
false
52.
The ‘*’ symbol is a comparison operator in Microsoft Excel 2007.
a)
true
b)
false
53.
The ‘=’ operator can only be used in spreadsheet formulae that deal with numbers.
a)
true
b)
false
54.
The ‘Hide’ function can make a cell invisible.
a)
true
b)
false
55.
The column width can be adjusted by dragging the position where two column headings meet.
a)
true
b)
false
56.
The COUNTA() function is used for finding the number of blank cells within a cell range.
a)
true
b)
false
57.
The expression ‘"Big dog"<"Small cat"’ returns TRUE.
a)
true
b)
false
58.
The formula ‘=MAX(A1,B2:C5)’ is valid in Microsoft Excel.
a)
true
b)
false
59.
The Internet is a global system of interconnected computer networks that consists of a lot of computers.
a)
true
b)
false
60.
The meaning of the ‘<=’ operator is ‘smaller than or equal to’.
a)
true
b)
false
61.
The spreadsheet formula ‘=ROUND(46.78, 1)’ returns 47.
a)
true
b)
false
62.
The spreadsheet formula ‘=SUM(A1:A3)’ can be used for adding up the values stored in cells A1 to A3.
a)
true
b)
false
63.
We can make specific rows or columns visible while scrolling the worksheet by using the ‘Sort & Filter’ button.
a)
true
b)
false
64.
www.google.com is an example of domain name.
a)
true
b)
false
65.
You can make a chart in Excel 2007 using the ‘Charts’ group on the ‘Insert’ tab.
a)
true
b)
false

Similar Resources on Wayground

ÔN TẬP TIN LỚP 5 HK2

63 questions

ÔN TẬP TIN LỚP 5 HK2

quiz

Worksheet

•

4th Grade

Módulos 4 – 7: Examen de conceptos Ethernet

66 questions

Módulos 4 – 7: Examen de conceptos Ethernet

quiz

Worksheet

•

1st - 5th Grade

Preparing for MTA Certification

60 questions

Preparing for MTA Certification

quiz

Worksheet

•

KG - University

Ôn tập KSTA4

60 questions

Ôn tập KSTA4

quiz

Worksheet

•

4th - 5th Grade

Internet Safety

63 questions

Internet Safety

quiz

Worksheet

•

1st - 5th Grade

9_Kurmer.BLog & Vlog

60 questions

9_Kurmer.BLog & Vlog

quiz

Worksheet

•

3rd Grade

Internet Safety for Elementary

70 questions

Internet Safety for Elementary

quiz

Worksheet

•

1st - 5th Grade

tin hoc lop 4

66 questions

tin hoc lop 4

quiz

Worksheet

•

4th Grade