Class 10 Info Tech Electronic Spreadsheet Advanced Session 3 – Share and Review a Spreadsheet MCQ’s

/ Class 10 Electronic Spreadsheet Advanced, Class 10 Info Tech 402 MCQ's / By /

Class 10 Info. Tech. [402]

Electronic Spreadsheet Advanced – MCQ’s

Session 3 : Share and Review a Spreadsheet

Multiple Choice Questions

1. Spreadsheet software allows the user to ________ the workbook and place it in the network location where several users can access it simultaneously.

a. share

b. copy

c. Both a and b

d. None of these

Answer: a. share

2. What are the advantages of sharing file with multiple people and they work on a file at the same time.

a. Speed up data entry

b. Simply make things easier

c. Both a and b

d. None of these

Answer: c. Both a and b

3. Share Document option is available under which menu?

a. Edit

b. Insert

c. Format

d. Tools

Answer: d. Tools

4. Share Document option is used to activate the _________ features for this worksheet.

a. collaboration

b. copy

c. delete

d. rename

Answer: a. collaboration

5. To enable sharing, select the ________________ check box at the top of the dialog, and then click OK.

a. Share this spreadsheet

b. Share this document

c. Share this spreadsheet with other users

d. None of these

Answer: c. Share this spreadsheet with other users

6. Is it compulsory to save the worksheet to activate shared mode, after clicking OK in Shared Document dialog box.

a. Yes

b. No

Answer: a. Yes

7. The word _______ is shown on the title bar after the worksheet’s title, in the shared document.

a. shared

b. copied

c. collaboration

d. None of these

Answer: a. shared

8. Can we unshared the shared document without creating its copy?

a. Yes

b. No

Answer: b. No

9. if you want to use a shared worksheet in unshared mode, you need to ___________________ .

a. save the shared worksheet using another name or path.

b. copy the shared worksheet at another location.

c. rename the shared worksheet.

d. None of these.

Answer: a. save the shared worksheet using another name or path.

10. Which feature of Electronic Spreadsheet is not disabled in a shared document?

a. Edit > Changes, except for Merge Document

b. Edit > Compare Document

c. Edit > Sheet > Move/Copy & Delete

d. Edit > Headers and Footers

Answer: d. Edit > Headers and Footers

11. Which feature of Electronic Spreadsheet is not disabled in a shared document?

a. Insert > Cells Shift Cells Down & Shift Cells Right

b. Insert > Sheet from file

c. Insert > Hyperlink

d. Insert > Names

Answer: c. Insert > Hyperlink

12. Which feature of Electronic Spreadsheet is not disabled in a shared document?

a. Insert > Sheet

b. Insert > Comment

c. Insert > Picture > From File

d. Insert > Movie and Sound

Answer: a. Insert > Sheet

13. Which feature of Electronic Spreadsheet is not disabled in a shared document?

a. Insert > Object

b. Insert > Manual Break > Row break, Column break

c. Insert > Chart

d. Insert > Floating Frame

Answer: b. Insert > Manual Break > Row break, Column break

14. Which feature of Electronic Spreadsheet is not disabled in a shared document?

a. Format > Sheet > Rename, Tab Color

b. Format > Merge Cells > Merge and Center, Merge Cells, Split Cells

c. Format > Print Ranges

d. Format > Conditional Formatting

Answer: d. Format > Conditional Formatting

15. Which feature of Electronic Spreadsheet is not disabled in a shared document?

a. Tools > Protect Document

b. Tools > Macros

c. Data > Define Range

d. Data > Sort

Answer: b. Tools > Macros

16. Which feature of Electronic Spreadsheet is not disabled in a shared document?

a. Data > Subtotals

b. Data > Validity

c. Data > Select Range

d. Data > Multiple Operations

Answer: c. Data > Select Range

17. Which feature of Electronic Spreadsheet is not disabled in a shared document?

a. Data > Consolidate

b. Data > Group and Outline (all)

c. Data > Pivot Table

d. Data > Text to columns

Answer: d. Data > Text to columns

18. Which of the following situation occurs, when you save a shared spreadsheet?

a. If the worksheet was not modified and saved by another user since you opened it, the worksheet is saved.

b. If the changes do not conflict, the worksheet is saved.

c. If the changes conflict, the Resolve Conflicts dialog is shown.

d. All of these

Answer: d. All of these

19. When any cells modified by the other user, in a shared document, are shown with a ________ color border.

a. red

b. blue

c. yellow

d. green

Answer: a. red

20. When any changes are conflict, the ________ dialog box is appear.

a. Changes Conflict

b. Resolve Conflicts

c. Share Conflicts

d. None of these

Answer: b. Resolve Conflicts

21. If the changes are conflict, your worksheet is saved only when all conflicts are _________.

a. Changes

b. Shared

c. Ignored

d. Resolved

Answer: d. Resolved

22. During the conflicts resolving process, other user can save the shared worksheet?

a. Yes

b. No

Answer: b. No

23. When another user is trying to save the shared worksheet and resolve conflicts, you see a message that the shared spreadsheet file is locked due to a ___________ in progress.

a. merge-in

b. shared-in

c. save-in

d. change-in

Answer: a. merge-in

24. Most spreadsheets software automatically turns off some features in shared workbooks. [T/F]

a. True

b. False

Answer: a. True

25. What types of changes you can track in Calc?

a. When the change was made

b. Who made the change

c. In which cell the change has occurred

d. All of these

Answer: d. All of these

26. How to start recording changes feature in Calc?

a. Select Edit > Changes > Record

b. Select Edit > Record

c. Select Edit > Record Changes

d. Select Edit > Record > Changes

Answer: a. Select Edit > Changes > Record

27. A deleted column or row is marked by a _______ colored bar.

a. wavy

b. heavy

c. zig-zag

d. None of these

Answer: b. heavy

28. Can you marked and recorded the Cell formatting changes?

a. Yes

b. No

Answer: b. No

29. How to change the color that indicates changes?

a. Tools > Options > Changes

b. Tools > Changes > Options > OpenOffice.org Calc

c. Tools > Options > OpenOffice.org Calc > Changes

d. None of these

Answer: c. Tools > Options > OpenOffice.org Calc > Changes

30. What types of Colors for changes are allowed in OpenOffice.org Calc?

a. Changes

b. Deletions

c. Insertions

d. Moved entries

e. All of these

Answer: e. All of these

31. OpenOffice.org Calc gives you tremendous control over what changes you see when reviewing a worksheet.

a. Yes

b. No

Answer: a. Yes

32. Show changes dialog will be appear by clicking on _____________.

a. Edit > Changes > Show

b. Edit > Show > Changes

c. Edit > Show Changes

d. Edit > Changes Show

Answer: a. Edit > Changes > Show

33. Which filter settings allowed to show changes made in a certain time range are displayed.

a. Date

b. Time

c. Timestamp

d. Range

Answer: a. Date

34. Which filter settings is especially useful, to show the changes made by a specific reviewers.

a. Author

b. Reviewer

c. User

d. Changer

Answer: b. Reviewer

35. Which filter setting is especially useful if you have large spreadsheet and only want to review a part of it i.e. only changes made in a specific range of cells are displayed.

a. Cells

b. Range

c. Cell Range

d. Array

Answer: b. Range

36. Which filter, helps in finding the changes on the basis of description –

a. Range

b. Comment

c. Show Comment

d. Accept Comment

Answer: b. Comment

37. Which filter shows the only accepted changes?

a. Show accepted changes

b. Accepted changes only

c. Changes only

d. Show rejected changes

Answer: a. Show accepted changes

38. ________ filter helps in showing the changes are not accepted.

a. Show rejected changes

b. Not Accepted changes only

c. Rejected only

d. Show not accepted changes

Answer: a. Show rejected changes

39. You can open the Comment dialog box by selecting _________.

a. Edit > Comment

b. Edit > Changes

c. Edit > Changes > Comment

d. All of the above

Answer: c. Edit > Changes > Comment

40. Does Calc automatically adds to any recorded change a comment describing what was changed (for example, Cell B4 changed from ‘9’ to ‘4’).

a. Yes

b. No

Answer: a. Yes

41. _________ can add their comments to explain their changes.

a. Reviewers

b. Authors

c. Both a and b

d. None of these

Answer: c. Both a and b

42. The __________ comment provided by Calc appears in the title bar of this dialog and cannot be edited.

a. Authors provided

b. Reviewers provided

c. Automatically added

d. None of these

Answer: c. Automatically Added

43. When you hovering the mouse pointer over the cell, you can see _________.

a. value

b. cell address

c. comment

d. None of these

Answer: c. comment

44. Can you edit the comment?

a. Yes

b. No

Answer: a. Yes

44. Who can step through each change and decide how to proceed?

a. Author

b. Original Author

c. Reviewer

d. Original Reviewer

Answer: b. Original Author

45. Accept or Reject process can start by selecting –

a. Edit > Changes > Accept

b. Edit > Changes > Reject

c. Edit > Changes > Accept or Reject

d. Both a and b

Answer: c. Edit > Changes > Accept or Reject

46. The ________ column by default contains an explanation of the change that was made.

a. Comment

b. Description

c. Author

d. Changes

Answer: a. Comment

47. If the reviewer added a comment to the change, it is displayed, followed by the _________ of the change.

a. description

b. comment

c. reviewer

d. None of these

Answer: a. description

48. Suppose there are more than one person has reviewed the worksheet, one reviewer may have modified another reviewer’s change. If so, the changes are arranged ____________.

a. hierarchically

b. vertically

c. horizontally

d. none of these

Answer: a. hierarchically

49. _________ feature is provided by Calc, to review all the changes made by multiple reviewers at once.

a. Compare Worksheets

b. Review Worksheets

c. Merging Worksheets

d. None of these

Answer: c. Merging Worksheets

50. Identify the purpose of Merging Worksheets?

a. to review all of these changes at once

b. to review one at a time

c. Both a and b

d. None of these

Answer: c. Both a and b

51. To start the process of merging worksheets, select ________.

a. Edit > Changes > Merge Document

b. Edit > Merge Document

c. Edit > Changes

d. Edit > Merge Document > Changes

Answer: a. Edit > Changes > Merge Document

52. Changes from different authors appear in different ______ in the worksheet.

a. Styles

b. Fonts

c. Colors

d. Fonts and Colors

Answer: c. Colors

53. Can you identify the changes made by another reviewer, if you forget to record the changes?

a. Yes

b. No

Answer: a. Yes

54. Which feature of Calc is use to identify the changes, if you forget to record the changes?

a. Merging Document

b. Identify changes

c. Comparing Document

d. Reviewing Document

Answer: c. Comparing Document

55. In order to compare worksheets you need to have the original worksheet and the one that is _________.

a. copied

b. edited

c. renamed

d. None of these

Answer: b. edited

56. Identify the correct order to Compare the worksheets –

I. Open the edited worksheet that you want to compare with the original worksheet.

II. Select Edit > Compare Document.

III An open worksheet dialog appears. Select the original worksheet and click Insert.

a. I, II, & III

b. II, I, & III

c. III, II, & I

d. I, III, & II

Answer: a. I, II & III

57. All data that occurs in the edited worksheet but not in the original is identified as ___________.

a. inserted

b. deleted

c. changed

d. None of these

Answer: a. inserted

58. All data that is in your original worksheet but is not in the edited worksheet is identified as __________.

a. inserted

b. deleted

c. changed

d. None of these

Answer: b. deleted

59. All data that is changed, is marked as ________.

a. inserted

b. deleted

c. changed

d. None of these

Answer: c. changed

60. Original author of the Worksheet can accept or reject changes made by other users.

a. True

b. False

Answer: a. True

61. Spreadsheet software allows the user to share the workbook and place it in the __________ location where several users can access.

a. shared drive

b. network location

c. google drive

d. None of these

Answer: b. network location

62. Spreadsheet software can find the changes by __________ Sheets.

a. renaming

b. comparing

c. merging

d. None of these

Answer: b. comparing

Class 10 Information Technology 402 – 1000+ Multiple Choice Questions

Related Posts

You cannot copy content of this page

Scroll to Top