Digital Spreadsheet-Class 9

Write the output of the following:

=COUNT(A1:A3,C1:C3)

• a. 2

• b. 4

• c. 6

• d. 8

Spreadsheet is used for :

• a. Managing financial and accounting documents.

• b. Creating data reports.

• c. Data analysis

• d. All of the above.

Chart option is available in______menu.

• a. Insert

• b. Format

• c. Edit

• d. Sheet

Which of the following is an example of absolute referencing?

• a. $A$1

• b. $A1$

• c. Both of the above

• d. None of the above

In which of the following referencing, the cell address remains unchanged even after dragging in any direction?

• a. Mixed

• b. Absolute

• c. Relative

• d. None of these

Default name of spreadsheet open in LibreOffice Calc is _______

• a. Untitled X, where X is a number

• b. Calc X, where X is a number

• c. Spreadsheet X, where X is a number

• d. None of the above

When you drag formula =A$7 downward then_________.

• a. only row number will change

• b. only column heading will change

• c. both row number and column heading will change

• d. None of these

By default _____________ sheets is/are present in LibreOffice Calc Spreadsheet.

• a. 1

• b. 2

• c. 3

• d. 4

In LibreOffice Calc, Row headings are in ________________

• a. Numbers

• b. Alphabets

• c. Alphanumeric

• d. None of the above

When the values of the cells mentioned in the formula changes then the results obtained from a formula also get updated automatically.

• a. True

• b. False