Class 10 Info Tech Electronic Spreadsheet Advanced Session 2 - Link Data and Spreadsheets MCQ's - MyCSTutorial- The path to Success in Exam

Electronic Spreadsheet Advanced Class 10 MCQ’s

Class 10 Info Tech Electronic Spreadsheet Advanced Session 1 – Analyse Data Using Scenarios and Goal Seek MCQs
by mycstutorial
Class 10 Info Tech Electronic Spreadsheet Advanced Session 2 – Link Data and Spreadsheets MCQ’s
by mycstutorial
Class 10 Info Tech Electronic Spreadsheet Advanced Session 3 – Share and Review a Spreadsheet MCQ’s
by mycstutorial
Class 10 Info Tech Electronic Spreadsheet Advanced Session 4 – Create and Use Macros in Spreadsheets MCQs
by mycstutorial

Session 2 : Link Data and Spreadsheets

Multiple Choice Questions

1. Does Spreadsheet allows to link the cells from various worksheets and from various other spreadsheets?

a. Yes

b. No

c. None of these

Answer: a. Yes

2. Spreadsheet also allows you to link the cells from various worksheets and from various other spreadsheets to ________ data from several sources.

a. link

b. summarize

c. calculate

d. update

Answer: b. summarize

3. Can you create a formulas that span from local sheet to linked sheet?

a. Yes

b. No

Answer: a. Yes

4. What is the default name of a new spreadsheet.

a. Worksheet 1, Worksheet 2, ….

b. Book1, Book2, ……

c. Doc1, Doc2, ….

d. Sheet 1, Sheet 2, ….

Answer: d. Sheet 1, Sheet 2, ….

5. in how many ways you can insert a new sheet in a spreadsheet?

a. 2

b. 3

c. 4

d. 1

Answer: b. 3

6. Through which menu bar, you can insert a new sheet?

a. Insert

b. Edit

c. Format

d. Date

Answer: a. Insert

7. Identify the correct steps to insert a new sheet in a spreadsheet.

a. Select Insert > Sheet from the menu bar

b. Right-click on the tab and select Insert Sheet

c. Click in an empty space at the end of the line of sheet tabs.

d. All of these

Answer: d. All of these

8. What is the maximum number of sheets allowed in OpenOffice.org Calc?

a. 3

b. 128

c. 256

d. 1024

Answer: c. 256

9. What is the maximum number of rows in a sheets allowed in OpenOffice.org Calc?

a. 1,048,57

b. 65,536

c. 32,000

d. 16000

Answer: a. 1,048,57

10. What is the maximum number of columns in a sheets allowed in OpenOffice.org Calc?

a. 128

b. 256

c. 512

d. 1024

Answer: d. 1024

11. Identify the options are available in Insert Sheet dialog box.

I. Before current sheet

II. After current sheet

III. New sheet

IV. No. of sheet

V. Name

Vi. From File

a. Only I, II, III

b. Only I, II, III, IV

c. Only I, II, III, IV, V

d. All of the given options

Answer: d. All of the given options

12. Sumit wants to insert sheets from a file name result.xls. Suggest him the suitable options for the same-

a. Insert > Sheet from file

b. Insert > Sheet > From file

c. Insert > From file

d. Both a and b

Answer: d. Both a and b

13. Tanmay is working in OpenOffice.org Calc. Spreadsheet file is having 3 Sheets named – ‘Sales’, ‘Marketing’, ‘Accounts’. Now he wants to insert a new sheet between ‘Marketing’ and ‘Accounts’. Currently he is working in Accounts Sheet.

In Insert Sheet dialog box, what position he needs to select to insert a Sheet between ‘Marketing’ and ‘Accounts’.

a. Before current sheet

b. After current sheet

c. Between ‘Marketing’ and ‘Accounts’.

d. None of these

Answer: a. Before current sheet

14. At the time of inserting a sheet, can you decide the name of sheets? [Y/N]

a. Yes

b. No

Answer: a. Yes

15. In which box, you will write the name of newly inserted sheet, under the Insert Sheet dialog box?

a. New Sheet

b. Title

c. Name

d. From File

Answer: c. Name

16. At the ________ of each worksheet window is a small tab that indicates the name of the worksheets in the workbook.

a. bottom

b. top

c. left

d. right

Answer: a. bottom

17. In how many ways you can rename a worksheet?

a. 1

b. 2

c. 3

d. 4

Answer: c. 3

18. Which of the followings are a valid method to rename a worksheet?

a. Double-click on one of the existing worksheet names.

b. Right-click on an existing worksheet name, then choose Rename from the resulting Context menu.

c. Select the worksheet you want to rename and then select the Sheet option from the Format menu.

d. All of these

Answer: d. All of these

19. A _________ refers to a cell or a range of cells on a worksheet.

a. cell reference

b. cell name

c. cell

d. None of these

Answer: a. cell reference

20. _________ can be used to find the values or data that you want formula to calculate.

a. cell reference

b. cell name

c. cell

d. None of these

Answer: a. cell reference

21. In one or several formulas, you can use a cell reference to refer to:

a. Data from one or more contiguous cells on the worksheet.

b. Data contained in different areas of a worksheet.

c. Data on other worksheets in the same workbook.

d. All of these

Answer: d. All of these

22. In OpenOffice.org Calc formula is start with _______ .

a. +

b. –

c. =

d. None of these

Answer: d. =

23. Anjeev want to access the value from “Main Sheet’. He has written a formula, but he is getting an error message. Identify the correct formula-

a. =Main Sheet.A2

b. =’Main Sheet’A2

c. =’Main Sheet’.A2

d. None of these

Answer: c . =’Main Sheet’.A2

24. Referencing the cells from other sheets of same file, having following parts –

a. Sheet Name

b. Cell Address

c. Both a & b

d. None of these

Answer: c. Both a & b

24. Referencing the cells from other sheets of other file, having following parts –

a. Path and file name

b. Sheet name

c. Cell Address

d. All of these

Answer: d. All of these

25. General format for the reference is __________________.

a. =’file:///Path &File Name’#$SheetName.CellName

b. =’file:Path &File Name’#$SheetName.CellName.

c. =’file:///Path &File Name’SheetName.CellName.

d. None of these

Answer : a. =’file:///Path &File Name’#$SheetName.CellName.

26. ___________ can be used in Calc to jump to a different location from within a spreadsheet and can lead to other parts of the current file, to different files or even to web sites.

a. Hyperlinks

b. File

c. Link

d. Hypertext

Answer: a. Hyperlinks

27. Hyperlinks can be stored within your file as _________ .

a. relative

b. absolute

c. Both a and b

d. None of these

Answer: c. Both a and b

28. An absolute link will stop working only if the _________.

a. target is moved

b. start is moved

c. Both a & b

d. None of these

Answer: a. target is moved

29. A relative link will stop working only if the _________ relative to each other.

a. start and target locations change

b. start locations change

c. target locations change

d. None of these

Answer: a. start and target locations change

30. If you have two spreadsheets in the same folder linked to each other and you move the entire folder to a new location, a relative hyperlink will _______.

a. break

b. not break

c. None of these

Answer: b. not break

31. To change the way that OOo saves the hyperlinks in your file, select __________ and choose if you want URLs saved relatively when referencing the File System, or the Internet, or both..

a. Tools > Options > Load/Save > General

b. Tools > Load/Save > General

c. Tools > Options > General

d. None of these

Answer: a. Tools > Options > Load/Save > General

32. You can insert and modify links using the ________ dialog.

a. Hyperlink

b. Save As

c. Rename

d. Insert and Modify

Answer: a. Hyperlink

33. Which of the following is a Hyperlink icon?

d. None of these

Answer: c.

34. Hyperlink Icon is available on the __________ toolbar.

a. Standard

b. Formattring

c. Internet

d. Object Linking and Embedding

Answer: a. Standard

35. Hyperlink option is available under ________ menu.

a. Tools

b. Format

c. Insert

d. Data

Answer: c. Insert

36. To turn existing text into a link, ________ it before opening the Hyperlink dialog.

a. highlight

b. select

c. Both a and b

d. None of these

Answer: c. Both a and b

37. How many types of hyperlinks in OpenOffice.org Calc?

a. 1

b. 2

c. 3

d. 4

Answer: d. 4

38. Which of the following is valid types of Hyperlink in OpenOffice.org Calc?

a. Internet, Document, Mail & News, New Document

b. Internet, Document, Mail , New Document

c. Internet, Mail, News, New Document

d. Internet, News, Document, New Document

Answer: a. Internet, Document, Mail & News, New Document

39. The hyperlink points to a web address, normally starting with http://, called __________.

a. Internet

b. Document

c. Mail & News

d. New Document

Answer: a. Internet

40. The hyperlink points to a place in either the current worksheet or another existing worksheet, called _________.

a. Internet

b. Document

c. Mail & News

d. New Document

Answer: b. Document

41. The hyperlink opens an email message that is pre-addressed to a particular recipient, called _______.

a. Internet

b. Document

c. Mail & News

d. New Document

Answer: c. Mail & News

42. ________ types of the hyperlink creates a new worksheet.

a. Internet

b. Document

c. Mail & News

d. New Document

Answer: d. New Document

43. Which of the followings are the sub-categories of Internet type Hyperlink.

a. Web, FTP, & Telnet

b. Web, Email, & News

c. FTP, Email, & Web

d. Telnet, Web, & News

Answer: a. Web, FTP , & Telnet

44. For an _______ hyperlink, choose the type of hyperlink (choose between Web, FTP or Telnet), and enter the required web address (URL).

a. Internet

b. Document

c. Mail & News

d. New Document

Answer: a. Internet

45. For an _______ hyperlink, specify whether it is a mail or news link, the receiver address and for email, also the subject.

a. Internet

b. Document

c. Mail & News

d. New Document

Answer: c. Mail & News

46. For an _______ hyperlink, specify the worksheet path (the Open File button opens a file browser); leave this blank if you want to link to a target in the same spreadsheet.

a. Internet

b. Document

c. Mail & News

d. New Document

Answer: b. Document

47. For an _______ hyperlink, specify the worksheet path (the Open File button opens a file browser); leave this blank if you want to link to a target in the same spreadsheet.

a. Internet

b. Document

c. Mail & News

d. New Document

Answer: b. Document

48. _______ button / field is use to link the document to another sheet in the same spreadsheet.

a. path

b. url

c. name

d. target

Answer: d. target

49. For an _______ type hyperlink, specify whether to edit the newly created worksheet immediately or later.

a. Internet

b. Document

c. Mail & News

d. New Document

Answer: d. New Document

50. The __________ button opens a directory picker dialog.

a. Edit later

b. Target in Document

c. Select Path

d. None of these

Answer: c. Select Path

51. Set the value of Frame to determine how the hyperlink will open. This applies to worksheets that open in a Web browser.

a. Frame

b. Form

c. Text

d. Name

Answer: a. Frame 

52. _______ specifies if the link is to be presented as text or as a button. The figure below shows a link formatted as a button.

a. Frame

b. Form

c. Text

d. Name

Answer: b. Form 

53. _______ specifies the text that will be visible to the user. If you do not enter anything here, Calc will use the full URL or path as the link text.

a. Frame

b. Form

c. Text

d. Name

Answer: c. Text

54. ______ is applicable to HTML documents. It specifies text that will be added as a NAME attribute in the HTML code behind the hyperlink.

a. Frame

b. Form

c. Text

d. Name

Answer: d. Name 

55. Linking to external data can be done in __________ ways.