🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books

Application Software Quiz 38 (10 MCQs)

This set of multiple-choice questions evaluates understanding of application software, including document management, spreadsheet functions, and word processor features. Topics covered include file types, document customization, data organization, and navigation. Skills tested include the use of Excel, MS-Word shortcuts, and the sum function, as well as the ability to create graphs and bypass the Recycle Bin for permanent deletion.

Quiz Instructions

Select an option to see the correct answer instantly.

1. A spreadsheet is a document that stores data in a grid of horizontal rows and vertical columns.

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

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

Difficulty: Easy

Concept notes: A spreadsheet is a document that organizes and stores data in a grid format with rows and columns.

Common Mistakes: A common misunderstanding is confusing a spreadsheet with a row or column, which are components of a spreadsheet rather than the document itself.

Explanations: A spreadsheet is a document that stores data in a grid format, where data is organized into rows and columns. This structure allows for easy manipulation, analysis, and visualization of data. The other options (Row, Minus, Plus) do not describe a document that organizes data in a grid format.

Option Analysis:

Option A: Row is a component of a spreadsheet, not the document itself.
Option B: Spreadsheet is the correct term for a document that organizes data in a grid format.
Option C: Minus is an arithmetic operation, not a document type.
Option D: Plus is an arithmetic operation, not a document type.

2. Which menu/tab option contains the command to create a WordArt graphic in a word processor?

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

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

Difficulty: Easy

Concept notes: In word processors, the "Insert" tab or menu is where you find commands to add various elements to your document, such as images, shapes, and WordArt.

Common Mistakes: A common mistake is to assume that WordArt might be found under the "Design" or "Format" tabs, which are typically used for document layout and formatting, not for inserting new elements.

Explanations: WordArt is a feature that allows you to create stylized text graphics. In most word processors, such as Microsoft Word, the command to create WordArt is located in the "Insert" tab. This tab is dedicated to adding various types of content to your document, including text effects, images, and other graphical elements.

Option Analysis:

Option A: The "Design" tab is typically used for document layout and theme customization, not for inserting new elements like WordArt.
Option B: The "Insert" tab is the correct location for adding elements such as WordArt to a document.
Option C: The "File" tab is used for document management tasks like saving, opening, and printing, not for inserting content.
Option D: The "Format" tab is generally used for adjusting the appearance of selected elements, not for inserting new content.

3. You are buying a new cell phone but the comparing some models to see what will work best for you. What are two things you can do with a smartphone that you cannot do with a basic cellular phone? (Choose two)

Correct Answer: Correct answer is: (D) Only (A) & (B).

Exam Relevance: IT certification exams, Computer Science exams, Technology literacy tests

Difficulty: Moderate

Concept notes: Smartphones have advanced capabilities compared to basic cellular phones, including browsing the internet and editing documents, which are not typically available on basic cellular phones.

Common Mistakes: A common misunderstanding is that basic cellular phones can perform all the functions of a smartphone, but they lack the advanced software and hardware necessary for internet browsing and document editing.

Explanations: Smartphones are equipped with application software that allows users to browse the internet similarly to a computer and edit documents. Basic cellular phones, on the other hand, are limited to basic functionalities such as making calls, sending text messages, and accessing voicemail. Therefore, browsing the internet and editing documents are capabilities exclusive to smartphones.

Option Analysis:

Option A: Browsing the Internet similarly to a computer is a feature of smartphones but not basic cellular phones.
Option B: Editing a document is a feature of smartphones but not basic cellular phones.
Option C: Accessing voicemail is a basic functionality available on both smartphones and basic cellular phones.
Option D: Only (A) & (B) are correct as they are exclusive features of smartphones.

4. Tab scrolling button

Correct Answer: Correct answer is: (D) Allow you to view additional sheets tabs.

Exam Relevance: Microsoft Excel Certification, Google Sheets Certification, Spreadsheet Proficiency Tests

Difficulty: Moderate

Concept notes: In application software, particularly spreadsheet applications like Microsoft Excel, the tab scrolling button allows users to navigate through multiple sheets within a workbook.

Common Mistakes: A common misunderstanding is that the tab scrolling button is used to view additional rows or columns within a single worksheet, rather than to navigate between different sheets.

Explanations: The tab scrolling button in spreadsheet applications is specifically designed to allow users to view and switch between different sheets within a workbook. This feature is essential for managing multiple sheets efficiently, as it enables users to quickly access and work on different sheets without having to manually click through each one.

Option Analysis:

Option A: This option is incorrect because the tab scrolling button does not allow you to view a different worksheet; it allows you to navigate between different sheets within the same workbook.
Option B: This option is incorrect because the tab scrolling button does not allow you to view additional worksheet rows down; this function is typically handled by scrolling within the worksheet itself.
Option C: This option is incorrect because the tab scrolling button does not allow you to view additional worksheet columns to the right; this function is also typically handled by scrolling within the worksheet itself.
Option D: This option is correct because the tab scrolling button allows you to view additional sheets tabs, enabling you to navigate between different sheets within the workbook.

Mnemonic: Tabs to Sheets, Not Rows or Columns

5. This is a free and open-source wiki engine.

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

Exam Relevance: Certified Information Systems Security Professional (CISSP), CompTIA Security+, Certified Ethical Hacker (CEH)

Difficulty: Moderate

Concept notes: Mediawiki is a free and open-source wiki engine used to create and manage wiki websites.

Common Mistakes: A common mistake is confusing Mediawiki with other Wikimedia projects like Wikidata, Wikibooks, or Wikimedia Commons, which are specific content repositories rather than wiki engines.

Explanations: Mediawiki is a software application that allows users to create and manage wiki websites. It is free and open-source, meaning it can be used, modified, and distributed without cost. This makes it a popular choice for creating collaborative websites where content can be edited by multiple users. Other options like Wikidata, Wikibooks, and Wikimedia Commons are specific projects that use Mediawiki as their underlying software, but they are not wiki engines themselves.

Option Analysis:

Option A: Wikidata is a Wikimedia project that provides structured data, not a wiki engine.
Option B: Mediawiki is a free and open-source wiki engine, which fits the description.
Option C: Wikibooks is a Wikimedia project for creating open-content textbooks, not a wiki engine.
Option D: Wikimedia Commons is a Wikimedia project for storing and sharing media files, not a wiki engine.

6. In MS-Word shortcut SHIFT+DELETE is used to

Correct Answer: Correct answer is: (A) Delete the selected item permanently without placing the item in the Recycle Bin.

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

Difficulty: Moderate

Concept notes: In MS-Word, the shortcut SHIFT+DELETE is used to permanently delete selected items without sending them to the Recycle Bin.

Common Mistakes: A common misunderstanding is that the DELETE key alone performs a permanent deletion. However, the DELETE key typically moves items to the Recycle Bin, while SHIFT+DELETE bypasses the Recycle Bin.

Explanations: The shortcut SHIFT+DELETE in MS-Word is specifically designed to delete items permanently, bypassing the Recycle Bin. This means the selected item is immediately and irreversibly removed from the system, without the option to recover it from the Recycle Bin.

Option Analysis:

Option A: Correct. This is the function of the SHIFT+DELETE shortcut in MS-Word.
Option B: Incorrect. The shortcut for copying is typically CTRL+C.
Option C: Incorrect. Renaming items is not a function of the SHIFT+DELETE shortcut.
Option D: Incorrect. Creating a shortcut is not a function of the SHIFT+DELETE shortcut.

7. The ..... program is used to create mathematical tables and graphs.

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

Exam Relevance: Microsoft Office Specialist, CompTIA A+, CCNA

Difficulty: Easy

Concept notes: Excel is a spreadsheet application that is widely used for creating mathematical tables and graphs.

Common Mistakes: A common misunderstanding is that Word or PowerPoint might be used for creating mathematical tables and graphs, but these programs are primarily designed for text and presentation purposes, respectively.

Explanations: Excel is specifically designed to handle numerical data and can easily create tables and graphs. It includes features such as formulas, charts, and pivot tables that are useful for mathematical and statistical analysis.

Option Analysis:

Option A: Word is a word processing program primarily used for creating documents with text and formatting, not for mathematical tables and graphs.
Option B: Excel is a spreadsheet program that is well-suited for creating mathematical tables and graphs.
Option C: PowerPoint is a presentation program used for creating slideshows, not for creating mathematical tables and graphs.
Option D: None of the above is incorrect because Excel is the correct choice.

8. Which of the following is an example of application software?

Correct Answer: Correct answer is: (C) Microsoft Word.

Exam Relevance: CompTIA A+, Microsoft Certified: Modern Desktop Administrator Associate, CIW Web Foundations Associate

Difficulty: Easy

Concept notes: Application software refers to programs designed to perform specific tasks for end-users, such as word processing, spreadsheets, or media players. In contrast, operating systems like Microsoft Windows, Linux, and MacOS are system software that manage computer hardware and provide a platform for running application software.

Common Mistakes: A common mistake is confusing operating systems with application software. Operating systems are not designed to perform specific tasks for end-users but rather to manage the computer's hardware and provide a platform for running other software.

Explanations: Microsoft Word is an example of application software because it is designed to perform specific tasks such as creating, editing, and formatting documents. It is not responsible for managing the computer's hardware or providing a platform for other software, which are functions of operating systems.

Option Analysis:

Option A: Microsoft Windows is an operating system, not application software.
Option B: Linux is an operating system, not application software.
Option C: Microsoft Word is an application software designed for word processing.
Option D: MacOS is an operating system, not application software.

9. Which of the following is a valid ending for a word file?

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

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

Difficulty: Easy

Concept notes: File extensions are used to identify the type of file. In application software, ".doc" is a common file extension for Microsoft Word documents.

Common Mistakes: A common mistake is to confuse file extensions with other file types or formats that are not specific to Word documents.

Explanations: The ".doc" file extension is specifically used for Microsoft Word documents. This extension indicates that the file is a Word document and can be opened and edited using Microsoft Word or compatible software.

Option Analysis:

Option A: "Xis" is not a standard file extension for any common document type.
Option B: "Wmv" is a file extension for Windows Media Video files, not for Word documents.
Option C: "Roc" is not a standard file extension for any common document type.
Option D: "Doc" is the correct file extension for Microsoft Word documents.

10. Which function is used to add numbers in a spreadsheet?

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

Exam Relevance: Microsoft Excel, Google Sheets, Spreadsheet Certification Exams

Difficulty: Easy

Concept notes: The function used to add numbers in a spreadsheet is Sum().

Common Mistakes: A common mistake is to assume that other functions like Plus(), Total(), or Add() might be used for addition, but these are not standard functions in spreadsheet software.

Explanations: In spreadsheet software, the Sum() function is specifically designed to add a range of numbers. It is a built-in function that simplifies the process of adding multiple cells or ranges of cells. Other options like Plus(), Total(), and Add() are not recognized functions in spreadsheet software.

Option Analysis:

Option A: Sum() is the correct function for adding numbers in a spreadsheet.
Option B: Plus() is not a standard function in spreadsheet software.
Option C: Total() is not a standard function in spreadsheet software.
Option D: Add() is not a standard function in spreadsheet software.

Frequently Asked Questions

What is application software?

Application software includes programs designed to perform specific tasks, such as word processing, spreadsheets, and data organization.

How can I bypass the Recycle Bin for permanent deletion?

To permanently delete files without sending them to the Recycle Bin, hold down the Shift key while pressing Delete.

What are some common spreadsheet functions?

Common spreadsheet functions include the sum function for addition, graph creation, and data organization in grid format.

What is a wiki engine?

A wiki engine is a software application that allows users to create, edit, and link web pages easily, such as MediaWiki.

What are the limitations of basic cellular phones compared to smartphones?

Basic cellular phones typically lack advanced features like internet access, apps, and multimedia capabilities that are common in smartphones.

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