Category: MS-Excel Mcqs

Correct Answer: B. Insert, Chart

In Microsoft Excel, To insert a bar chart open your excel workbook and select you data. You can do this manually using your mouse or you can select a cell in your range and press Ctrl + A to select the data automatically. Once your data is selected, click Insert, insert Column or Bar Chart.

Correct Answer: A. With a Hyperlink

The correct answer is: A. With a Hyperlink

While options B, C, and D all describe methods for linking Excel worksheet data to a Word document, using a hyperlink is not a direct method for linking Excel data to a Word document. Hyperlinks typically refer to external files or web pages, rather than linking specific data from one document to another. Therefore, option A is the correct choice as it is not a direct method for linking Excel data to a Word document

Correct Answer: A. The Word Document Contains a Reference to the Original Source Application

The correct answer is: When you link data maintained in an Excel workbook to a Word document, the Word document contains a reference to the original source application, typically Excel. This reference allows Word to dynamically update the data in the document if changes are made in the Excel workbook. Additionally, the Word document must contain a hyperlink to the Excel file for easy access. The Word document can be set to read-only to prevent accidental edits, ensuring the integrity of the linked data. Finally, the Word document may also contain a copy of the actual data from Excel, which can be updated automatically through the link. This method is commonly used to present and reference Excel data within a Word document while maintaining data accuracy and consistency

Correct Answer: C. A Collection of Related Data

In Microsoft Excel, a data series refers to a collection of related data. It could represent a set of values in a column, row, or a group of cells that are related to each other in some way, such as being part of the same dataset or category. It’s commonly used in charts to visualize and analyze data. So, the correct answer is: A Collection of Related Data

Correct Answer: D. Financial

The function used to calculate depreciation, rates of return, future values, and payment amount in MS Excel is the “Financial” function. This function category includes various financial calculations such as depreciation, interest rates, loan payments, and more. So, the correct answer is “Financial.”

Correct Answer: C. Logical Operators

In MS Excel, “NOT,” “AND,” “OR,” and “XOR” are examples of logical operators. These operators are commonly used in Excel formulas to perform logical comparisons and operations. So, the correct answer is “Logical Operators.”

Correct Answer: B. Undo

To restore the accidentally erased record in Excel immediately, you can use the “Undo” command. This command allows you to reverse the last action taken, effectively restoring the erased record. So, the correct answer is “Undo.”

Correct Answer: C. By its Address

In MS-Excel, you typically differentiate one cell from another by its address, which consists of a combination of letters and numbers representing the column and row intersecting at that cell. So, the correct answer is “By its Address”

Correct Answer: D. None of These

The default header for a worksheet typically includes elements like:

• Username
• Date and Time
• Sheet tab Name

So, the correct answer would be “None of These” as the header usually includes more than one of these options

Correct Answer: D. /

The question is asking about the symbol for division in MS-Excel, and it presents four options represented by different symbols: %, #, , and /. The correct symbol for division in MS-Excel is “/”, which is a forward slash. Therefore, option D is the correct answer