II Sem Bba MS Office Objective Test

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.