🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books

Application Software Quiz 42 (10 MCQs)

This set of multiple-choice questions evaluates your understanding of automatic slide show settings, slide timing, and presentation automation in presentation software. It also covers Excel functions, including formula creation and editing, absolute cell references, and the use of keyboard shortcuts. The questions test your ability to manage documents in Microsoft Word, understand media player compatibility, and recognize file formats such as .wmv. Additionally, it assesses your knowledge of application software, operating system compatibility, and mobile functionalities.

Quiz Instructions

Select an option to see the correct answer instantly.

1. An application that runs the same on multiple operating systems is called .....

Correct Answer: Correct answer is: (B) Cross Platform application.

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

Difficulty: Easy

Concept notes: A cross-platform application is one that can run on multiple operating systems without significant changes.

Common Mistakes: A common misunderstanding is that "device independent" means the same as "cross-platform," but device independence typically refers to hardware compatibility rather than operating system compatibility.

Explanations: A cross-platform application is designed to run on multiple operating systems, such as Windows, macOS, and Linux, without requiring significant modifications. This makes it versatile and widely accessible across different computing environments. The term "cross-platform" directly addresses the ability of the application to function across various operating systems, making it the correct choice.

Option Analysis:

Option A: Device independent application refers to software that can run on different hardware without modification, but it does not specifically address operating system compatibility.
Option B: Cross Platform application is the correct term for software that can run on multiple operating systems.
Option C: None of the above is incorrect because "Cross Platform application" is a valid and accurate term.
Option D: All the above is incorrect because not all options are correct.

2. In Microsoft Word shortcut CTRL+A is to

Correct Answer: Correct answer is: (A) Select all.

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

Difficulty: Very Easy

Concept notes: In Microsoft Word, the shortcut CTRL+A is used to select all content in the document.

Common Mistakes: A common misunderstanding is that CTRL+A only highlights a block of text, but it actually selects the entire document.

Explanations: The shortcut CTRL+A in Microsoft Word is designed to select all content within the document, making it easy to apply formatting or other actions to the entire document at once.

Option Analysis:

Option A: Correct. CTRL+A selects all content in the document.
Option B: Incorrect. Highlighting a block of text is typically done with the mouse or other selection methods, not this shortcut.
Option C: Incorrect. Deleting something is done with the DELETE key or other shortcuts like CTRL+X, not CTRL+A.
Option D: Incorrect. Pasting something is done with the PASTE command or the shortcut CTRL+V, not CTRL+A.

3. Type of software that usually runs on tablets or mobile phones; examples include music streaming, GPS and camera facility (but there are thousands of these available.)

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

Exam Relevance: ITIL Foundation, CompTIA A+, CIW Foundations

Difficulty: Easy

Concept notes: Apps are software applications designed to run on mobile devices such as tablets and smartphones. They provide a wide range of functionalities including music streaming, GPS navigation, and camera features.

Common Mistakes: A common misunderstanding is that apps are only for entertainment, but they can serve a variety of purposes including productivity, education, and communication.

Explanations: Apps are specifically designed to run on mobile devices and provide various functionalities such as music streaming, GPS navigation, and camera features. This makes them the most appropriate answer for the type of software that usually runs on tablets or mobile phones.

Option Analysis:

Option A: Correct. Apps are software applications designed for mobile devices.
Option B: Incorrect. Control/measuring software is typically used for industrial or scientific purposes, not for general mobile device functions.
Option C: Incorrect. Database software is used for managing and storing data, not for mobile device functionalities.
Option D: Incorrect. Spreadsheet software is used for data analysis and management, not for mobile device functionalities.

4. Which video file format is commonly used for Windows Media Player?

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

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

Difficulty: Easy

Concept notes: Windows Media Player is a media player software developed by Microsoft. It supports various video file formats, but .wmv (Windows Media Video) is specifically designed for use with Windows Media Player.

Common Mistakes: A common mistake is to assume that .mp4 or .avi are the primary formats for Windows Media Player, as these formats are widely used across different media players.

Explanations: Windows Media Player is optimized to play .wmv files, which are specifically designed for use with this software. While it can play other formats, .wmv is the native format and is most commonly associated with Windows Media Player.

Option Analysis:

Option A: .mp4 is a widely used video format but is not specific to Windows Media Player.
Option B: .avi is another common video format but is not the primary format for Windows Media Player.
Option C: .wmv is the correct answer as it is specifically designed for use with Windows Media Player.
Option D: .mov is a video format used primarily with Apple's QuickTime player and is not specific to Windows Media Player.

Mnemonic: WMV for Windows Media

5. Which one is an application package?

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

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. Examples include word processors, spreadsheets, and databases.

Common Mistakes: A common mistake is confusing operating systems (like DOS, LINUX, and UBUNTU) with application software. Operating systems manage computer hardware and software resources, while application software provides specific functionalities to users.

Explanations: LOTUS is an application package, specifically known for its spreadsheet software, which is designed to perform specific tasks for end-users. DOS, LINUX, and UBUNTU are operating systems, not application software.

Option Analysis:

Option A: DOS is an operating system, not an application package.
Option B: LOTUS is an application package, specifically known for its spreadsheet software.
Option C: LINUX is an operating system, not an application package.
Option D: UBUNTU is an operating system, not an application package.

6. Which of the following is a presentation program?

Correct Answer: Correct answer is: (C) MS PowerPoint.

Exam Relevance: Microsoft Office Certification, IT Certification Exams, Computer Literacy Tests

Difficulty: Easy

Concept notes: MS PowerPoint is a presentation program used to create and deliver slide shows. It is part of the Microsoft Office suite and is specifically designed for creating visual presentations.

Common Mistakes: A common mistake is confusing MS PowerPoint with other Microsoft Office applications like MS Word or MS Excel, which are primarily used for word processing and spreadsheet management, respectively.

Explanations: MS PowerPoint is designed for creating presentations, which typically include slides with text, images, charts, and other visual elements. It is not used for word processing or spreadsheet management, which are the primary functions of MS Word and MS Excel, respectively.

Option Analysis:

Option A: MS Word is a word processing program, not a presentation program.
Option B: MS Excel is a spreadsheet program, not a presentation program.
Option C: MS PowerPoint is a presentation program, used for creating slide shows and visual presentations.
Option D: This option is incorrect as MS PowerPoint is the correct answer.

7. When you want to move some text from one page to different page, the best method is .....

Correct Answer: Correct answer is: (A) Cut and Paste.

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

Difficulty: Easy

Concept notes: The cut and paste function is the most efficient method for moving text from one location to another within a document or between different pages.

Common Mistakes: A common misunderstanding is that deleting and retyping the text is a viable alternative, but this is less efficient and prone to errors.

Explanations: Cut and paste allows you to move text without retyping it, which saves time and reduces the risk of introducing errors. This method is widely used in application software such as word processors and text editors.

Option Analysis:

Option A: Correct. Cut and paste is the most efficient method for moving text.
Option B: Incorrect. Deleting and retyping the text is less efficient and error-prone.
Option C: Incorrect. Find and replace is used to locate and replace specific text, not to move text.
Option D: Incorrect. There is a correct method among the given options.

8. In Excel which of the following is an absolute cell reference?

Correct Answer: Correct answer is: (B) $A$1.

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

Difficulty: Easy

Concept notes: In Excel, an absolute cell reference is used to lock a cell reference so that it does not change when copied to other cells. This is indicated by the dollar sign ($) before both the column letter and the row number.

Common Mistakes: A common mistake is to confuse relative cell references (e.g., A1) with absolute cell references (e.g., $A$1). Relative references change when copied, while absolute references do not.

Explanations: The correct answer is $A$1 because the dollar signs before both the column letter and the row number indicate that both the column and row are fixed. This means that when the formula is copied to another cell, the reference to cell A1 will not change.

Option Analysis:

Option A: !A!1 is not a valid cell reference format in Excel.
Option B: $A$1 is the correct absolute cell reference format in Excel.
Option C: #a#1 is not a valid cell reference format in Excel.
Option D: A1 is a relative cell reference, not an absolute one.

Mnemonic: Dollar signs lock, no change.

9. In Microsoft PowerPoint the following features allows you to view slides in a slide show without manually advancing each slide

Correct Answer: Correct answer is: (B) Setting slide times.

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

Difficulty: Moderate

Concept notes: In Microsoft PowerPoint, setting slide times allows the slides to automatically advance after a specified duration, enabling a smooth slide show without manual intervention.

Common Mistakes: A common misunderstanding is that transitions or build effects alone can automatically advance slides. While transitions and build effects enhance the visual presentation, they do not automatically advance slides without setting specific times.

Explanations: Setting slide times in PowerPoint allows the presentation to automatically advance to the next slide after a specified duration. This feature is particularly useful for creating an automated slide show where the slides change at predetermined intervals, ensuring a smooth and uninterrupted presentation.

Option Analysis:

Option A: Adding build effects can enhance the visual appeal of a slide but does not automatically advance slides.
Option B: Setting slide times allows the slides to automatically advance after a specified duration, making it the correct choice.
Option C: Adding transitions can make the transition between slides smoother but does not automatically advance slides without setting specific times.
Option D: While all options can enhance the presentation, only setting slide times allows for automatic advancement.

10. In Excel you can use the formula palette to

Correct Answer: Correct answer is: (B) Create and edit formulas containing functions.

Exam Relevance: Microsoft Office Specialist (MOS), CompTIA A+, Certified Administrative Professional (CAP)

Difficulty: Easy

Concept notes: The formula palette in Excel is a tool that allows users to create and edit formulas, including those that use functions.

Common Mistakes: A common misunderstanding is that the formula palette is used for formatting cells or copying ranges, which are functions of other tools in Excel.

Explanations: The formula palette in Excel is specifically designed to assist users in creating and editing formulas that include functions. This tool provides a user-friendly interface to select and insert functions, making it easier to build complex formulas without needing to memorize the syntax of each function.

Option Analysis:

Option A: The formula palette is not used for formatting cells. Formatting cells is done through the Home tab or the Format Cells dialog box.
Option B: The formula palette is used to create and edit formulas containing functions, which is the correct use of this tool.
Option C: Entering assumptions data is a general task and not specific to the formula palette. Data entry is typically done directly in the cells.
Option D: Copying a range of cells is done using the Copy and Paste functions, not the formula palette.

Frequently Asked Questions

What is application software?

Application software includes programs designed to perform specific tasks, such as Microsoft Office for document creation and editing, or Windows Media Player for media playback.

How can I use Excel to create formulas?

In Excel, you can create formulas by using the formula palette or typing directly into a cell. Formulas can perform calculations, manipulate text, and reference other cells.

What is an absolute cell reference in Excel?

An absolute cell reference in Excel is a reference that does not change when copied to another cell. It is denoted by a dollar sign before the column and row, such as $A$1.

What is presentation automation in PowerPoint?

Presentation automation in PowerPoint allows you to set slide timings and enable automatic slide advancement, which can be useful for creating self-running presentations or kiosks.

What are some examples of cross-platform applications?

Cross-platform applications are software that can run on multiple operating systems, such as Microsoft Office, which is available for Windows, macOS, and mobile devices.

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