Libre Office Calc — Practice

Question 1

The function that returns the smallest value is ____.

Accepted Answer

MIN.

Question 2

The character used to join text in a formula is the ____.

Accepted Answer

ampersand (&).

Question 3

The function used to count cells that contain numbers is ____.

Accepted Answer

COUNT.

Question 4

Every formula in Calc begins with the ____ sign.

Accepted Answer

= (equals).

Question 5

What is the use of the SUM function? Give an example.

Accepted Answer

SUM adds up a set of values; for example =SUM(A2:A6) gives the total of the numbers in cells A2 to A6.

Question 6

What is the purpose of a chart in Calc?

Accepted Answer

A chart turns numerical data into a picture (bar, pie or line) so that trends and comparisons are easier to understand.

Practice — Libre Office Calc