wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

OPENOFFICE CALC

Total questions: 18

Worksheet time: 22mins

Name
Class
Date
1.

A horizontal set of cells

a)

Column

b)

Row

c)

Table

d)

Cell

2.

A vertical set of cells.

a)

Column

b)

Row

c)

Table

d)

Worksheet

3.

A single data element in a spreadsheet

a)

Column

b)

Row

c)

Cell

d)

Table

4.

How many total rows are there in LibreOffice Calc?

a)

1024

b)

1048576

c)

16384

d)

None of Above

5.

How many total columns are there in LibreOffice Calc?

a)

1024

b)

1048576

c)

16384

d)

None of Above

6.

What is the shortcut command to open a new file in LibreOffice Calc?

a)

Ctrl + N

b)

Ctrl + M

c)

Ctrl + Shift + N

d)

None of Above

7.

What is a spreadsheet in a LibreOffice?

a)

Draw

b)

Impress

c)

Calc

d)

Writer

8.

THE __________ FUNCTION IS USED TO FIND THE MAXIMUM VALUE FROM A SET OF VALUES

a)

MAX( )

b)

MIN( )

9.

A ___________ IS AN EQUATION TO SOLVE A MATHMATICAL PROBLEM.

a)

FUNCTION

b)

FORMULA

c)

CELL

d)

ROW

10.

A SELECTED CELL IS HIGHLIGHTED IN THE SHEET AND IT IS CALLED _________

a)

CELL

b)

SELECTED RANGE

c)

ACTIVE CELL

d)

NONE

11.
Cells that run horizontally on a spreadsheet
a)
Row
b)
Column
c)
Workbook
d)
Range
12.
Cells that run vertically on a spreadsheet
a)
Row
b)
Workbook
c)
Worksheet
d)
Column
13.
All functions and formulas begin with which symbol?
a)
#
b)
/
c)
:
d)
=
14.
The intersection of a column and a row is called a ______.
a)
gridline
b)
cell
c)
value
d)
formula
15.
A group of cells in a spreadsheet
a)
Cell reference
b)
Cell range
c)
Active cells
d)
Formulas
16.
Which of the following is a FORMULA that will add cells c9 and c10?
a)
=c9+c10
b)
c9+c10
c)
sum(c9:c10)
d)
=sum(c9:c10)
17.
Which of the following is a FORMULA that will add cells c9 and c10?
a)
=c9+c10
b)
c9+c10
c)
sum(c9:c10)
d)
=sum(c9:c10)
18.
Rows on a spreadsheet are identified by a ...
a)
number
b)
letter
c)
symbol
d)
smiley face