Question

i) In which option we have to specify the target range(Where we want the result to be

displayed)

a. Source data range b. Copy results to c. Need result at d. target range

ii) SUBTOTALS _________ data arranged in an array (that is, a group of cells

a. Add b. Average c. Find d. Clear

iii) Identify the correct sequence

a. First open subtotals window and then select the data where we need to apply subtotals.

b. First Select data and then open subtotals window.

c. Both of the above are correct

d. None of the above

iv) To select random multiple cell hold down ________ key as you click on each cell.

a. Alt b. Shift c. Ctrl d. All of the above

v) We can insert the new sheet in Calc by clicking on __ menu.

a. Format b. Edit c. Insert d. Tool

vi) Hyperlink icon is present on _________________

a. Format Toolbar b. Standard Toolbar c. Menu Bar d. None of the Above

vii) Which of the following buttons are present on “Resolve Conflict” dialog box which

appear during saving shared worksheet.

a. Keep Mine b. Keep Other c. Keep All Mine d. All of the above

viii) Which of the following changes are not recorded in shared worksheet?

a. Changes any number b. Changes any text c. Cell Formatting d. None of the above

ix) When sharing worksheets authors may forget to record the changes they

make. Calc can find the changes by _________ worksheets

a) duplicating b) comparing c) checking d)None of the above

x) When a document is created and saved, it automatically contains a library

named ___

a. Module Library b. Macro Library c. Standard d. None of the above

xi) We can consolidate data by ________

a. Row Label b. Column Label c. Both of the above d. None of the above​

Answer 1

i).Option(d) target range.

• It helps to specify the target range.

ii)Option(a)Add

• It helps to add the data and arrange it in an array.

iii)Option(c) Both of the above are correct

• Both are correct because we have to open subtotals and select the data.

iv)Option(d)All of the above

• All the above options are true.

v) )Option(c) insert

• Insert tab helps to insert new sheet

vi)Option(a)  Format Toolbar

• The icon is present in the format toolbar.

vii)Option(a) Keep Mine

viii) Option(d) None of the above

• None of the above is the correct option.

ix) Option(c) checking

• It gives an assurance that the worksheet is changed or not.

x) Option(b) Macro Library

• The automatically saved file containing the library is Macro library.

xi) Option(c) Both of the above.

• Data can be consolidated by both row and column labels.

Answer 2

Answer:

i).Option(b) copy results to .

It helps to specify the target range.
ii)Option(a)Add

It helps to add the data and arrange it in an array.
iii)Option(c) Both of the above are correct

Both are correct because we have to open subtotals and select the data.
iv)Option(d)All of the above

All the above options are true.
v) )Option(c) insert

Insert tab helps to insert new sheet
vi)Option(a)  Format Toolbar

The icon is present in the format toolbar.
vii)Option(a) Keep Mine

viii) Option(d) None of the above

None of the above is the correct option.
ix) Option(c) checking

It gives an assurance that the worksheet is changed or not.
x) Option(b) Macro Library

The automatically saved file containing the library is Macro library.
xi) Option(c) Both of the above.

Data can be consolidated by both row and column labels.