In MS-Excel, which would you use to create a bar Diagram?

A. Edit, Chart
B. Insert, Chart
C. Tools, Chart
D. Format, Chart

Answer

Correct Answer: B. Insert, Chart

Detail about MCQs

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.

You can not link excel worksheet data to a word document?

A. With a Hyperlink
B. With the Right Drag Method
C. With the copy and paste special commands
D. With the copy and paste buttons on the standard toolbar

Answer

Correct Answer: A. With a Hyperlink

Detail about MCQs

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

When you link data maintained in an excel workbook to a word document?

A. The Word Document Contains a Reference to the Original Source Application
B. The word Document must Contain a Hyperlink
C, The Word Document can not be Edit
D. The Word Document contains a copy of the Actual Data

Answer

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

Detail about MCQs

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

In Microsoft Excel, a Data Series is defined as what?

A. A type of Chart
B. A Cell Reference
C. A Collection of Related Data
D. A Division of Results

Answer

Correct Answer: C. A Collection of Related Data

Detail about MCQs

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

Which function is used to calculate depreciation, rates of return, future values and payment amount?

A. Logical
B. Math & Trigonometry
C. Statistical
D. Financial

Answer

Correct Answer: D. Financial

Detail about MCQs

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.”

In MS Excel, NOT, AND, OR and XOR are?

A. Arithmetic Operators
B. Relational Operators
C. Logical Operators
D. None of these

Answer

Correct Answer: C. Logical Operators

Detail about MCQs

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.”

You accidently erased a record in the sheet. What command can be used to restore it immediately?

A. Insert
B. Undo
C. Replace
D. Redo

Answer

Correct Answer: B. Undo

Detail about MCQs

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.”

In MS-Excel, How do you tell one cell from another?

A. By letters
B. By Numbers
C. By its Address
D. By Color

Answer

Correct Answer: C. By its Address

Detail about MCQs

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”

1 2 3 21