Teachers and Examiners (CBSESkillEduction) collaborated to create the Office Automation Tools Class 11 MCQ. All the important Information are taken from the NCERT Textbook Information Technology (802) class 11.
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
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
3. OpenOffice Writer consists of different components like _________.
a. Tabs & Ruler bar
b. Status bar & Scrollbar
c. Work area
d. All of the above
4. ___________ Modify and Window are the tabs in OpenOffice Writer.
a. File & Edit
b. View & Insert
c. Format & Tools
d. All of the above
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
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
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
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
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
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
11. Insert tab allows insertion of _________ in a document.
a. Page number & Date
b. Header & Footer
c. Tables & Hyperlinks
d. All of the above
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
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
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
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
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
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
18. Spreadsheets are used to __________, and perform calculations on numeric data.
a. Store
b. Arrange
c. Sort
d. All of the above
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
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
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
22. A particular cell is identified by its ___________.
a. Column letter
b. Row number
c. Both a) and b)
d. All of the above
23. The selected cell is called as an _______________.
a. Active cell
b. Inactive cell
c. Passive cell
d. None of the above
24. Various types of data can be entered in a cell such as ___________.
a. Labels
b. Numbers
c. Formulas
d. All of the above
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
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
27. Data can be __________by using the Find toolbar.
a. Searched
b. Replaced
c. Both a) and b)
d. None of the above
28. Formulas in Calc can be used for basic operations such as ____________.
a. Addition
b. Subtraction
c. Multiplication
d. All of the above
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
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
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
32. Calc has a set of predefined formulas called _______.
a. Equal to
b. Function
c. Address
d. None of the above
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
34. Some of the commonly used functions in Calc are __________.
a. PRODUCT()
b. SQRT()
c. POWER()
d. All of the above
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
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. *
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
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
39. Data can be ________ in Calc for displaying it based on some conditions.
a. Filter
b. Sort
c. Arrange
d. None of the above
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
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
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
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
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
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
46. OpenOffice Impress is an _________ software for presentation.
a. Open Source
b. Close Source
c. No Source
d. None of the above
47. _____________ are the different components of OpenOffice Impress.
a. Tabs & Ruler bar
b. Status bar & Scrollbar
c. Slide Pane
d. All of the above
48. OpenOffice Impress has ______ tabs.
a. 10 Tabs
b. 9 Tabs
c. 8 Tabs
d. 7 Tabs
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
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
51. ________ allows the user to make notes for the selected slides.
a. Information
b. Slide
c. Handout
d. Notes
52. __________ view presents slides in a miniature form.
a. Normal View
b. Slide Sorter
c. Handout View
d. Notes View
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
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
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
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
57. Format tab allows formatting the slides __________.
a. Character & Paragraph
b. Slide design
c. Slide layout
d. All of the above
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
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
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
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
Employability Skills Class 11 Notes
- Unit 1 : Communication Skills Class 11 Notes
- Unit 2 : Self-Management Skills Class 11 Notes
- Unit 3 : Information and Communication Technology Skills Class 11 Notes
- Unit 4 : Entrepreneurial Skills Class 11 Notes
- Unit 5 : Green Skills Class 11 Notes
Employability Skills Class 11 MCQ
- Unit 1 : Communication Skills Class 11 MCQ
- Unit 2 : Self-Management Skills Class 11 MCQ
- Unit 3 : Information and Communication Technology Skills Class 11 MCQ
- Unit 4 : Entrepreneurial Skills Class 11 MCQ
- Unit 5 : Green Skills Class 11 MCQ
Employability Skills Class 11 Questions and Answers
- Unit 1 : Communication Skills Class 11 Questions and Answers
- Unit 2 : Self-Management Skills – III
- Unit 3 : Information and Communication Technology Skills Class 11 Questions and Answers
- Unit 4 : Entrepreneurial Skills Class 11 Questions and Answers
- Unit 5 : Green Skills Class 11 Questions and Answers
Information Technology Class 11 Notes
- Unit -1 : Computer Organization Class 11 Notes
- Unit -2 : Networking And Internet Class 11 Notes
- Unit-3 : Office Automation Tools Class 11 Notes
- Unit-4: RDBMS Class 11 Notes
- Unit-5: Fundamentals of Java Class 11 Notes
Information Technology Class 11 MCQ
- Unit -1 : Computer Organization Class 11 MCQ
- Unit -2 : Networking And Internet Class 11 MCQ
- Unit-3 : Office Automation Tools Class 11 MCQ
- Unit-4: RDBMS Class 11 MCQ
- Unit-5: Fundamentals of Java Class 11 MCQ