🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books

Application Software Quiz 8 (10 MCQs)

This quiz evaluates understanding of Excel and MS-Word functions, including Excel AutoSum, chart creation, data entry, and VBA in MS-Word. It tests skills in action reversal, user interface features, software functionality, and document customization. Concepts such as financial modeling, formula calculations, and macro creation are also covered.

Quiz Instructions

Select an option to see the correct answer instantly.

1. Which language does MS-Word use to create Macros?

Correct Answer: Correct answer is: (C) Visual Basic.

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

Difficulty: Easy

Concept notes: MS-Word uses Visual Basic for Applications (VBA) to create macros.

Common Mistakes: A common misunderstanding is that MS-Word might use other programming languages like C++ or Java for macros, but it specifically uses Visual Basic.

Explanations: MS-Word uses Visual Basic for Applications (VBA) to create macros. VBA is a specialized version of Visual Basic that is integrated into Microsoft Office applications, including Word. It allows users to automate tasks and create custom functions within the application.

Option Analysis:

Option A: Visual C++ is not used for creating macros in MS-Word. It is a programming language used for developing applications and software, but not for MS-Word macros.
Option B: Visual Java is not a recognized language for MS-Word macros. Java is a programming language, but it is not integrated into MS-Word for macro creation.
Option C: Visual Basic is the correct language used for creating macros in MS-Word. VBA, a subset of Visual Basic, is specifically designed for automating tasks within Microsoft Office applications.
Option D: This option is incorrect because Visual Basic is indeed used for creating macros in MS-Word.

2. Which tab is used to make a chart?

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

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

Difficulty: Easy

Concept notes: In application software, particularly in spreadsheet programs like Microsoft Excel, the "Insert" tab is used to add various elements such as charts, tables, images, and shapes to a worksheet.

Common Mistakes: A common misunderstanding is that the "Home" tab might be used to insert charts, but it primarily contains formatting and editing tools.

Explanations: The "Insert" tab in spreadsheet software provides a variety of options to add visual elements to a worksheet. Among these options, the chart feature allows users to create different types of charts and graphs to visually represent data. Therefore, the "Insert" tab is the correct choice for making a chart.

Option Analysis:

Option A: The "File" tab is used for managing the document, such as saving, opening, and printing, not for inserting charts.
Option B: The "Home" tab contains tools for formatting and editing text and cells, not for inserting charts.
Option C: The "Insert" tab is used to add various elements, including charts, to the worksheet.
Option D: This option is incorrect as the "Insert" tab is the correct choice for making a chart.

3. Ctrl + P

Correct Answer: Correct answer is: (D) Open Print Dialog box.

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

Difficulty: Easy

Concept notes: The keyboard shortcut Ctrl + P is commonly used in application software to initiate the print process, which typically opens the Print Dialog box.

Common Mistakes: A common misunderstanding is that Ctrl + P might be associated with other dialog boxes, such as the Paragraph or Page Format dialog boxes, which are typically accessed through different shortcuts or menu options.

Explanations: In application software, the Ctrl + P shortcut is designed to open the Print Dialog box, allowing users to configure and initiate the printing process. This shortcut is widely recognized and used across various applications, including word processors, web browsers, and other software that supports printing.

Option Analysis:

Option A: Ctrl + P does not open the Paragraph Dialog Box. This is typically accessed through the application's menu or another shortcut.
Option B: Ctrl + P does not open the Page Format Dialog Box. This is usually accessed through the application's menu or another shortcut.
Option C: Ctrl + P does not open the Save Dialog Box. The Save Dialog Box is typically opened using Ctrl + S or through the application's menu.
Option D: Ctrl + P opens the Print Dialog Box, which is the correct function of this keyboard shortcut in most application software.

Mnemonic: Print Prompt: P for Print

4. The first electronic spreadsheet was .....

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

Exam Relevance: Computer Science Exams, Information Technology Exams, Business Computing Exams

Difficulty: Easy

Concept notes: VisiCalc was the first electronic spreadsheet software, released in 1979.

Common Mistakes: A common mistake is confusing VisiCalc with other spreadsheet software names that sound similar, such as ViciCalc or Visycalk.

Explanations: VisiCalc was the pioneering electronic spreadsheet software, developed by Dan Bricklin and Bob Frankston. It was released in 1979 and was the first spreadsheet program to achieve widespread use. This software revolutionized personal computing by providing a powerful tool for financial modeling and data analysis.

Option Analysis:

Option A: Correct. VisiCalc was the first electronic spreadsheet.
Option B: Incorrect. ViciCalc is not a known electronic spreadsheet software.
Option C: Incorrect. Visycalk is not a known electronic spreadsheet software.
Option D: Incorrect. Spreadsheet is a generic term and not the name of the first electronic spreadsheet.

5. What is the UNdo button used for?

Correct Answer: Correct answer is: (B) To cancel the last action.

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

Difficulty: Easy

Concept notes: The UNdo button is a common feature in application software that allows users to reverse the most recent action they performed.

Common Mistakes: A common misunderstanding is that the UNdo button repeats the last action, which is incorrect. The UNdo button cancels the last action, not repeats it.

Explanations: The UNdo button is designed to reverse the most recent action performed by the user. This feature is particularly useful for correcting mistakes or reverting changes made in the application. It does not repeat the last action, which is a common misconception.

Option Analysis:

Option A: This is incorrect because the UNdo button does not repeat the last action; it cancels it.
Option B: This is correct because the UNdo button is used to cancel the last action performed by the user.
Option C: This is incorrect because the UNdo button does not delete the entire document; it only cancels the last action.
Option D: This is incorrect because the UNdo button does not save the document; it cancels the last action.

Mnemonic: UNdo: UNwind the last step.

6. How are ROWS in MS EXCEL spreadsheet named?

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

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

Difficulty: Very Easy

Concept notes: In MS Excel, rows are named using numbers, starting from 1 and increasing sequentially.

Common Mistakes: A common misunderstanding is that rows are named using letters, which is actually how columns are named.

Explanations: In MS Excel, rows are identified by numbers, starting from 1 and increasing sequentially. This is a fundamental aspect of the spreadsheet layout, where each row can be uniquely identified by its number. Columns, on the other hand, are named using letters, starting from A and increasing alphabetically.

Option Analysis:

Option A: Correct. Rows in MS Excel are named using numbers.
Option B: Incorrect. Letters are used to name columns, not rows.
Option C: Incorrect. Cells are the intersection of rows and columns, not the naming convention for rows.
Option D: Incorrect. Columns are named using letters, not rows.

Mnemonic: Rows are numbered, not lettered.

7. When I want to add a photo to a document, which menu should I look in?

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

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

Difficulty: Easy

Concept notes: In application software, the "Insert" menu is typically used to add elements such as photos, shapes, and other media to a document.

Common Mistakes: A common mistake is to assume that the "File" or "Edit" menu might be used to add a photo, but these menus are generally used for file management and editing functions, respectively.

Explanations: The "Insert" menu in application software is designed specifically for adding various elements to a document, including photos, images, and other media. This makes it the correct choice for inserting a photo into a document.

Option Analysis:

Option A: The "File" menu is used for file management tasks such as opening, saving, and printing documents, not for inserting content.
Option B: The "Edit" menu is used for editing functions such as cut, copy, and paste, not for inserting content.
Option C: The "Insert" menu is used for adding elements like photos, images, and other media to a document.
Option D: This option is incorrect as the "Insert" menu is the correct choice for adding a photo.

8. The small rectangular sections on spreadsheets used to enter data such as text, numbers or symbols and to perform calculations using formulas and functions.

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

Exam Relevance: Microsoft Excel, Google Sheets, CPA exams, CFA exams

Difficulty: Easy

Concept notes: In spreadsheet applications, cells are the basic units where data is entered and calculations are performed.

Common Mistakes: A common misunderstanding is that named cells or ranges are the basic units for data entry, but they are actually references to specific cells or groups of cells.

Explanations: Cells are the fundamental building blocks of a spreadsheet. They are the small rectangular sections where users can input data such as text, numbers, or symbols. Additionally, cells can be used to perform calculations using formulas and functions. This makes cells the correct answer as they are the primary units for data entry and manipulation in spreadsheet applications.

Option Analysis:

Option A: Correct. Cells are the basic units in a spreadsheet where data is entered and calculations are performed.
Option B: Incorrect. Named cells or ranges are references to specific cells or groups of cells, not the basic units for data entry.
Option C: Incorrect. Charts and graphs are visual representations of data, not the basic units for data entry.
Option D: Incorrect. Aspect ratio (AR) is a term related to the dimensions of an image or display, not a component of spreadsheet data entry.

9. What tab allows us to insert pictures?

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

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

Difficulty: Easy

Concept notes: In application software, particularly in word processing and presentation software, the "Insert" tab is used to add various elements such as pictures, shapes, charts, and other media to the document or slide.

Common Mistakes: A common misunderstanding is that the "Home" tab might be used for inserting pictures, but it primarily deals with formatting and editing text.

Explanations: The "Insert" tab in application software like Microsoft Word or PowerPoint is specifically designed for adding various elements to the document or presentation, including pictures. This tab provides a dedicated section for inserting images, ensuring that users can easily add visual content to their work.

Option Analysis:

Option A: Correct. The "Insert" tab is used for adding pictures and other media.
Option B: Incorrect. The "Home" tab is primarily for formatting and editing text, not for inserting pictures.
Option C: Incorrect. The "Design" tab is typically used for customizing the overall look and layout of the document or slide, not for inserting pictures.
Option D: Incorrect. The "Animation" tab is used for adding animation effects to elements in the document or slide, not for inserting pictures.

10. In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?

Correct Answer: Correct answer is: (C) Auto sum.

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

Difficulty: Easy

Concept notes: In Excel, the AutoSum feature is a tool that allows users to quickly sum a range of data by clicking a button.

Common Mistakes: A common mistake is confusing AutoSum with other Auto features like AutoFill or AutoCorrect, which have different functions.

Explanations: AutoSum is specifically designed to sum a range of data quickly. When you select a range of cells and click the AutoSum button, Excel automatically adds the SUM function to the selected cell, which calculates the total of the selected range. This feature is particularly useful for large datasets where manual summation would be time-consuming.

Option Analysis:

Option A: AutoFill is used to fill cells with a series of data, not to sum data.
Option B: AutoCorrect is used to correct spelling and grammar, not to sum data.
Option C: AutoSum is the correct tool for summing a range of data.
Option D: AutoFormat is used to apply formatting styles to cells, not to sum data.

Frequently Asked Questions

What is application software?

Application software includes programs designed to perform specific tasks, such as word processing, spreadsheet calculations, and data management.

How can I use Excel for data summation?

Excel's AutoSum feature allows you to quickly sum a range of cells by selecting the range and clicking the AutoSum button, which automatically inserts the SUM formula.

What is VBA and how is it used in Excel?

VBA, or Visual Basic for Applications, is a programming language used to automate tasks in Excel. It allows users to create custom macros to perform complex operations.

How do I create a chart in Excel?

To create a chart in Excel, select the data range, go to the Insert tab, and choose the chart type you want. Excel will then generate the chart based on the selected data.

What is the purpose of the Undo button in Excel?

The Undo button in Excel allows you to reverse the last action performed, helping to correct mistakes or revert changes made to the spreadsheet.

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