Office Automation Tools Class 11 MCQ

1. A word processing software has tools that allow creation of _________

documents.

a. Text-based

b. Graphics-base

c. Tools-base

d. None of the above

Show Answer ⟶

2. OpenOffice Writer is an ________ software for word processing.

a. Paid Source

b. Open Source

c. Both a) and b)

d. None of the above

Show Answer ⟶

3. OpenOffice Writer consists of different components like _________ .

a. Tabs & Ruler bar

b. Status bar & Scrollbar

c. Work area

d. All of the above

Show Answer ⟶

4. ___________ Modify and Window are the tabs in OpenOffice Writer.

a. File & Edit

b. View & Insert

c. Format & Tools

d. All of the above

Show Answer ⟶

Office Automation Tools Class 11 MCQ

5. File tab consists of commands like, ___________ .

a. Create & Save

b. Print & Open

c. Close

d. All of the above

Show Answer ⟶

6. Save As option is used to save a file for the ________ , or save an already saved

file with a different name.

a. First time

b. Second time
c. Third time

d. None of the above

Show Answer ⟶

7. Edit tab consists of commands for editing a document, like, ___________ .

a. Cut, Copy & Paste

b. Find & Replace

c. Undo & Redo

d. All of the above

Show Answer ⟶

8. _________ moves the text from the current location to the target location.

a. Target Text

b. Replace Text

c. Move Text

d. None of the above

Show Answer ⟶

9. __________ copies the text from the current location to the target location.

a. Duplicate Text

b. Copy Text

c. Move Text

d. All of the above

Show Answer ⟶

Office Automation Tools Class 11 MCQ

10. View tab consists of commands like, view _________ that help during viewing

a document on the screen.

a. Status bar

b. Sidebar

c. Ruler

d. All of the above

Show Answer ⟶

11. Insert tab allows insertion of _________ in a document.

a. Page number & Date

b. Header & Footer

c. Tables & Hyperlinks

d. All of the above

Show Answer ⟶

12. Format tab consist of commands to __________ formatting in a document.

a. Format a page & paragraph

b. Insert bullets and numbering

c. Style formatting

d. All of the above

Show Answer ⟶

13. Table tab commands operate on a table ___________ in a table, in a document.

a. Insert rows and columns

b. Delete rows and columns

c. Insert table

d. All of the above

Show Answer ⟶

14. Tools tab consists of commands to check __________ .

a. Check spelling and grammar

b. Count words and characters

c. Both a) and b)

d. None of the above

Show Answer ⟶

Office Automation Tools Class 11 MCQ

15. Window tab allow the user to ___________ .

a. Open a new window

b. Close an existing window

c. Both a) and b)

d. None of the above

Show Answer ⟶

16. The user can use Help tab to understand the __________ of the OpenOffice

Writer.

a. Working of any command

b. Opening a windows file

c. Saving a windows file

d. All of the above

Show Answer ⟶

17. A spreadsheet stores data in the form of a table comprising of rows and

columns.

a. Table

b. document

c. Graph

d. None of the above

Show Answer ⟶

18. Spreadsheets are used to __________ , and perform calculations on numeric

data.

a. Store
b. Arrange

c. Sort

d. All of the above

Show Answer ⟶

19. OpenOffice Calc is a __________ spreadsheet application available that can be

used to create and manipulate a spreadsheet.

a. Free software

b. Open-Source Software

c. Both a) and b)

d. None of the above

Show Answer ⟶

Office Automation Tools Class 11 MCQ

20. Calc Main Window contains various toolbars such as ____________ .

a. Title bar & Menu bar

b. Standard bar & Formatting bar

c. Status bar & Find bar

d. All of the above

Show Answer ⟶

21. A Spreadsheet consists of a number of individual sheets, each containing cells

arranged ________ .
a. Cells arranged in Row

b. Cells arranged in column

c. Both a) and b)

d. None of the above

Show Answer ⟶

22. A particular cell is identified by its ___________ .

a. Column letter

b. Row number

c. Both a) and b)

d. All of the above

Show Answer ⟶

23. The selected cell is called as an _______________ .

a. Active cell

b. Inactive cell

c. Passive cell

d. None of the above

Show Answer ⟶

24. Various types of data can be entered in a cell such as ___________ .

a. Labels
b. Numbers

c. Formulas

d. All of the above

Show Answer ⟶

Office Automation Tools Class 11 MCQ

25. __________ feature in Calc is used to automatically generate data based on a

defined series.

a. AutoFill

b. Manual Fill

c. None Fill

d. None of the above

Show Answer ⟶

26. To enhance the appearance of spreadsheets various formatting options are

available in the Formatting Bar and Format Menu such as __________ .

a. Alignment

b. Font

c. Size

d. Color

e. All of the above

Show Answer ⟶

27. Data can be __________ by using the Find toolbar.

a. Searched

b. Replaced

c. Both a) and b)

d. None of the above

Show Answer ⟶

28. Formulas in Calc can be used for basic operations such as ____________ .
a. Addition

b. Subtraction

c. Multiplication

d. All of the above

Show Answer ⟶

29. The advantage of using formulas in the cell is that even if the data in the cell

is changed, Calc will automatically _______ the answer without the need to

rewrite

the formula again.

a. Recalculate

b. Replace

c. Delete

d. None of the above

Show Answer ⟶

Office Automation Tools Class 11 MCQ

30. A _________ identifies the location of a cell or group of cells in the worksheet.

a. Cell reference

b. Active cell

c. Cell location

d. All of the above

Show Answer ⟶

31. The cell reference is also called _________ .

a. Path of a cell

b. Address of a cell

c. Active cell

d. None of the above

Show Answer ⟶

32. Calc has a set of predefined formulas called _______ .

a. Equal to

b. Function

c. Address

d. None of the above

Show Answer ⟶

33. Functions differ from formulas in the sense that in a formula we provide both

the operands and the operator, however in spreadsheet functions, we only

provide _________ .
a. Operator

b. Operands

c. Both a) and b)

d. None of the above

Show Answer ⟶

34. Some of the commonly used functions in Calc are __________ .

a. PRODUCT()

b. SQRT()

c. POWER()

d. All of the above

Show Answer ⟶

Office Automation Tools Class 11 MCQ

35. All cell references are by default _________ i.e., they adjust and change when

copied or when using AutoFill.

a. Mixed reference

b. Absolute reference
c. Relative reference

d. All of the above

Show Answer ⟶

36. Absolute addressing is used when the requirement is to retain the cell address

even if it is copied to some other cell or when using AutoFill. _________ are used

to hold a column and/or row address constant.

a. #
b. %
c. $
d. *

Show Answer ⟶

37. Mixed addressing is a combination of __________ cell addressing.

a. Absolute and Relative

b. Mixed and Absolute

c. Relative and Mixed

d. None of the above

Show Answer ⟶

38. Data can be easily sorted in Calc by using the ________ command available on

the Standard toolbar and also in the Data menu.

a. Filter

b. Sort

c. Arrange

d. None of the above

Show Answer ⟶

39. Data can be ________ in Calc for displaying it based on some conditions.

a. Filter

b. Sort

c. Arrange

d. None of the above

Show Answer ⟶

Office Automation Tools Class 11 MCQ

40. What are the different types of filter __________ .

a. Auto Filter & Standard Filter

b. Auto Filter & Advance Filter

c. Auto Filter, Standard Filter & Advanced Filter

d. None of the above

Show Answer ⟶

41. In Calc, you can create ___________ to represent the data graphically which

help in analyzing spreadsheets containing a huge amount of data.

a. Graphs

b. Charts

c. Both a) and b)

d. None of the above

Show Answer ⟶

42. Various types of charts can be created in Calc. Calc offers __________ .
a. Column Chart

b. Bar Chart

c. Pie Chart

d. All of the above

Show Answer ⟶

43. A ________ is a recording of each and every command and action you perform

to complete a task.

a. Macro

b. Function

c. Filter

d. None of the above

Show Answer ⟶

44. Calc offers various options for printing spreadsheets such as a ___________ .
a. Number of copies

b. Selected sheets

c. Selected cells

d. All of the above

Show Answer ⟶

Office Automation Tools Class 11 MCQ

45. Presentation software allows creation of presentations having __________ .

a. Text & Picture

b. Audio

c. Video

d. All of the above

Show Answer ⟶

46. OpenOffice Impress is an _________ software for presentation.

a. Open Source

b. Close Source

c. No Source

d. None of the above

Show Answer ⟶

47. _____________ are the different components of OpenOffice Impress.

a. Tabs & Ruler bar

b. Status bar & Scrollbar

c. Slide Pane

d. All of the above

Show Answer ⟶

48. OpenOffice Impress has ______ tabs.

a. 10 Tabs

b. 9 Tabs

c. 8 Tabs

d. 7 Tabs

Show Answer ⟶

49. The slides can be viewed in different views – Normal, Outline, Notes,

Handout, and Slide Sorter.

a. Normal & Outline

b. Notes & Handout

c. Slide Sorter

d. All of the above

Show Answer ⟶

Office Automation Tools Class 11 MCQ

50. _________ is the main editing view for creating slides.

a. Normal View

b. Slide Sorter

c. Handout View

d. Notes View

Show Answer ⟶

51. ________ allows the user to make notes for the selected slides.

a. Information

b. Slide

c. Handout

d. Notes

Show Answer ⟶

52. __________ view presents slides in a miniature form.

a. Normal View

b. Slide Sorter

c. Handout View

d. Notes View

Show Answer ⟶

53. Slide Master allows making changes in appearance of the slides, applying

changes to all slides in the presentation.

a. Normal View
b. Slide Master

c. Handout View

d. Notes View

Show Answer ⟶

54. File tab allows operations on a presentation, like, create, save, print, open and

close.

a. Normal View

b. Slide Sorter

c. Handout View

d. Notes View

Show Answer ⟶

Office Automation Tools Class 11 MCQ

55. Edit tab is required to perform editing on the presentation, like, cut, copy,

paste, find & replace, undo and redo changes.

a. Cut, Copy & Paste

b. Find & Replace

c. Undo & Redo

d. All of the above

Show Answer ⟶

56. Insert tab is required for inserting ____________ in a presentation.

a. Slide

b. Page number, date and time

c. Picture , Sound and hyperlinks

d. All of the above

Show Answer ⟶

57. Format tab allows formatting the slides __________ .

a. Character & Paragraph

b. Slide design

c. Slide layout

d. All of the above

Show Answer ⟶

58. Tools tab contains commands to check _________ of content in the

presentation.

a. Spelling

b. Slide design

c. Slide layout

d. None of the above

Show Answer ⟶
59. ________ tab consists of commands used on the presentation for better

results.

a. Slide Show

b. Slide design

c. Slide layout

d. None of the above

Show Answer ⟶

Office Automation Tools Class 11 MCQ

60. ___________ is the pattern that applies when a slide goes from one to next.

a. Slide Animation

b. Slide Transition

c. Slide layout

d. None of the above

Show Answer ⟶

61. ___________ is the pattern that applies to elements of a single slide.

a. Slide Animation

b. Slide Transition

c. Slide layout

d. None of the above

Show Answer ⟶