🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books

Application Software Quiz 22 (10 MCQs)

This set of multiple-choice questions evaluates understanding of application software functionality, including basic arithmetic operations, spreadsheet features, and presentation software capabilities. It covers topics such as the Excel formula bar, file menu navigation, document creation, and proprietary software disadvantages. The questions assess skills in data management, cell content display, and the use of software like Microsoft Excel and PowerPoint.

Quiz Instructions

Select an option to see the correct answer instantly.

1. How do you create a new document/canvas:

Correct Answer: Correct answer is: (C) File > New.

Exam Relevance: Microsoft Office Certification, Adobe Certification, CompTIA A+

Difficulty: Easy

Concept notes: In application software, creating a new document or canvas is typically done through the "File" menu, specifically the "New" option.

Common Mistakes: A common misunderstanding is that "File > Save" or "File > Open" might be used to create a new document, but these options are for saving existing work or opening existing files, respectively.

Explanations: The "File > New" option is the standard method in most application software to create a new document or canvas. This action initializes a new workspace where users can start working without any existing content.

Option Analysis:

Option A: "File > Save" is used to save the current document, not to create a new one.
Option B: "File > Open" is used to open an existing document, not to create a new one.
Option C: "File > New" is the correct option to create a new document or canvas.
Option D: "File > Export" is used to export the current document to another format, not to create a new one.

2. In Excel the following displays the contents of the active cell

Correct Answer: Correct answer is: (B) Formula bar.

Exam Relevance: Microsoft Office Specialist, CompTIA A+, Certified Administrative Professional

Difficulty: Easy

Concept notes: The formula bar in Excel displays the contents of the active cell, including any formulas or values.

Common Mistakes: A common misunderstanding is that the active cell itself displays its contents, but the active cell only highlights the selected cell, not its contents.

Explanations: The formula bar is the designated area in Excel where the contents of the active cell are displayed. This includes any text, numbers, or formulas present in the cell. The active cell itself is highlighted, but it does not show the cell's contents directly.

Option Analysis:

Option A: The active cell is the cell that is currently selected, but it does not display the cell's contents.
Option B: The formula bar correctly displays the contents of the active cell.
Option C: The menu bar contains commands and options for various Excel functions, not cell contents.
Option D: The name box shows the address of the active cell, not its contents.

3. What is the primary function of System Calculator?

Correct Answer: Correct answer is: (D) To perform basic arithmetic operations.

Exam Relevance: Computer Science Exams, IT Certification Exams, Basic Software Skills Assessments

Difficulty: Easy

Concept notes: System Calculator is a type of application software designed to perform basic arithmetic operations such as addition, subtraction, multiplication, and division.

Common Mistakes: A common misunderstanding is that System Calculator can perform advanced mathematical functions or provide step-by-step solutions, which are typically features of more specialized software.

Explanations: System Calculator is primarily designed to handle basic arithmetic operations, making it suitable for simple calculations. It does not have the capability to perform advanced mathematical calculations, create interactive graphs and charts, or provide step-by-step solutions to math problems.

Option Analysis:

Option A: System Calculator does not perform advanced mathematical calculations.
Option B: Creating interactive graphs and charts is not a function of System Calculator.
Option C: Providing step-by-step solutions to math problems is not a feature of System Calculator.
Option D: System Calculator is designed to perform basic arithmetic operations.

4. A competitor to the dominant Lotus 1-2-3 is

Correct Answer: Correct answer is: (A) Microsoft Excel.

Difficulty: Easy

Concept notes: Lotus 1-2-3 was a dominant spreadsheet software in the 1980s and early 1990s. Microsoft Excel emerged as a significant competitor and eventually became the leading spreadsheet application.

Common Mistakes: A common mistake is confusing Microsoft Excel with other Microsoft Office applications like Word or PowerPoint, which are not spreadsheet software.

Explanations: Lotus 1-2-3 was a pioneering spreadsheet software, but Microsoft Excel became a major competitor and eventually surpassed it in popularity and functionality.

Option Analysis:

Option A: Microsoft Excel is a spreadsheet software that competes with Lotus 1-2-3.
Option B: Microsoft Word is a word processing software, not a spreadsheet application.
Option C: Microsoft PowerPoint is a presentation software, not a spreadsheet application.
Option D: This option is incorrect as Microsoft Excel is a valid competitor to Lotus 1-2-3.

5. In Microsoft PowerPoint which of the following should you do to bring a bullet back to a previous level?

Correct Answer: Correct answer is: (A) Press the shift + tab keys.

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

Difficulty: Moderate

Concept notes: In Microsoft PowerPoint, the Shift + Tab keys are used to move a bullet point to a previous level in the bullet hierarchy.

Common Mistakes: A common mistake is to use the Tab key, which moves the bullet point to the next level, rather than the previous level.

Explanations: In PowerPoint, the Tab key is used to indent a bullet point, moving it to a lower level in the hierarchy. Conversely, the Shift + Tab keys are used to outdent a bullet point, moving it to a higher level. This is the correct method to bring a bullet back to a previous level.

Option Analysis:

Option A: Correct. Pressing Shift + Tab keys moves the bullet point to a previous level.
Option B: Incorrect. Pressing the Shift key alone does not affect the bullet point's level.
Option C: Incorrect. Pressing the Enter key creates a new bullet point at the same level.
Option D: Incorrect. Pressing the Tab key indents the bullet point to a lower level.

6. One disadvantage of using proprietary licensed software is that .....

Correct Answer: Correct answer is: (B) The software company may decide to discontinue support for the product.

Exam Relevance: CompTIA A+, CIW, Microsoft Certified: Technology Associate (MTA)

Difficulty: Moderate

Concept notes: Proprietary licensed software is developed and owned by a specific company. One of the disadvantages is that the company can choose to stop supporting the software, leaving users without updates, patches, or technical support.

Common Mistakes: A common misunderstanding is that proprietary software is inherently less user-friendly or has weaker support compared to other types of software. However, the key disadvantage here is the risk of discontinued support.

Explanations: Proprietary licensed software is developed and owned by a specific company. The company has the authority to decide whether to continue supporting the software or to discontinue it. If the company decides to discontinue support, users may be left without updates, security patches, or technical assistance, which can be a significant disadvantage.

Option Analysis:

Option A: This is incorrect because proprietary licensed software can be upgraded, but the company controls the upgrade process.
Option B: This is correct because the software company has the authority to discontinue support for the product, which is a significant disadvantage.
Option C: This is incorrect because proprietary licensed software often comes with strong training, help, and support, especially from the software company.
Option D: This is incorrect because user-friendliness is not inherently a disadvantage of proprietary licensed software; it depends on the specific software and its design.

7. The shortcut combination to save is..

Correct Answer: Correct answer is: (A) CTRL-S.

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

Difficulty: Very Easy

Concept notes: The shortcut combination to save a file in most application software is CTRL-S.

Common Mistakes: A common mistake is confusing the save shortcut with other common shortcuts, such as CTRL-V, which is used for paste.

Explanations: In application software, the shortcut combination CTRL-S is universally recognized for saving a file. This is a standard convention across many applications, including word processors, spreadsheets, and design software. The combination is designed to be easily remembered and quickly accessible, making it a widely adopted standard.

Option Analysis:

Option A: Correct. The shortcut combination to save a file is CTRL-S.
Option B: Incorrect. CTRL-V is the shortcut for paste, not save.
Option C: Incorrect. Only CTRL-S is the correct shortcut for save.
Option D: Incorrect. CTRL-S is the correct shortcut for save.

Mnemonic: Save = S, Shortcut = C, Together = CTRL-S

8. In Microsoft PowerPoint the following is not a feature of PowerPoint

Correct Answer: Correct answer is: (C) Linking a slide transition with a laser pointer.

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

Difficulty: Moderate

Concept notes: PowerPoint is a presentation software that allows users to create, edit, and present slides. It includes features such as printing transparencies, printing speaker's notes, and drawing with a pen. However, linking a slide transition with a laser pointer is not a feature of PowerPoint.

Common Mistakes: A common misunderstanding is that PowerPoint includes advanced interactive features like linking transitions to a laser pointer, which is not true.

Explanations: PowerPoint provides various functionalities for creating and presenting slides, including printing options and drawing tools. However, it does not have the capability to link slide transitions with a laser pointer. This feature is not part of the standard PowerPoint software.

Option Analysis:

Option A: PowerPoint allows users to print transparencies for presentations. This is a valid feature.
Option B: PowerPoint supports printing speaker's notes along with slide images, which is a standard feature.
Option C: PowerPoint does not have the capability to link slide transitions with a laser pointer. This is the correct answer as it is not a feature of PowerPoint.
Option D: PowerPoint includes a drawing tool that allows users to draw with a pen during presentations. This is a valid feature.

9. In Normal view, this tab displays the content of each slide.

Correct Answer: Correct answer is: (D) Outline.

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

Difficulty: Moderate

Concept notes: In Normal view, the Outline tab displays the content of each slide in a text-based format, allowing users to view and edit the text of the slides.

Common Mistakes: A common misunderstanding is that the Slides tab would display the content of each slide, but it typically shows thumbnails of the slides rather than the text content.

Explanations: The Outline tab in Normal view provides a text-based view of the slide content, making it easier to review and edit the text of each slide. This is particularly useful for organizing and revising the content of a presentation without focusing on the visual layout.

Option Analysis:

Option A: The Slides tab typically displays thumbnails of each slide, not the text content.
Option B: The View tab is used to switch between different views (Normal, Slide Sorter, etc.), not to display slide content.
Option C: The Sort option is not a tab in Normal view and is not related to displaying slide content.
Option D: The Outline tab displays the text content of each slide in a text-based format, making it the correct choice.

10. Which of the following is not a part of Microsoft Excel?

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

Exam Relevance: Microsoft Office Specialist, CompTIA A+, Certified Information Systems Manager (CISM)

Difficulty: Very Easy

Concept notes: Microsoft Excel is a spreadsheet application used for organizing, analyzing, and visualizing data. It does not include features for creating animations.

Common Mistakes: A common misunderstanding is that Excel can perform all types of data manipulation and visualization, including animation, which is not true.

Explanations: Microsoft Excel is designed for data management and analysis, featuring elements such as columns, rows, and a formula bar. Animation is not a feature of Excel; it is more commonly associated with presentation software like Microsoft PowerPoint.

Option Analysis:

Option A: Animation is not a feature of Microsoft Excel.
Option B: Columns are a fundamental part of Excel's structure.
Option C: The formula bar is used to enter and edit data and formulas in Excel.
Option D: Rows are a fundamental part of Excel's structure.

Frequently Asked Questions

What is application software?

Application software includes programs designed to perform specific tasks, such as Microsoft Excel for spreadsheets and Microsoft PowerPoint for presentations.

What is the formula bar in Excel used for?

The formula bar in Excel displays the contents of the active cell and allows users to enter or edit formulas and data.

What are some features of Microsoft PowerPoint?

PowerPoint features include slide transitions, animation, and the ability to create and edit presentations with text, images, and multimedia content.

What is the Outline tab in PowerPoint used for?

The Outline tab in PowerPoint helps organize and view the text content of slides in a hierarchical structure, making it easier to manage bullet points and slide content.

What is the difference between proprietary and open-source software?

Proprietary software, like Microsoft Excel, is owned by a company and has restricted access to its source code, while open-source software allows users to modify and distribute the source code freely.

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