wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Multiple Choice Questions

Total questions: 35

Worksheet time: 18mins

Name
Class
Date
1.

The file extension of a LibreOffice Calc spreadsheet is:

a)

.docx

b)

.ods

c)

.pptx

d)

.xls

2.

Which icon is used to create a formula in Calc?

a)

Σ (Function Wizard)

b)

B

c)

I

d)

U

3.

The address of the cell located at column D and row 5 is:

a)

5D

b)

D5

c)

5-D

d)

D-5

4.

Which function returns the largest value from selected cells?

a)

SUM()

b)

AVERAGE()

c)

MAX()

d)

MIN()

5.

A range of cells from A1 to A10 is represented as:

a)

A1:A10

b)

A1#A10

c)

A1→A10

d)

A1|A10

6.

The shortcut key to paste content is:

a)

Ctrl + C

b)

Ctrl + X

c)

Ctrl + V

d)

Ctrl + P

7.

The bar that displays the active cell reference is called:

a)

Title Bar

b)

Status Bar

c)

Name Box

d)

Formula Bar

8.

By default, numbers are aligned to the:

a)

Left

b)

Right

c)

Center

d)

Top

9.

Which key permanently deletes selected data?

a)

Backspace

b)

Delete

c)

Spacebar

d)

Shift

10.

A formula in Calc begins with which symbol?

a)

@

b)

=

c)

$

d)

#

11.

The default number of sheets in a new spreadsheet is:

a)

1

b)

2

c)

3

d)

5

12.

To move to the next cell to the right, press:

a)

Tab

b)

Enter

c)

Shift + Tab

d)

Ctrl + Tab

13.

Which feature arranges data in ascending or descending order?

a)

Sort

b)

Filter

c)

AutoFill

d)

Format

14.

Which function is used to add values in selected cells?

a)

ADD()

b)

SUM()

c)

ADDING()

d)

PLUS()

15.

The intersection of a row and a column is called a:

a)

Cell

b)

Box

c)

Block

d)

Sheet

16.

The shortcut key to cut selected cells is:

a)

Ctrl + V

b)

Ctrl + C

c)

Ctrl + X

d)

Ctrl + B

17.

A group of cells selected together is called a:

a)

Sheet

b)

Row

c)

Range

d)

Box

18.

Which function returns the smallest value?

a)

MIN()

b)

MAX()

c)

LOW()

d)

SMALL()

19.

Short-cut key for saving a spreadsheet is:

a)

Ctrl + S

b)

Ctrl + X

c)

Ctrl + P

d)

Ctrl + F

20.

To combine multiple cells into one, we use:

a)

Split Cells

b)

Merge Cells

c)

Separate Cells

d)

Divide Cells

21.

A cell pointer highlights the:

a)

First cell

b)

Active cell

c)

Last cell

d)

Header cell

22.

Text in Calc is aligned by default:

a)

Left

b)

Right

c)

Center

d)

Justify

23.

A workbook contains:

a)

One cell

b)

Multiple worksheets

c)

Only numbers

d)

Headings only

24.

The SUM() function adds:

a)

Numbers only

b)

Text only

c)

Numbers & text

d)

Nothing

25.

The AutoFill feature helps in:

a)

Joining text

b)

Copying formulas

c)

Increasing RAM

d)

Formatting text

26.

Spreadsheets cannot store:

a)

Data

b)

Formulas

c)

Pictures

d)

Nothing (all can be stored)

27.

MIN() returns:

a)

Smallest value

b)

Largest value

c)

Average value

d)

Middle value

28.

Formatting cells mainly changes:

a)

Data meaning

b)

Data accuracy

c)

Data appearance

d)

Data deletion

29.

Which key combination is used to copy selected data?

a)

Ctrl + P

b)

Ctrl + V

c)

Ctrl + C

d)

Ctrl + D

30.

The horizontal divisions in a spreadsheet are called:

a)

Cells

b)

Rows

c)

Columns

d)

Sheets

31.

The vertical divisions in a spreadsheet are called:

a)

Sheets

b)

Columns

c)

Ranges

d)

Tables

32.

The collection of multiple worksheets is known as a:

a)

Workbook

b)

Folder

c)

Sheetbook

d)

Database

33.

Which function averages numeric values?

a)

AVGG()

b)

MEAN()

c)

AVERAGE()

d)

AVE()

34.

The row heading of the first row is:

a)

0

b)

A

c)

1

d)

R1

35.

A formula that adds A1 and B1 is:

a)

=A1+B1

b)

A1+B1=

c)

+A1+B1

d)

#A1+B1