🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books

Application Software Quiz 17 (10 MCQs)

This set of multiple-choice questions evaluates your understanding of Excel menu navigation, change tracking features, and spreadsheet functionality, including financial tracking and numerical calculations. Additionally, it tests your knowledge of image editing software like Adobe Photoshop, file formats such as PSD, and text editing features in applications like Microsoft Word and Notepad. The questions cover skills such as data organization, worksheet navigation, and application functionality.

Quiz Instructions

Select an option to see the correct answer instantly.

1. Which tab you should go for "Spelling Check"?

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

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

Difficulty: Moderate

Concept notes: In application software, particularly in word processing applications like Microsoft Word, the "Review" tab is where you can find the Spelling and Grammar check feature.

Common Mistakes: A common misunderstanding is that the "Home" tab might contain the Spelling Check feature, as it is often associated with basic editing functions.

Explanations: The "Review" tab in word processing software is designed to help users check and improve the quality of their document. This includes features like Spelling and Grammar check, which are essential for ensuring the document is free of errors. The "Home" tab, on the other hand, is primarily focused on basic text formatting and editing functions, while the "Insert" tab is for adding content like images, tables, and charts. The "Design" tab is typically used for customizing the document's appearance.

Option Analysis:

Option A: The "Home" tab is used for basic text formatting and editing functions, not for Spelling Check.
Option B: The "Insert" tab is used for adding content like images, tables, and charts, not for Spelling Check.
Option C: The "Review" tab is the correct location for Spelling and Grammar check features.
Option D: The "Design" tab is used for customizing the document's appearance, not for Spelling Check.

Mnemonic: R-S-G: Review for Spelling and Grammar.

2. What does the back button do in an application?

Correct Answer: Correct answer is: (C) Goes back to the previous screen.

Exam Relevance: Software Engineering Exams, User Interface Design Exams, Application Development Exams

Difficulty: Easy

Concept notes: In application software, the back button is a common navigation feature that allows users to return to the previous screen or state within the application.

Common Mistakes: A common misunderstanding is that the back button might perform other functions, such as taking pictures or increasing volume, which are not its primary purpose.

Explanations: The back button in application software is designed to navigate users back to the previous screen or state within the application. This functionality is essential for maintaining a smooth and intuitive user experience, allowing users to easily move between different parts of the application without losing their place.

Option Analysis:

Option A: The back button does not take pictures; this is a function typically associated with a camera application or hardware button.
Option B: The back button does not open the home screen; this is usually done by a dedicated home button or gesture.
Option C: The back button goes back to the previous screen, which is the correct function.
Option D: The back button does not increase volume; this is typically controlled by volume buttons or a dedicated control within the application.

3. Mail merge is the process of combining document design with a list to create multiple copies of document for each entry in the list. The list is called

Correct Answer: Correct answer is: (B) Data Source.

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

Difficulty: Easy

Concept notes: In mail merge, the list containing the data to be merged into the document is called the data source.

Common Mistakes: A common mistake is confusing the data source with the main document, which is the template used for the merge.

Explanations: Mail merge involves combining a document template (main document) with a list of data (data source) to create personalized documents for each entry in the list. The data source contains the variable information, such as names and addresses, that will be inserted into the main document.

Option Analysis:

Option A: The main document is the template used for the mail merge, not the list of data.
Option B: The data source is the list of data used in the mail merge process.
Option C: Form label is not a term used in mail merge.
Option D: Database is a broader term and not specifically used in the context of mail merge.

4. Which of the following is a valid file extension forNotepad file?

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

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

Difficulty: Easy

Concept notes: Notepad is a basic text editor that saves files in plain text format.

Common Mistakes: A common mistake is to confuse file extensions for different types of files, such as image files (.jpg) or word processing documents (.doc).

Explanations: Notepad is designed to create and edit plain text files. The standard file extension for plain text files is .txt. This extension indicates that the file contains only text without any formatting or special characters.

Option Analysis:

Option A: .jpg is an image file extension, not used for text files.
Option B: .doc is a Microsoft Word document file extension, not used for plain text files.
Option C: .text is not a standard file extension recognized by Notepad or most operating systems.
Option D: .txt is the correct file extension for plain text files created and edited by Notepad.

5. What do we call a computer program that organizes data in rows and columns of cells? You might use this type of program to keep a record of the money you earned moving lawns over the summer.

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

Exam Relevance: SAT, ACT, AP Computer Science Principles, CompTIA A+

Difficulty: Easy

Concept notes: A spreadsheet program organizes data in rows and columns of cells, making it ideal for tasks such as tracking financial records.

Common Mistakes: A common mistake is confusing a spreadsheet program with a database program, which also organizes data but typically in a more complex structure.

Explanations: A spreadsheet program is designed to organize and manipulate data in a tabular format, with rows and columns of cells. This makes it suitable for tasks such as tracking the money earned from moving lawns over the summer, as it allows for easy data entry, calculation, and analysis.

Option Analysis:

Option A: Correct. Spreadsheet programs organize data in rows and columns of cells, making them ideal for financial tracking and record-keeping.
Option B: Incorrect. Database programs organize data in a more complex structure, typically using tables and relationships, which is not as straightforward for simple record-keeping tasks.
Option C: Incorrect. Word processor programs are designed for creating and editing documents, not for organizing data in rows and columns.
Option D: Incorrect. Desktop publisher programs are used for creating layouts and designs for printed materials, not for organizing data in rows and columns.

6. In Excel you can open the Highlight Changes dialog box by choosing Track Changes from the ..... Menu.

Correct Answer: Correct answer is: D

Exam Relevance: Microsoft Office Specialist, High School Computer Science Exams

Difficulty: Moderate

Concept notes: In Excel, the Highlight Changes feature is accessed through the Tools menu.

Common Mistakes: A common mistake is to assume that changes and tracking features are found under the Edit or Insert menus.

Explanations: The Highlight Changes dialog box in Excel is located under the Tools menu. This is where users can manage and view changes made to the document.

Option Analysis:

Option A: The Edit menu does not contain the Highlight Changes feature.
Option B: The Insert menu is used for inserting elements like cells, rows, and columns, not for tracking changes.
Option C: The Format menu is used for formatting cells, not for tracking changes.
Option D: The Tools menu contains the Highlight Changes feature, which allows users to track and highlight changes made to the document.

7. Software that allows one to calculate numbers in a format that is similar to pages in a conventional ledger.

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

Exam Relevance: CPA Exam, CFA Exam, Microsoft Excel Certification

Difficulty: Easy

Concept notes: A spreadsheet is a computer application that allows users to organize, manipulate, and calculate data in a tabular format, similar to a ledger.

Common Mistakes: A common misunderstanding is that a spreadsheet is only used for financial data. However, spreadsheets can be used for a wide range of data management and analysis tasks.

Explanations: A spreadsheet is the correct answer because it allows users to input, organize, and calculate numbers in a format that resembles pages in a conventional ledger. Spreadsheets provide a grid of cells arranged in rows and columns, enabling users to perform calculations, create charts, and manage data efficiently.

Option Analysis:

Option A: Spreadsheet is the correct answer as it allows for numerical calculations and data organization similar to a ledger.
Option B: Storage refers to the saving of data, not the organization and calculation of numbers.
Option C: Desktop refers to the main screen of a computer, not a specific application for numerical calculations.
Option D: None of the above is incorrect because a spreadsheet is a valid and appropriate answer.

8. Which is used to change the text in Microsoft Word from uppercase to lowercase or a capital letter at the beginning of every word?

Correct Answer: Correct answer is: (A) Shift + F3.

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

Difficulty: Easy

Concept notes: In Microsoft Word, the Shift + F3 key combination is used to cycle through different text case formats, including all uppercase, all lowercase, and title case (capital letter at the beginning of every word).

Common Mistakes: A common mistake is to assume that other key combinations like Shift + F5, Shift + F6, or Shift + F7 might perform the same function, but they do not.

Explanations: The Shift + F3 key combination in Microsoft Word allows users to change the text case format. When selected text is in all uppercase, pressing Shift + F3 will change it to all lowercase. If the text is in all lowercase, pressing Shift + F3 will change it to title case. Pressing Shift + F3 again will cycle through the different case formats.

Option Analysis:

Option A: Correct. Shift + F3 is the correct key combination to change text case in Microsoft Word.
Option B: Incorrect. Shift + F5 is used to repeat the last action, not to change text case.
Option C: Incorrect. Shift + F7 is used to open the Thesaurus, not to change text case.
Option D: Incorrect. Shift + F6 is not a standard key combination for changing text case in Microsoft Word.

9. In Excel you can use the horizontal and vertical scroll bars to

Correct Answer: Correct answer is: (B) View different rows and columns.

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

Difficulty: Easy

Concept notes: In Excel, the horizontal and vertical scroll bars are used to navigate through the worksheet and view different rows and columns.

Common Mistakes: A common misunderstanding is that the scroll bars are used for other functions such as splitting the worksheet or editing cell contents.

Explanations: The horizontal scroll bar allows you to move left and right through the columns of the worksheet, while the vertical scroll bar allows you to move up and down through the rows. This functionality is essential for navigating large datasets and viewing different parts of the worksheet.

Option Analysis:

Option A: The scroll bars do not split the worksheet into panes; this is done using the "Split" feature in Excel.
Option B: The scroll bars are used to view different rows and columns, which is the correct function.
Option C: The scroll bars do not allow you to edit the contents of a cell; this is done by clicking on the cell and typing.
Option D: The scroll bars do not allow you to view different worksheets; this is done by clicking on the sheet tabs at the bottom of the Excel window.

10. Which file format is for Photoshop?

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

Exam Relevance: CompTIA A+, Adobe Certified Associate (ACA)

Difficulty: Easy

Concept notes: PSD is the file format used by Adobe Photoshop for saving files that retain all the layers, adjustments, and other elements of the image.

Common Mistakes: A common mistake is to confuse PSD with JPEG, which is a widely used image format but does not retain the layer information.

Explanations: PSD stands for Photoshop Document and is the native file format for Adobe Photoshop. It is designed to preserve all the layers, masks, and other editing features of an image, making it ideal for saving work-in-progress files. Other formats like JPEG, ODT, and DOC do not retain these features.

Option Analysis:

Option A: JPEG is a widely used image format but does not retain layer information.
Option B: PSD is the correct file format for Photoshop, preserving all layers and editing features.
Option C: ODT is an open document text format used for word processing documents, not for images.
Option D: DOC is a Microsoft Word document format, used for text documents, not for images.

Frequently Asked Questions

What is the primary function of application software like Microsoft Word?

Microsoft Word is a word processing application used for creating, editing, and formatting documents. It includes features such as spell check, mail merge, and document templates.

How does Excel support financial tracking and numerical calculations?

Excel is a spreadsheet program that organizes data into rows and columns, allowing users to perform complex financial tracking and numerical calculations. It includes functions for financial analysis and data organization.

What is the PSD format used for in image editing?

PSD format is a proprietary file format used by Adobe Photoshop for storing editable image files. It supports layers, masks, and other advanced editing features, making it ideal for professional image editing.

How can the Track Changes feature in Microsoft Word be useful?

The Track Changes feature in Microsoft Word allows users to see all modifications made to a document, including additions, deletions, and formatting changes. This is useful for collaborative editing and reviewing documents.

What is the purpose of the Notepad application?

Notepad is a simple text editor that allows users to create and edit plain text files. It is useful for writing notes, creating scripts, and editing configuration files without any complex formatting options.

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