II Sem Bba MS Office Objective Test
It is to test your knowledge in Ms office packages such as Ms word, Ms excel, Ms power point etc. It is as per the syllabus for II semester BBA of calicut university in the paper Information Technology for business
Questions and Answers
- 1.
Ms word is ------------ application
- A.
Presentation
- B.
Spreadsheet
- C.
Database
- D.
Word processing
- E.
None of these
Correct Answer
D. Word processingExplanation
The correct answer is "word processing" because Microsoft Word is a software application specifically designed for creating, editing, and formatting text documents. It provides various tools and features to manipulate text, such as spell check, grammar check, formatting options, and the ability to insert images and tables. Therefore, it is commonly used for word processing tasks like writing letters, reports, essays, and other types of documents.Rate this question:
-
- 2.
What is mean by Query in Ms Access?
- A.
Retriving required information from a database
- B.
Deleting a selected information in a database
- C.
Getting help instruction about ms access
- D.
Helps to enter informations per record at a time
Correct Answer
A. Retriving required information from a databaseExplanation
The term "query" in MS Access refers to the process of retrieving specific information from a database. It allows users to search and extract the required data based on certain criteria or conditions. Queries are used to filter and sort data, perform calculations, and generate reports. They help in efficiently accessing and analyzing the relevant information stored in the database.Rate this question:
-
- 3.
What is non printing charecters in Ms word?
- A.
Charectors that cannot be enterd in ms word
- B.
Charectors that word displays but do not print eg: space bar
- C.
Charectors that are not in T9 dictionary of Ms word
Correct Answer
B. Charectors that word displays but do not print eg: space barExplanation
Non-printing characters in MS Word refer to characters that are not visible when printed but are displayed on the screen. These characters include spaces, tabs, paragraph marks, and other formatting marks. They are used to indicate the formatting and layout of a document and help with editing and formatting tasks. The space bar is an example of a non-printing character as it creates a space between words but is not visible when the document is printed.Rate this question:
-
- 4.
What is the key board short cut to start slide show in MS power point?
- A.
F1
- B.
F5
- C.
Ctrl+S
- D.
Shift+S
- E.
Alt+F4
Correct Answer
B. F5Explanation
Pressing F5 is the keyboard shortcut to start a slide show in MS PowerPoint. This function key activates the presentation mode and displays the slides in full screen. By pressing F5, the presenter can begin delivering their presentation to the audience.Rate this question:
-
- 5.
What is functions in Ms excel
- A.
Menu commands
- B.
Predfined formula in excel
- C.
Short cut keys
- D.
Auto sum
Correct Answer
B. Predfined formula in excelExplanation
The correct answer is "predefined formula in excel." Functions in MS Excel refer to predefined formulas that perform specific calculations or tasks. These functions can be used to automate calculations, manipulate data, analyze information, and perform various mathematical operations. They are built-in formulas that can be easily applied to cells or ranges in a spreadsheet to perform specific calculations without having to write the entire formula manually. This saves time and ensures accuracy in calculations. Functions in Excel include mathematical functions, statistical functions, date and time functions, logical functions, text functions, and more.Rate this question:
-
- 6.
A Series of commands stored in computer memory that can be run when ever needed is called--------- in Ms office
- A.
Format painter
- B.
Macros
- C.
Logical functions
- D.
Freez spane
Correct Answer
B. MacrosExplanation
Macros in MS Office are a series of commands that are stored in computer memory and can be run whenever needed. They allow users to automate repetitive tasks by recording a sequence of commands and then playing them back with a single click. Macros are useful for saving time and increasing efficiency in performing tasks in MS Office applications such as Word, Excel, and PowerPoint.Rate this question:
-
- 7.
How many work sheet will be there in workbook by default?
- A.
1
- B.
3
- C.
5
- D.
10
Correct Answer
B. 3Explanation
By default, a workbook in Microsoft Excel contains three worksheets. These worksheets are labeled as "Sheet1," "Sheet2," and "Sheet3." This default setting allows users to organize and separate their data into different sheets within the same workbook. Users can add or delete worksheets as needed to accommodate their specific requirements.Rate this question:
-
- 8.
The Ms office application most appropriate to record the details of a students in calss
- A.
Excel
- B.
Access
- C.
Word
- D.
Power point
Correct Answer
B. AccessExplanation
Access is the most appropriate application in Microsoft Office to record the details of students in a class. Access is a database management system that allows users to store, organize, and retrieve large amounts of data. It provides tools for creating tables, queries, forms, and reports, which are essential for managing student information such as names, IDs, grades, attendance, and more. With Access, users can easily update, sort, and analyze the data, making it an ideal choice for keeping track of student records in a class.Rate this question:
-
- 9.
How Ms word Spell Checker indicate the spelling mistake?
- A.
By bolding the word
- B.
By shading the word
- C.
By a red underline
- D.
By a green underline
Correct Answer
C. By a red underlineExplanation
The correct answer is "By a red underline." In Microsoft Word, the spell checker indicates a spelling mistake by underlining the word with a red line. This helps the user easily identify and correct any spelling errors in their document.Rate this question:
-
- 10.
What is relationship in Ms acess?
- A.
How data in two or more tables are related
- B.
How data in the same coloumn are related
- C.
How data in the same row are related
Correct Answer
A. How data in two or more tables are relatedExplanation
The correct answer is how data in two or more tables are related. In Microsoft Access, a relationship refers to the connection between two tables based on a common field. This relationship allows the database to efficiently organize and retrieve data from multiple tables. By establishing relationships, one can ensure data integrity, enforce referential integrity, and enable the creation of complex queries and reports.Rate this question:
-
Back to top