Live Education Quiz

9th Computer Science Chapter3 Office Automation

Sr #QuestionsABCD
1

Which software application is used for managing and organizing data in tabular form?

Word PowerPoint Excel Access
2

Which of the following command in excel restricts user from entering worng data in cellsĀ  of a worksheets ?

Data validation Data filtering Conditional forming Data manipulation
3

What is the function of a spreadsheet application in Office Automation?

Creating slideshows Analyzing and manipulating data Editing images Sending emails
4

What is the purpose of a presentation software in Office Automation?

Creating and editing images Designing logos Creating and delivering visual presentations Managing emails
5

Which of the following command is used to apply formatting to one or more cells based on the valu of the cell?

Data validation Data filtering conditional formatting Data manipulation
6

Which of the following is not a feature of an office suite software?

Word processing Database management 3D modeling Presentation creation
7

Which of the following tab of world ribbon contains clipboard group?

Page layout insert file home
8

Which of the following software is used for creating professional decuments?

Spreadsheet software world processor typing tutor Both A and B
9

Which tool in a word processing software is used to check the spelling and grammar of a document?

Format Painter Spell Checker Clipboard Word Count
10

In the context of Office Automation, what does the term “email” stand for?

Electronic mail Efficient mail Easy mail Emergency mail
11

What is the role of a database management system (DBMS) in Office Automation?

Creating animations Managing and organizing data in databases Designing websites Editing videos
12

Which of the following tab contains the commands for creating charts inĀ  Excel?

Home Formulas Insert Date
13

Which of the following command in excel allows the user to view only certain data in a Worksheets based on a condition?

Date validation Data Filtering Conditionals formatting Data manipulation
14

Which software application is commonly used for creating and editing documents in an office setting?

Photoshop Excel Word PowerPoint
15

When the mouse pointer is at extreme left and change to a right pointing arrow which of the following command is used in word to selsct the entire document?

Double- click Triple-click Ctrl+single -click shift+single =click
16

What is used for creating decorative effects in word?

Paragraph formatting Text formatting Page Formatting WordArt
17

What is the primary purpose of Office Automation?

Entertainment Automation of office tasks Outdoor activities None of the above
18

By default how many tabs are there in word ribbon?

7 8 9 10
19

Which of the following is an example of a collaboration tool used in Office Automation?

Antivirus software Chat application Video editing software Graphic design software
20

Which of the following shortcut kyes are used for pasting sesctied text.

Ctrl-C Ctrl-X Ctrl-V Ctrl-P