wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Electronic Spreadsheet Class 10 Quiz

Total questions: 66

Worksheet time: 33mins

Name
Class
Date
1.

What is the extension of a spreadsheet file in Calc?

a)

.ods

b)

.odg

c)

.odt

d)

.odb

2.

The LibreOffice Calc can perform _.

a)

Calc can create link

b)

Calc can share and review data

c)

All of the above

d)

Analysis automate repeated tasks

3.

Which of the following software is best for data analysis?

a)

None of the above

b)

LibreOffice Impress

c)

LibreOffice Calc

d)

LibreOffice Writer

4.

__ is a function which combines data from multiple sheets and summarizes the information in one place.

a)

Consolidating Data

b)

SubTotal

c)

Solver

d)

Goal Seek

5.

__ compare a variety of data in a single spreadsheet to identify relationships and trends.

a)

Goal Seek

b)

SubTotal

c)

Solver

d)

Consolidating Data

6.

What we need to check before consolidating data in LibreOffice Calc?

a)

Match the levels from all the sheets

b)

All of the above

c)

Data types must match

d)

First column should be primary column

7.

Which option you will select to open Data Consolidation?

a)

Data > Consolidate

b)

Insert > Consolidate

c)

View > Consolidate

d)

None of the above

8.

Which function cannot be performed through Subtotal in a Spreadsheet?

a)

Sum

b)

Product

c)

Percentage

d)

Average

9.

Scenarios are a tool to test questions.

a)

Auto

b)

Goal Seek

c)

What-if

d)

Drop Down

10.

_ means combining data in a spreadsheet from different worksheets into master worksheet.

a)

Consolidating

b)

Linking

c)

Filter

d)

Hyperlinks

11.

What is the shortcut key used for opening the consolidated dialog window?

a)

None of the above

b)

Shift + D

c)

Alt + D

d)

Ctrl + D

12.

If you want to consolidate the sheet by matching the label, which option will be helpful?

a)

Copy result to

b)

Using source data area

c)

None of the above

d)

Row label and Column label

13.

What does 'Copy result to' mean when it comes to data consolidation?

a)

None of the above

b)

Insert the formula for finding data consolidation

c)

Adding all address of consolidation data

d)

Specify where you want to display the result

14.

Which of the following options is used to update the data of the consolidated sheet automatically?

a)

Link to source data

b)

Column labels

c)

All of the above

d)

Row labels

15.

If you want to consolidate the data by matching the label which option you will select?

a)

Link to source data

b)

Row label and Column labels

c)

None of the above

d)

Consolidation ranges

16.

The consolidated sheet will have all the consolidated data along with the original data, if you want to view original data of both the sheets then you can click on _.

a)

- Sign

b)

/ Sign

c)

+ Sign

d)

* Sign

17.

_________ is a spreadsheet function that is designed to minimize or maximize a result based on a set of rules that you describe.

a)

Subtotal

b)

Solver

c)

Scenario

d)

Goal Seek

18.

In LibreOffice Calc, if you want to collapse to hide data you can click on the _ sign.

a)

* Sign

b)

- Sign

c)

+ Sign

d)

/ Sign

19.

In LibreOffice Calc, if you want to expand data you can click on the _ sign.

a)

+ Sign

b)

- Sign

c)

* Sign

d)

/ Sign

20.

In LibreOffice Calc, if you want to group the data you can select.

a)

Data > Group and Outline

b)

View > Group and Outline

c)

Insert > Group and Outline

d)

None of the above

21.

In LibreOffice Calc, the Subtotal tool creates the group of data __.

a)

Automatically

b)

Manually

c)

Using Total function

d)

None of the above

22.

Which option you will use to open Subtotal in LibreOffice Calc?

a)

Insert > Subtotal

b)

Data > Subtotal

c)

View > Subtotal

d)

Edit > Subtotal

23.

In LibreOffice Calc Subtotal is used to __.

a)

Allows easily to sort data automatically

b)

Group Subtotal by category

c)

Both a) and b)

d)

None of the above

24.

Subtotal tool can create subtotal for up to _ arrays arranged in Labeled columns.

a)

Six

b)

Five

c)

Four

d)

Three

25.

Which of the following tools is used to display hierarchical structure of the data?

a)

Solver

b)

Scenario

c)

Subtotal

d)

Goal Seek

26.

In the Subtotal tool data can be sorted in the following order.

a)

None of the above

b)

Both a) and b)

c)

Descending Order

d)

Ascending Order

27.

If you want to remove the outline feature from the sheet then you can use.

a)

View > Group and Outline > Remove Outline

b)

None of the above

c)

Data > Group and Outline > Remove Outline

d)

Insert > Group and Outline > Remove Outline

28.

__ is a set of values that can be used within the calculations.

a)

Sub Total

b)

Scenario

c)

None of the above

d)

Goal Seek

29.

We can shift from one scenario to another by _

a)

None of the above

b)

Data Source

c)

Find and Replace

d)

Navigator

30.

Default name of first scenario created in Sheet1 of Calc is __.

a)

Sheet1_Scenario_1

b)

Sheet_1_Scenario_1

c)

Sheet_1_Scenario1

d)

Sheet1_Scenario1

31.

Why what-if analysis tool is used in LibreOffice Calc?

a)

None of the above

b)

To create a style

c)

Depend on different input values and their impact on result

d)

To check the error

32.

Which of the following will not be considered as a What-if analysis tool in LibreOffice Calc?

a)

Goal Seek

b)

Scenario

c)

Solver

d)

None of the above

33.

Which tools used to explore and compare various alternatives depending on changing conditions?

a)

None of the above

b)

Scenario

c)

Solver

d)

Goal Seek

34.

__ is a more elaborate form of Goal Seek.

a)

All of the above

b)

Subtotal

c)

Scenario

d)

Solver

35.

In LibreOffice Calc several scenarios can be created on the same sheet. (True/ False)

a)

True

b)

False

c)

Maybe

d)

Not sure

36.

Which of the following tool is used to predict the output while changing the input?

a)

None of the above

b)

Subtotal

c)

Consolidation of Data

d)

Scenarios

37.

How you will open scenarios dialog box from the menu bar?

a)

None of the above

b)

Data > Scenarios

c)

Tools > Scenarios

d)

Edit > Scenarios

38.

__ tools creates a formula array to display the list of results.

a)

Subtotal

b)

Solver

c)

Goal Seek

d)

Multiple Operation

39.

Which of the following tools is also known as a planning tool for what-if questions?

a)

Solver

b)

Multiple Operation

c)

Subtotal

d)

Goal Seek

40.

How you will open Multiple Operations from the menu bar?

a)

Data > Multiple Operations

b)

None of the above

c)

Edit > Multiple Operations

d)

Tools > Multiple Operations

41.

The Multiple Operations tool is used to create __ arrays of cells.

a)

5

b)

4

c)

3

d)

2

42.

How to open the Goal Seek dialog box from the LibreOffice Calc menu bar?

a)

None of the above

b)

Tools > Goal Seek

c)

View > Goal Seek

d)

Insert > Goal Seek

43.

__ helps in finding out the input for the specific output.

a)

Scenario

b)

Solver

c)

None of the above

d)

Goal Seek

44.

A _ is a single instruction that executes a set of instructions.

a)

All of the above

b)

Goal Seek

c)

Macro

d)

Solver

45.

_ tools help to create a sequence of commands or keystrokes that can be used for any number of times later.

a)

Macro

b)

Solver

c)

All of the above

d)

Goal Seek

46.

Macro recording can be enabled using the _ options in LibreOffice Calc.

a)

Data > Macros

b)

Edit > Macros

c)

View > Macros

d)

Tools > Macros

47.

Which of the following actions is not recorded by the Macro?

a)

All of the above

b)

Actions carried out using mouse

c)

Window switching

d)

Opening of windows

48.

What is the default name of Macro in LibreOffice Calc?

a)

Macro

b)

Main

c)

New

d)

None of the above

49.

The name of macro by default is saved in the _.

a)

Standard Library in Module 1

b)

Use new extension

c)

In LibreOffice writer

d)

None of the above

50.

In LibreOffice Calc, A library is a collection of _.

a)

Words

b)

Row & Column

c)

None of the above

d)

Modules

51.

While naming a Macro, Module or a Library the name should be __.

a)

Begin with a letter

b)

Not contain space

c)

Not contain special characters except underscore

d)

All of the above

52.

Which of the following is an invalid Macro Name?

a)

format*word

b)

1formatword

c)

format word

d)

Format_word

53.

To run a macro we need to click on __.

a)

Tools > Macros > Run Macro

b)

View > Macros > Run Macro

c)

Edit > Macros > Run Macro

d)

Data > Macros > Run Macro

54.

If some formula you want to apply in spreadsheet and there is no predefined formula for it, what you will do?

a)

None of the above

b)

Create formula

c)

Use a manual calculation

d)

Create a Macro

55.

Macro works like a __.

a)

Function

b)

Operator

c)

None of the above

d)

Parameters

56.

The macro’s recorded activity is stored as instructions in the __ programming language.

a)

C

b)

DBMS

c)

BASIC

d)

Java

57.

The code of a macro begins with Sub followed by the name of the macro and ends with _.

a)

None of the above

b)

Close Sub

c)

End Sub

d)

Exit Sub

58.

How you will add comments in the macro programming code?

a)

Using double quote

b)

Using single quote

c)

Using double slash

d)

Using Hash

59.

To add a new sheet in the spreadsheet, click on the __.

a)

(+) sign located in the left button

b)

(+) sign located in the right button

c)

(-) sign located in the left button

d)

(-) sign located in the right button

60.

You can insert a new sheet in LibreOffice Calc using which of the following menu options?

a)

All of the above

b)

View > Insert Sheet

c)

Edit > Insert Sheet

d)

Sheet > Insert Sheet

61.

To refer to a cell in another sheet precede the cell reference with __ sign.

a)

$ Sign

b)

@ Sign

c)

None of the above

d)

% Sign

62.

When the cell refers to the other sheet __ are used as there is a space between the sheet name.

a)

' '

b)

.

c)

=

d)

*

63.

In LibreOffice Calc hyperlink can be either _ or .

a)

None of the above

b)

Alternate Link or Mailto

c)

Relative Hyperlink or Absolute Hyperlink

d)

External Hyperlink or Anchor Hyperlink

64.

In LibreOffice Calc it is possible to jump from one sheet to another spreadsheet or a website by creating __.

a)

All of the above

b)

Linking

c)

Using Jump

d)

Hyperlinks

65.

_ hyperlink stores the complete location of the file.

a)

Both a) and b)

b)

Relative Hyperlinks

c)

Absolute Hyperlinks

d)

None of the above

66.

In absolute hyperlink if the file is removed from location to another then absolute hyperlink will _.

a)

Both a) and b)

b)

Work properly

c)

Not work

d)

None of the above

Similar Resources on Wayground

System Attacks Quiz

61 questions

System Attacks Quiz

quiz

Worksheet

•

10th Grade

Sumatif Tengah Semester

65 questions

Sumatif Tengah Semester

quiz

Worksheet

•

10th Grade

1.2 ALGORITMA: Pengenalan dan Ciri-ciri

67 questions

1.2 ALGORITMA: Pengenalan dan Ciri-ciri

quiz

Worksheet

•

10th Grade

POST TEST PEMETAAN KOMPETENSI GURU DI BIDANG IT

70 questions

POST TEST PEMETAAN KOMPETENSI GURU DI BIDANG IT

quiz

Worksheet

•

10th Grade

Bridge Course_Grade8

69 questions

Bridge Course_Grade8

quiz

Worksheet

•

8th Grade - University

ONLINE COLLABORATION

65 questions

ONLINE COLLABORATION

quiz

Worksheet

•

9th - 12th Grade

sumatif bab 3 kelas 9 informatika - TIK

65 questions

sumatif bab 3 kelas 9 informatika - TIK

quiz

Worksheet

•

9th - 12th Grade