II Sem Bba MS Office Objective Test

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Abbasvattoli
A
Abbasvattoli
Community Contributor
Quizzes Created: 1 | Total Attempts: 391
Questions: 10 | Attempts: 392

SettingsSettingsSettings
Microsoft Office Quizzes & Trivia

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 processing
    Explanation
    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 database
    Explanation
    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 bar
    Explanation
    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. F5
    Explanation
    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 excel
    Explanation
    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. Macros
    Explanation
    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. 3
    Explanation
    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. Access
    Explanation
    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 underline
    Explanation
    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 related
    Explanation
    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:

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 21, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • May 03, 2010
    Quiz Created by
    Abbasvattoli
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.