🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books

Application Software Quiz 21 (10 MCQs)

This set of multiple-choice questions evaluates understanding of application software, including keyboard shortcuts, file operations, and the use of Microsoft Excel and PowerPoint. It covers data manipulation, spreadsheet formulas, visual effects, and internet image insertion. Skills in document creation, text editing, and spell checking are also assessed.

Quiz Instructions

Select an option to see the correct answer instantly.

1. Type of File Spreadsheet

Correct Answer: Correct answer is: (A) . xls.

Exam Relevance: Microsoft Office Certification, IT Certification Exams, Spreadsheet Software Exams

Difficulty: Easy

Concept notes: The .xls file extension is commonly associated with Microsoft Excel, which is a spreadsheet application software.

Common Mistakes: A common misunderstanding is that other file types like .htm, .txt, or .bmp could be used for spreadsheets, but these are typically used for web pages, text documents, and images, respectively.

Explanations: The .xls file extension is specifically designed for spreadsheet data and is used by Microsoft Excel, a widely used application software for managing and analyzing data in tabular form. Other file types listed are not designed for spreadsheet functionality.

Option Analysis:

Option A: .xls is the correct file extension for spreadsheets.
Option B: .htm and .html are file extensions for web pages, not spreadsheets.
Option C: .txt, .dat, .rtf, .docx, and .doc are file extensions for text documents, not spreadsheets.
Option D: .bmp is a file extension for bitmap images, not spreadsheets.

2. Used for creating, editing, storing and printing.

Correct Answer: Correct answer is: (B) Word Processor.

Exam Relevance: Microsoft Office Certification, Google Workspace Certification, CompTIA A+

Difficulty: Easy

Concept notes: Word processors are designed for creating, editing, storing, and printing documents. They are commonly used for writing letters, reports, and other text-based documents.

Common Mistakes: A common misunderstanding is that spreadsheets are used for creating and editing documents, but spreadsheets are primarily used for organizing and analyzing numerical data.

Explanations: Word processors are specifically designed for creating, editing, storing, and printing text-based documents. They offer features such as text formatting, spell checking, and document layout, making them ideal for tasks such as writing letters, reports, and other text-based documents.

Option Analysis:

Option A: Spreadsheet software is primarily used for organizing and analyzing numerical data, not for creating and editing text-based documents.
Option B: Word processors are designed for creating, editing, storing, and printing text-based documents, making this the correct choice.
Option C: Presentation software is used for creating visual presentations, not for creating and editing text-based documents.
Option D: Computer software is a broad term that encompasses many types of software, including word processors, but it is not specific to the task described.

3. They normally interact with the system via user interface provided by the application software.

Correct Answer: Correct answer is: (C) Users.

Exam Relevance: CompTIA A+, CIW, Microsoft Certified: Azure Fundamentals

Difficulty: Easy

Concept notes: Application software provides a user interface that allows users to interact with the system.

Common Mistakes: A common misunderstanding is that developers or programmers interact directly with the system through the user interface, but this is not typically the case.

Explanations: Users interact with the system via the user interface provided by the application software. This interface is designed to make the system accessible and usable for end-users, not for developers or testers.

Option Analysis:

Option A: Programmers typically interact with the system through code and development environments, not the user interface provided by application software.
Option B: Developers also interact with the system through code and development environments, not the user interface provided by application software.
Option C: Users interact with the system via the user interface provided by the application software, making this the correct answer.
Option D: Testers interact with the system through testing environments and tools, not the user interface provided by application software.

4. The spelling dialog box can be involved by choosing spelling from ..... menu.

Correct Answer: Correct answer is: (C) Tools.

Exam Relevance: Microsoft Office Certification, CompTIA A+, Google Workspace Certification

Difficulty: Easy

Concept notes: In application software, particularly word processors and text editors, the spelling dialog box is typically accessed through the "Tools" menu.

Common Mistakes: A common misunderstanding is that the spelling function might be found under the "Insert" or "File" menu, but it is usually located under the "Tools" menu.

Explanations: The spelling dialog box is a feature commonly found in word processing software, such as Microsoft Word. This feature is typically accessed via the "Tools" menu, which contains various utility functions for editing and enhancing text. The "Tools" menu is designed to provide users with a range of options for improving the quality and accuracy of their documents, including spelling and grammar checks.

Option Analysis:

Option A: The "Insert" menu is used for adding content such as images, tables, and text boxes, not for spelling checks.
Option B: The "File" menu is used for file management tasks such as opening, saving, and printing documents, not for spelling checks.
Option C: The "Tools" menu contains various utility functions, including the spelling dialog box.
Option D: The "View" menu is used for changing the display settings of the document, not for spelling checks.

5. Which of the following shortcut is used to copy a file?

Correct Answer: Correct answer is: (B) Ctrl + C.

Exam Relevance: Microsoft Office Specialist, CompTIA A+, Google IT Support

Difficulty: Easy

Concept notes: In application software, the shortcut Ctrl + C is used to copy a file or selected content.

Common Mistakes: A common mistake is confusing Ctrl + C with other shortcuts like Ctrl + V (paste) or Ctrl + X (cut).

Explanations: The shortcut Ctrl + C is specifically designed to copy selected content or files in application software. This function allows users to duplicate the selected item without removing the original, making it a fundamental operation in file management and text editing.

Option Analysis:

Option A: Ctrl + T is typically used to open a new tab in web browsers, not for copying files.
Option B: Ctrl + C is the correct shortcut for copying files or content.
Option C: Ctrl + Z is used to undo the last action, not for copying files.
Option D: Ctrl + X is used to cut files or content, not to copy them.

Mnemonic: Copy = C, Cut = X, Paste = V

6. A ..... is a special visual and audio effect applied in Power-point to text or content

Correct Answer: Correct answer is: (B) Animation.

Exam Relevance: Microsoft Office Specialist, CompTIA A+, ITIL Foundation

Difficulty: Easy

Concept notes: In application software like Microsoft PowerPoint, an animation is a special visual and audio effect applied to text or content to enhance the presentation.

Common Mistakes: A common misunderstanding is that terms like "wipe" or "dissolve" are standalone effects, but they are actually types of animations.

Explanations: Animations in PowerPoint are used to add visual and audio effects to text or content, making the presentation more engaging and dynamic. The term "animation" encompasses various effects such as wipes, fades, and dissolves.

Option Analysis:

Option A: Wipe is a type of animation effect, not a standalone term for all visual and audio effects.
Option B: Animation is the correct term for the special visual and audio effects applied to text or content in PowerPoint.
Option C: Flash is a specific type of animation effect, not a general term for all visual and audio effects.
Option D: Dissolve is another type of animation effect, not a general term for all visual and audio effects.

7. Consider the following Statements: Lossy compression would be suitable for text files MS Office is application software Python is an example of a High Level programming language Which of the following statement(s) is/are true?

Correct Answer: Correct answer is: (D) Only 2, 3.

Exam Relevance: Computer Science Exams, IT Certification Exams, Programming Competitions

Difficulty: Easy

Concept notes: Application software refers to programs designed to perform specific tasks for end-users. MS Office is an example of application software, and Python is a high-level programming language.

Common Mistakes: A common mistake is to assume that lossy compression is suitable for text files, which is incorrect because lossy compression can degrade the quality of the text, making it unsuitable for text files.

Explanations: MS Office is application software, which is true. Python is a high-level programming language, which is also true. Lossy compression is not suitable for text files because it can introduce errors and degrade the quality of the text, making it unsuitable for text files.

Option Analysis:

Option A: Incorrect because statement 1 is false.
Option B: Incorrect because statement 1 is false.
Option C: Incorrect because statement 1 is false.
Option D: Correct because statements 2 and 3 are true.

8. The PC productivity tool that manipulates data organized in rows and columns is called a .....

Correct Answer: Correct answer is: (A) Spreadsheet.

Exam Relevance: Certified Information Systems Manager (CISM), Certified Information Systems Auditor (CISA), CompTIA A+

Difficulty: Easy

Concept notes: A spreadsheet is a computer application that allows users to organize, manipulate, and analyze data in a tabular format, typically arranged in rows and columns.

Common Mistakes: A common misunderstanding is that a presentation mechanism (like PowerPoint) or a database record manager (like a database management system) might be the correct answer, but these tools do not primarily focus on manipulating data in rows and columns.

Explanations: A spreadsheet is designed to handle data organized in rows and columns, allowing users to perform various operations such as calculations, sorting, and filtering. This makes it the most appropriate tool for the described function.

Option Analysis:

Option A: Correct. A spreadsheet is the tool that manipulates data organized in rows and columns.
Option B: Incorrect. A presentation mechanism is used for creating and delivering presentations, not for manipulating data in rows and columns.
Option C: Incorrect. A database record manager is used for managing and organizing large sets of data, but it does not primarily focus on manipulating data in rows and columns.
Option D: Incorrect. An EDI creator is used for creating electronic data interchange documents, which is unrelated to manipulating data in rows and columns.

9. To insert picture from internet click on .....

Correct Answer: Correct answer is: (C) Online picture.

Exam Relevance: Microsoft Office Certification, Google Workspace Certification, ITIL Foundation

Difficulty: Easy

Concept notes: In application software, particularly in word processing programs like Microsoft Word, the option to insert a picture from the internet is typically found under the "Online picture" feature.

Common Mistakes: A common mistake is to confuse "Online picture" with other options like "Word art" or "Picture," which are used for different purposes.

Explanations: The "Online picture" option allows users to browse and insert images directly from the internet into their document. This feature is specifically designed for this purpose, making it the correct choice for inserting pictures from the internet.

Option Analysis:

Option A: Word art is used for creating artistic text effects and is not related to inserting pictures from the internet.
Option B: Picture is typically used for inserting local images stored on the user's device, not from the internet.
Option C: Online picture is the correct choice for inserting images from the internet.
Option D: None of the above is incorrect because "Online picture" is a valid option.

10. How do you enter a formula in a spreadsheet?

Correct Answer: Correct answer is: (D) Start with an '=' sign.

Exam Relevance: Microsoft Excel Certification, Google Sheets Certification, CPA Exam

Difficulty: Easy

Concept notes: In spreadsheet applications, formulas are used to perform calculations and data manipulations. Formulas always begin with an '=' sign to indicate that the cell contains a formula rather than static text or a number.

Common Mistakes: A common mistake is to start a formula with a '+' sign, which is incorrect. The '+' sign is used within the formula for addition, but not to initiate the formula itself.

Explanations: In spreadsheet software, such as Microsoft Excel or Google Sheets, formulas are used to perform calculations and data manipulations. To indicate that a cell contains a formula, the input must start with an '=' sign. This tells the spreadsheet application to interpret the subsequent characters as a formula rather than as plain text or a static value.

Option Analysis:

Option A: Starting a formula with a '+' sign is incorrect. The '+' sign is used for addition within the formula, but not to initiate the formula itself.
Option B: Starting a formula with a '-' sign is incorrect. The '-' sign is used for subtraction within the formula, but not to initiate the formula itself.
Option C: Starting a formula with a '#' sign is incorrect. The '#' sign is not used to initiate a formula in spreadsheet applications.
Option D: Starting a formula with an '=' sign is correct. This is the standard way to indicate that a cell contains a formula in spreadsheet applications.

Frequently Asked Questions

What is application software?

Application software includes programs designed to perform specific tasks for end-users, such as word processing, spreadsheet creation, and presentation design.

How can I use keyboard shortcuts to improve efficiency in application software?

Keyboard shortcuts can speed up common tasks, such as using Ctrl+C to copy and Ctrl+V to paste, reducing the need to navigate through menus.

What is the purpose of spreadsheet formulas?

Spreadsheet formulas allow users to perform calculations and data manipulation within a spreadsheet, often using an equal sign to initiate the formula.

How do visual effects enhance presentations in application software?

Visual effects, such as animations and audio effects, can make presentations more engaging and help convey information more effectively to the audience.

What is the role of the tools menu in application software?

The tools menu provides access to various utilities and features that assist with tasks like spell checking, file management, and inserting images from the internet.

🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books