Class 10 Info Tech Electronic Spreadsheet Advanced Session 4 – Create and Use Macros in Spreadsheets MCQs

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

Class 10 Electronic Spreadsheet Advanced MCQ’s

Session 4: Create and Use Macros in Spreadsheets

Multiple Choice Questions

1. A macro is a saved sequence of commands or keystrokes that are stored for later use.

a. file

b. program

c. macro

d. none of these

Answer: c. macro

2. _________ are especially useful to repeat a task the same way over and over again.

a. File

b. Program

c. Macro

d. None of these

Answer: c. Macro

3. The OpenOffice.org (OOo) macro language is allowing ________ of both simple and complex tasks.

a. flexible

b. automation

c. updation

d. none of these

Answer: b. automation

4. OpenOffice.org using the ________ to record macro.

a. macro recorder

b. macro converter

c. macro

d. macro updator

Answer: a. macro recorder

5. Macro option is available under _______ menu.

a. Insert

b. Tools

c. Format

d. Data

Answer: b. Tools

6. The Record Macro dialog is displayed with a ___________ button.

a. close recording

b. stop recording

c. exit recording

d. None of these

Answer: b. stop recording

7. To start the macro recorder, select

a. Tools > Macro > Record Macro

b. Tools > Macro

c. Tools > Record Macro

d. None of these

Answer: a. Tools > Macro > Record Macro

8. You can stop the Macro Recorder by clicking on ___________ button.

a. close recording

b. stop recording

c. exit recording

d. None of these

Answer: b. stop recording

9. When you click on Stop Recording to stop the macro recorder, Calc open OpenOffice.org Basic Macros dialog.

a. True

b. False

Answer: a. True

10. In OpenOffice.org Calc, macro is saved in __________.

a. Worksheet > Library > Module

b. Worksheet > Module

c. Worksheet > Module > Library

d. None of these

Answer: a. Worksheet > Library > Module

11. Calc will not allow any macros to be run inside the document, if macro is ___________.

a. Enable

b. Disable

c. Either a or b

d. None of these

Answer: b. Disable

12. Function names are case sensitive in OpenOffice.org Calc.

a. True

b. False

Answer: b. False

13. To change the settings related to Macro, select _________.

a. Tools > Options > Macro Security

b. Tools > Options > OpenOffice.org > Macro Security

c. Tools > Options > OpenOffice.org > Security

d. Tools > Options > OpenOffice.org > Security >Macro Security

Answer: d. Tools > Options > OpenOffice.org > Security >Macro Security

14. Can you use the Macro as Function in OpenOffice.org Calc?

a. Yes

b. No

Answer: a. Yes

15. When a document is created and saved, it automatically contains a library named _________.

a. Standard

b. Default

c. Basic

d. Primary

Answer: a. Standard

16. The __________ library is automatically loaded when the document is opened.

a. Standard

b. Default

c. Basic

d. Primary

Answer: a. Standard

17. To open the Basic Macros dialog, Select ________.

a. Tools > Macros

b. Tools > Macros > Organize Macros

c. Tools > Macros > Organize Macros > OpenOffice.org Basic

d. None of these

Answer: c. Tools > Macros > Organize Macros > OpenOffice.org Basic

18. If a library is saved with other name, then also OpenOffice.org Calc will load that library automatically.

a. Yes

b. No

Answer: b. No

19. In OpenOffice.org Basic dialog box, how can you identify the a loaded library and not a loaded library?

a. with the help of size of icon

b. with the help of color of icon

c. with the help of shape of icon

d. with the help of name of icon

Answer: b. with the help of color of icon

20. In OpenOffice.org Calc, usually the expansion symbol will be __________.

a. a plus symbol

b. a triangle symbol

c. Either a or b

d. None of these

Answer: c. Either a or b

21. OpenOffice.org Calc automatically creates a macro named ______ and opens the module for editing.

a. Default

b. Standard

c. Main

d. Macros

Answer: c. Main

22. Can you pass argument to macros in OpenOffice.org Calc?

a. Yes

b. No

Answer: a. Yes

23. Which keyword is use with argument, to specify the argument is optional?

a. optional

b. default

c. opt

d. def

Answer: a. Optional

24. When calling a function with two arguments, separate the arguments with _________

a. comma ,

b. dot .

c. semicolon ;

d. None of these

Answer: c. Semicolon (;)

25. The icon changes color to indicate that the library is now loaded.

a. True

b. False

Answer: a. True

26. In OpenOffice.org Calc, arguments passed to a macro are always __________.

a. values

b. reference

c. cell address

d. ranges

Answer: a. Values

27. Mr. Anjeev Singh wants to know, which cells are referenced rather than the values in the cells while passing the argument to function. Suggest him the proper sequence of steps given below :-

I. parse the string,

II. pass the range as a string

III. obtain the values in the referenced cells.

a. I, II & III

b. II, I, & III

c. III, I, & II

d. III, II, & I

Answer: b. II, I & III

28. Does a macro behave as built-in functions?

a. Yes

b. No

Answer: b. No

29. In OpenOffice.org Calc, Macros codes are written inside –

a. Function ….. End Function

b. Sub ….. End Sub

c. Macro ….. End Sub

d. None of these

Answer: a. Function … End Function

30. _________ reference to the Current Document in OpenOffice.org?

a. ThisComponent

b. ThisDocument

c. CurrentDocument

d. ThisCurrent

Answer: a. ThisComponent

31. _________ function is used to get the reference of sheets of a Calc Document.

a. getSheet()

b. getSheets()

c. getWorkSheet()

d. getWorkSheets()

Answer: b. getSheets()

32. __________ function return a cell at a specific row and column in OpenOffice.org Calc?

a. getCell(col, row)

b. getCellPosition( col, row)

c. getCellByPosition(col, row)

d. None of these

Answer: c. getCellByPosition(col, row)

33. Sorting data can be automated in Open Office by creating a _______ in Calc.

a. Function

b. Macro

c. Program

d. None of these

Answer: b. Macro

34. _________ function is used to get the reference of a sheet by name of a Calc Document.

a. getSheetByName()

b. getSheetsByName()

c. getByName()

d. getByNames()

Answer: c. getByName()

35. _________ function is used to get the cell range of a sheet by name of a Calc Document.

a. getSheetCellRangeByName()

b. getSheetsByName()

c. getSheetCellRange()

d. getCellRangeByName()

Answer: d. getCellRangeByName()

Class 10 Information Technology 402 – 1000+ Multiple Choice Questions

Related Posts

You cannot copy content of this page

Scroll to Top